新安装mysql没有密码,输入登录命令
# mysql -u root -p
Enter password:
出现错误
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
百度这个错误,解决方法是重设密码
# mysql -u root -p password 'newpassword'Enter password:
结果又出现相同错误
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'于是继续百度,找到解决方法:将mysqld服务关闭,这里要注意一点,mysql和mysqld分别是客户端和服务器端的程序,这里选择关闭mysqld,
并跳过安全限制。
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root' and host='root' or host='localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit
# service mysqld restart
成功重设密码,现在可以登录mysql了
# mysql -uroot -pEnter password: <输入新设的密码newpassword>