mysql 远程访问

mysql 远程访问
mysql -hlocalhost -uroot -proot
mysql> use mysql
Database changed
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
 
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
 
mysql> SELECT HOST,USER FROM USER;
+-----------+------+
| HOST | USER |
+-----------+------+
| % | root |
| 127.0.0.1 | root |
| ::1 | root |
| localhost | root |
+-----------+------+
4 rows in set (0.00 sec)
 
mysql>
posted @ 2022-05-24 08:54  xiondun  阅读(20)  评论(0编辑  收藏  举报