mysql账号问题

Navicat 提示

Access violation at address ***(如004ECCF4） in module ‘navicat.exe’. Read of address ***(如00000048）

解决：这是内存越界的问题，需要重新注册Windows的动态链接库。方法如下：

运行 -> cmd，然后在命令行中输入：

for %1 in (%windir%\system32\*.dll) do regsvr32.exe /s %1 

最后回车运行，问题得以解决。

修改root账户密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

修改权限:

grant all privileges on *.* to 'root'@'192.168.0.196' identified by 'password';
grant all privileges on *.* to 'root'@'localhost' identified by 'password';
grant all privileges on *.* to 'root'@'%' identified by 'password';
grant all privileges on *.* to root@localhost identified by 'password&#