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)