mysql彻底卸载-增加远程权限-修改root密码

mysql 彻底卸载

1,到控制面板里面先把mysql删除.


2.到c盘C:\Program Files目录下把mysql目录删除.


3.如果在其他盘还有设置目录也要删除.空目录也要删除


4.到regedit把注册表


HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL


HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL


HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL


有的话,全部删除！

mysql 远程权限开启

1, 登录 Mysql-Server 连接本地 mysql (默认只允许本地连接)

2, 修改 Mysql-Server 用户配置

mysql> USE mysql; -- 切换到 mysql DB

Database changed

mysql> SELECT User, Password, Host FROM user; -- 查看现有用户,密码及允许连接的主机

+------+----------+-----------+
| User | Password | Host      |
+------+----------+-----------+
| root |          | localhost |
+------+----------+-----------+
1 row in set (0.00 sec)

mysql> update user set host = '%' where user = 'root';

修改mysql root 密码

mysql> use mysql
 
Database changed
 
mysql> update user set password=PASSWORD('123456') where user='root';
 
Query OK, 0 rows affected (0.00 sec)
 
Rows matched: 1  Changed: 0  Warnings: 0
 
mysql> flush privileges;
 
Query OK, 0 rows affected (0.00 sec)</span>