安装好mysql企业版之后出现的错误解决
一 .先添加一个登陆进去的密码
# mysqladmin -u root password 123
#mysql -uroot -p123
二. 登陆进去之后发现看数据库发现需要重新密码
mysql> create database aaa;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
解决:
mysql> SET PASSWORD = PASSWORD('123456');
Query OK, 0 rows affected (0.03 sec)
mysql> create database aaa;
Query OK, 1 row affected (0.00 sec)
也就是用mysql> SET PASSWORD = PASSWORD('123456');这句话重新设置一次密码