mysql remote connection mysql database server

mysql remote connection mysql database server 


 Connect to a remote web server, but the connection is always prompt is not allowed to connect to the server, I have read that there is no limit on the server, the firewall off, but still this solution to the problem is as follows: 

Run: mysql> GRANT ALL ON *. * To name @ localhost identified by 'name'; 

If you want this mysql user to allow a visit from the IP can change localhost to the IP, if you want to allow access to a host name, host name can be changed to allow all remote access, it seems blank can (not tested).



Run: mysql> GRANT ALL PRIVILEGES ON *. * To root @ "%" identified by '12345 'with grant Option your; 


The above command creates a super account from any machine logged in as root and the password is 12345. In this way, the easy to use graphical tool login and operations, including change the root password.