mysql修改root密码

修改mysql初始化密码

连接Mysql

mysql -u root -p123456
Enter password

设置密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

删除Mysql密码校验(默认不能使用简单密码)

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)

修改远程登录

MySQL>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

赋予任何主机访问数据的权限 

MySQL>FLUSH PRIVILEGES;

修改生效