linux命令行添加mysql用户
**创建mysql用户**
使用如下命令创建一个用户名和密码分别为"myuser"和"mypassword"的用户。
```
mysql> CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';
```
运行下列命令，验证帐号是否创建成功
```
mysql> SELECT host, user, password FROM mysql.user WHERE user='myuser';
```
将全部的权限赋予所有数据库/表：
```
mysql> GRANT ALL ON *.* TO 'myuser'@'localhost';
```
修改权限
```
mysql> FLUSH PRIVILEGES;
```
内容参考：[http://www.jb51.net/article/68595.htm](http://www.jb51.net/article/68595.htm)
评论区