卸载mysql
1.先停止MySQL服务
2.程序中卸载MySQL
3.到安装目录删除MySQL
4.删除:C:\Documents and Settings\All Users\Application Data\MySQL
C:\ProgramData\MySQL
5.查看注册表:
HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Application/MySQL
HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Application/MySQL
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Application/MySQL
============================
重启电脑,直接重新安装即可
开放mysql数据库的外部连接
直接在Navicat Premium可视化工具里新建查询,然后依次执行下列代码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
完成之后,外部可连接。