mysql> create user 'mysql'@'127.0.0.1' identified by 'mysql123';
Query OK, 0 rows affected (0.02 sec)
mysql> grant all on *.* to 'mysql'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)
该例子创建一个用户mysql,密码是mysql123
把所有权限赋给mysql
mysql> create user 'mysql'@'127.0.0.1' identified by 'mysql123';
Query OK, 0 rows affected (0.02 sec)
mysql> grant all on *.* to 'mysql'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)
该例子创建一个用户mysql,密码是mysql123
把所有权限赋给mysql