mysql初次命令行安装登录时报错:
未输入密码:ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)
或者
输入密码错误:ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
mysql初次登录报错(命令行安装会生成随机密码)
mysql安装成功后创建的超级用户‘root‘@‘localhost‘的密码会被存储在/var/log/mysqld.log
查看方法:
grep ‘temporary password‘ /var/log/mysqld.log
复制这个密码,登录mysql -u root -p ,即可登录成功。
登录成功后,执行不了任何操作,报错,要求修改初始密码:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
命令行修改root密码:
mysql命令:alter user ‘root‘@‘localhost‘ identified by ‘123456‘;
原文:https://www.cnblogs.com/wxywxy/p/10768980.html