1,在linux系统安装完mysql,使用默认密码登录mysql,报错
[root@192 mysql_pk]# mysql -uroot -p'y+0B_hzotqw7'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
解决办法:
第一步:
修改配置
[root@192 mysql_pk]# vim /etc/my.cnf
找到[mysqld]在任一行添加skip-grant-tables,设置成无密码登录
第二步:
登录
mysql -uroot -p*****
登陆成功,如果直接修改会报错
mysql> alter user 'root'@'localhost' identified by 'Aa123456#';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
第三步:
执行
mysql> flush privileges;
Query OK, 0 rows affected (0.07 sec)
然后修改密码:
mysql> alter user 'root'@'localhost' identified by '*********';
Query OK, 0 rows affected (0.05 sec)
再执行:
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)