MYSQL 远程访问-命令修改

1、修改mysql可以远程访问

在运行这个命令时，密码不能为空

修改密码

格式如下（其中，USER为用户名，PASSWORD为新密码）

mysqladmin -u USER -p password PASSWORD

然后进入mysql

mysql -u root -p 

mysql> use mysql;
Database changed
mysql> select user,host from user;
+------+-------------------+
| user | host |
+------+-------------------+
| root | 127.0.0.1 |
| root | ::1 |
| | localhost |
| root | localhost |
| | vincent-guo.local |
| root | vincent-guo.local |
+------+-------------------+
6 rows in set (0.00 sec)

mysql> update user set host='%' where user='root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.05 sec)

mysql> select user,host from user;
+------+-------------------+
| user | host |
+------+-------------------+
| root | % |
| root | 127.0.0.1 |
| root | ::1 |
| | localhost |
| | vincent-guo.local |
| root | vincent-guo.local |
+------+-------------------+
6 rows in set (0.00 sec)

 

转载于:https://www.cnblogs.com/vincent-guo/p/3484999.html