首先登录到客户端界面,点击用户,弹窗提示输入用户名,主机,密码(输入新密码),确认密码即可,也可点击数据库名称鼠标右键然后选择命令列界面, set password = password("你想要改成的密码"); 这两种方式感觉都要比cmd界面(1)mysql -u root -p(2)Enter password: (3) set password for `root`@`localhost`=password(`admin123`);修改简单方便。而且cmd方式还一不注意容易出报错ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'passw ord(`admin123`)' at line 1 不过cmd这个ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';挺有效!!!希望能帮助到您!
Navicat客户端修改mysql密码很简单的方式
最新推荐文章于 2024-07-30 17:03:01 发布