[ZT] mysql-front connection to MySQL service on Linux platform

Apache + PHP + MySQL has been successfully established in windows, but it is not authentic. Of course, this may be very related to my Linux plot, I always want to build the server on the Linux platform, which is more orthodox, not to mention that these three software originally belongs to the Linux platform. However, after the establishment, I found that there was no better UI Management Software except phpMyAdmin. After searching for a while, I found a MySQL-Front (on the home page, he had a legal relationship with MySQL, the update has been stopped.) After downloading, I feel that the application on the Windows Server is still relatively good. Now I want to connect to MySQL on the Linux platform, but it was not successful at first. I went online for a while, I finally found this. Post it and share it with friends who unfortunately pass by here. :)

[Reprinted below]

Question:

The mysql5.0.18 running server is installed in Hongqi linux5.0. You can run the client in win2003 (graphical interface MYSQL-FRONT) to log on to the server, the error is: Error 1130: Host '192. 168.0.235 'is not allowed to connect to this MySQL Server why does it not allow the win2003 client to connect to the MySQL server?

Solution:

First, use update to change the root host in MySQL. User from localhost to %:

Mysql>; update mysql. User set host = '%' where host = 'localhost'

Mysql>; grant all privileges on *. * to root @ "%"

Mysql>; flush privileges;

Connection again. The connection is successful.