centOS下进入mysql报错-You must SET PASSWORD before executing this statement

解决办法:

mysql>  SET PASSWORD = PASSWORD(‘123456‘);
Query OK, 0 rows affected (0.03 sec)
mysql> create database roger;
Query OK, 1 row affected (0.00 sec)
也就是用mysql>  SET PASSWORD = PASSWORD(‘123456‘);这句话重新设置一次密码!

centOS下进入mysql报错-You must SET PASSWORD before executing this statement,布布扣,bubuko.com

centOS下进入mysql报错-You must SET PASSWORD before executing this statement

上一篇:centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


下一篇:MySQL Cluster 详细配置文件(config.ini)