linux 目录为 etc/my.cnf 在最后一行 添加skip-grant-tables
1、输入mysql -u root -p 然后回车
2、 输入 use mysql;
3、输入update user set password=password("这里填写要设置的密码") where user="root";
密码设置成功之后,此时的密码还没有生效,还需要刷新一下权限(这一步也是关键的)
4、输入 flush privileges; (注意结尾有分号;),然后回车
5、重启mysql : service mysqld restart;
- localhost password Access denied MySQLlocalhost password access denied 39 password access denied localhost ubuntu access denied 39 localhost access denied 39 localhost password access localhost password密码access localhost方法access denied localhost password方法access maxwell mysql access denied 39 sqlexception localhost password