Linux under MySQL allow external remote access configuration

MySQL remote access We see most of the Internet is directly to the MySQL database authorization, but some friends found that the tutorial is still unable to connect to MySQL, the following small series for you to introduce a Linux under the MySQL Allow external remote access configuration

　　Setting up a MySQL configuration file

/etc/mysql/my.cnf

Find Bind-address =127.0.0.1 to comment it out;//function is to make it no longer allowed only local access;

Restart Mysql:/etc/init.d/mysql restart;

　　Access to MySQL Database

Mysql-u root-p

Mysql>grant all privileges in *.* to root@ '% ' identifies by ' XXXX ';

The first * represents the database name, the second * represents the table name of the database, and if *.* as above, it means that all tables to the database are allowed access;

'% ': to allow access to MySQL IP address, of course, you can also configure the specific to the IP name,% of all IP can be accessed;

Back to ' xxxx ' is the root user of the password;