Mysql remote access permission

Mysql remote access permission

1. Change table

Mysql> use mysql;

Mysql> update user set host = '%' where user = 'root ';

2. Authorization Law

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;

Refresh

FLUSH PRIVILEGES