mysql8创建用户 修改密码
useradd root
passwd root
mysql> CREATE USER root@‘%’ IDENTIFIED BY ‘MyNewPass4!’;
Query OK, 0 rows affected (0.06 sec)
mysql>
mysql> GRANT ALL ON . TO ‘root’@‘%’;
Query OK, 0 rows affected (0.02 sec)
mysql> ALTER USER ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘MyNewPass4!’;
Query OK, 0 rows affected (0.06 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql>
