mysql安装不知道root密码是多少_mysql-community-server安装完后不知道root密码

修改方法：

service mysqld stop

mysqld_safe --skip-grant-tables &

mysql -u root

use mysql;

update user set authentication_string=password('1111') where user='root';

flush privileges;

quit

service mysqld restart

或者用 /etc/init.d/mysql start启动

启动后用命令建数据库是还是会提示需要新设置密码 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

用：SET PASSWORD = PASSWORD('123456') 设置密码时又提示：ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

原因是密码验证规则问题，用 set global validate_password_policy=0; 修改后成只验证长度，再执行：

SET PASSWORD = PASSWORD('123456') 就成功了。