MySQL 根密码更改
我一直在尝试重置我的 MySQL 根密码.我已经运行了 mysqld_safe --skip-grant-tables，更新了 root 密码，并检查了用户表以确保它在那里.
I have been trying to reset my MySQL root password. I have run mysqld_safe --skip-grant-tables, updated the root password, and checked the user table to make sure it is there.
重新启动 MySQL 守护程序后，我尝试使用我刚刚设置的新 root 密码登录，但仍然因用户root"错误而获得访问被拒绝.我也尝试过完全删除并重新安装 MySQL(包括删除 my.cnf 文件)，但仍然没有运气.我接下来可以做什么?
Once restarting the MySQL daemon I tried logging in with the new root password that I just set and still get Access denied for user 'root' errors. I have also tried completely removing and reinstalling MySQL (including removing the my.cnf file) and still no luck. What can I do next?
推荐答案
我找到了！我更改密码时忘记对密码进行哈希处理.我用这个查询来解决我的问题:
I found it! I forgot to hash the password when I changed it. I used this query to solve my problem:
update user set password=PASSWORD('NEW PASSWORD') where user='root';
我忘记了 PASSWORD('NEW PASSWORD')，只是以纯文本形式输入新密码.
I forgot the PASSWORD('NEW PASSWORD') and just put in the new password in plain text.
相关文章