好久没有使用MySQL,导致不知道如何使用cmd进入,文档记录
cmd->cd MySQL目录下的bin文件夹
然后使用命令 net start mysql 启动服务
命令 mysql -u root -p 进行登录
远程连接 修改
mysql> update user set host ='%' where user ='root';
Query OK, 1 row affected (0.06 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select host, user from user;
+---------------+-------+
| host | user |
+---------------+-------+
| % | root |
| % | yy |
| 192.158.0.114 | xiong |
| 192.158.89.1 | yy |
+---------------+-------+
4 rows in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)