mysql主服务器ip_授权指定ip访问mysql 服务器

授权指定ip访问访问

授权ROOT使用密码1234从应用服务器主机连接到mysql服务器

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'xxx.xxx.xxx.xxx' IDENTIFIED BY '1234' WITH GRANT OPTION;

mysql> flush privileges;

MariaDB [(none)]>

MariaDB [(none)]>

MariaDB [(none)]> update mysql.user set host='localhost' where host='%';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [(none)]>

MariaDB [(none)]>

MariaDB [(none)]>

MariaDB [(none)]> flush privileges;

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> select host, user, password from mysql.user;

+-----------+------+----------+

| host | user | password |

+-----------+------+----------+

| localhost | root | |

| 127.0.0.1 | root | |

| ::1 | root | |

| localhost | | |

| localhost | pma | |

+-----------+------+----------+

5 rows in set (0.00 sec)

mysql授权任意地址访问

授权ROOT使用1234从任何主机连接到mysql服务器

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIEDBY '1234'WITH GRANT OPTION;

mysql> flush privileges;