Mysql – Cannot connect to a MySql Server using MySql Workbench with no apparent reason

debianMySQLsql

I can't connect via TCP/IP to the MySQL server.

The server is installed in a Debian Linux and there's a PostGreSQL server running at the same time. (which is working fine and has tcp/ip connection btw)

But everytime I try to remotely connect to the MYSQL server I get the following:

Connecting to MySQL server 172.29.85.188...
Access denied for user 'root'@'172.29.70.25' (using password: YES)

Am I missing something here? I can log in fine if I run a SSH connection to the server. I also DID change the mysql.conf file to remove the BLINDIP setting.

btw: I tried also using the line

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY '1234';

I get a reply:

Query OK, 0 rows affected (0.00 sec)

And still no remote access. (I'm pretty sure the 0 rows affected has something to do with it)

Best Answer

The only solution I found was reformating the server. Not the best answer, but due to time constrains I couldn't do anything else.

Related Topic