- 远程无法链接到MySql, 是因为登录的帐号没有权限
赋予权限, GRANT ALL PRIVILEGES ON *.* TO root;
- 重新创建MySQL实例失败
没完全卸载MySql, 需要到注册表中删除:
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 目录删除;
- 修改root的密码
UPDATE USER SET PASSWORD = "password" WHERE USER = 'root';