How MySQL authorizes remote IP connections

The newly installed MySQL is the default does not account for remote access permission, also can not external connection mysql. This is inconvenient for data that you want to remotely call MySQL. Let's look at how to set up a MySQL database that allows remote connections.

Login to MySQL

Mysql-uroot-p

If you cannot log in you can use Find/-name MySQL to search the MySQL program path, such as the MySQL program path:/usr/local/mysql/bin/mysql, we can log in:

/usr/local/mysql/bin/mysql-uroot-p

Execute the following command:

Grant all privileges in *.* to ' root ' @ ' 192.168.0.1 ' identified by ' Root-password ';

Flush privileges;

Exit

192.168.0.1 is the client IP that connects to the MySQL server, and if all is specified, it is expressed in%.