Allow external ip addresses to access your mysql database in linux

Allow external ip addresses in linux 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; www.2cto.com 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. www.2cto.com '%' indicates the ip address that allows access to mysql. You can also configure the specific ip name; % indicates that all ip addresses can be accessed; followed by 'xxx' is the root user's password; Author: xc635960736