Linux under 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;