mysql5.7版本语法:SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password123');
mysql5.7之后版本语法: ALTER user 'root'@'localhost' IDENTIFIED BY 'password1'
mysql> CREATE USER 'test'@'localhost' IDENTIFIED BY 'pwd123456';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost' WITH GRANT OPTION;
mysql> CREATE USER 'test'@'%' IDENTIFIED BY 'pwd123456';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' WITH GRANT OPTION;
Navicat 无法连接
查看用户信息
mysql> select host,user,plugin,authentication_string from mysql.user;
mysql> ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'pwd123456';
mysql> ALTER USER 'test'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pwd123456';