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

来源：互联网发布：装小蜜知乎编辑：程序博客网时间：2024/05/02 02:32

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 DBDatabase changedmysql> 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>

0 0