MySQL Forums
Forum List  »  MySQL Workbench

Unable to connect to localhost
Posted by: Davide Mancosu
Date: December 15, 2020 05:23AM

Hi,

I moved MySQL Workbench from version 6.3 to version 8.0.

The connection to MySQL server 5.1.73 which worked with WB 6.3 now does not work with WB 8.0. Both with SSH connection and with TCP/IP.

In WB 8.0 I created a new connection to a MySQL server 8.0 and it works.

In MySQL Server 5.1.73 I have a user admin:
> CREATE USER 'admin'@'%' IDENTIFIED BY 'xxxxxxxxx';
> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;
> FLUSH PRIVILEGES;
> CREATE USER 'admin'@'localhost' IDENTIFIED BY 'xxxxxxx';
> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
> FLUSH PRIVILEGES;

and in /etc/my.cnf
[mysqld]
bind-address=0.0.0.0

Using SSH connection the returned error is:
"Your Connection attempt failed for user 'admin' to the MySQL server at 127.0.0.1:3306:
Unable to connect to localhost"

Using TCP/IP connection the returned error is:
"Failed to Connect to MySQL at xxx.xxx.xxx.xxx:3306 with user admin
Unable to connect to localhost"

There's a problem versioning? WB 8.0 is not compatible with MySQL 5.1.73? Or is a configuration problems?

Thanks in advance
Regards
Davide

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to connect to localhost
6046
December 15, 2020 05:23AM
1719
December 15, 2020 05:59AM
1378
December 15, 2020 11:05AM
1202
December 15, 2020 11:09AM
1109
February 03, 2021 07:55PM
550
February 04, 2021 12:20AM
1178
December 16, 2020 01:30PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.