授权指定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;