Allow external ip addresses in linux to access your mysql database _ MySQL

In linux, allow external ip addresses to access your mysql database bitsCN. allow external ip addresses in comlinux to access your mysql database 1: Set the mysql configuration file/etc/mysql/my. cnf, find bind-address = 127.0.0.1, and comment it out. // This function no longer allows local access only. restart mysql:/etc/init. d/mysql restart; 2: enter mysql database mysql-u root-p mysql> grand all privileges on *. * to root @ '%' identifies by 'XXX'; the first * indicates the database name; the second * indicates the table name of the database; if it is like the preceding *. * indicates that access is allowed from all tables to the database. '%' indicates the ip address that is allowed to access mysql. of course, you can also configure the specific ip address; % indicates that all ip addresses can be accessed, followed by 'XXX' as the root user's password, and xc635960736bitsCN.com