Remote User connection to mysql authorization _ MySQL

Remote connection to mysql to authorize bitsCN.com

Remote User connection to mysql authorization

Authorization law:

Run the following command on the machine where mysql is installed:

1. d:/mysql/bin/> mysql-h localhost-u root

// You can access the MySQL server.

2. mysql> grant all privileges on *. * TO 'root' @ '%' WITH GRANT OPTION

// Grant data access permissions to any host

For example, if you want myuser to use mypassword to connect to the mysql server from any host.

Grant all privileges on *. * TO 'myuser' @ '%' identified by 'mypassword' with grant option;

If you want to allow myuser to connect to the mysql server from a host whose ip address is 192.168.1.6, and use mypassword as the password

Grant all privileges on *. * TO 'myuser' @ '192. 168.1.3 'identified BY 'mypassword' with grant option;

3. mysql> FLUSH PRIVILEGES

// The modification takes effect.

4. mysql> EXIT

BitsCN.com