将密码改成123456 update
mysql.
user
set
authentication_string=
password
(
'123456'
)
where
user
=
'root'
and
Host =
'localhost'
;
将密码改成空 update
mysql.
user
set
authentication_string=
password
(
''
)
where
user
=
'root'
and
Host =
'localhost'
;
这个修改的就是刚进mysql console 需要输入的密码, 也是navcat里创建连接所要用到的密码
记得重启服务器