Mysqlfront cannot connect to the Mysql Server & quot; 192.168.5. * & _ MySQL

Mysqlfront cannot connect to the Mysql server; quot; 192.168.5. * amp; quot; solves bitsCN.com

Mysql front cannot connect to Mysql server "192.168.5. *"

First question

Problem description:

Mysql5.0 and mysqlodbc3.51 establish a connection: you cannot establish a system dsn to access the "mysql" database. (The password for the root account is correct. you can log on normally under cmd)

Is the following error

[MySQL] [ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL client

Solution:

Set password for username @ localhost = OLD_PASSWORD ('password'); or UPDATE mysql. user SET Password = OLD_PASSWORD ('password') WHERE Host = 'localhost' AND User = 'root ';

Second question:

Problem description:

Use mysql-front to remotely connect to the database, but mysql front cannot connect to Mysql server "192.168.5 .*"

And so on:

Solution:

Remote authorization:

Grant all privileges on *. * to 'root' @ '%' identified by '000000'; 123456 of them is the database password flush privileges;

If the problem persists, first check whether Port 3306 is correct and then disable the firewall;

BitsCN.com