mysql数据库初始化后初次登录需要修改密码
初次登录会碰到下面这个错误
ql> alter user root identified by ‘password’;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
需要使用下面的命令来修改密码
mysql> alter user user() identified by ‘password’;
Query OK, 0 rows affected (1.43 sec)