mysql新增用户

新增用户分为3步骤

1.root  登陆

mysql -uroot -p 

2. 查看数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

查看用户

mysql> select user,host from user;
+------+-----------------------+
| user | host                  |
+------+-----------------------+
| root | %                     |
| root | 127.0.0.1             |
| root | localhost             |
| root | localhost.localdomain |
+------+-----------------------+
4 rows in set (0.00 sec)

3.比如我想添加一个 zabbix用户

mysql> CREATE USER 'zabbix'@'%' IDENTIFIED BY 'broadtech';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'%' IDENTIFIED BY 'broadtech' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> 
mysql> select user,host from user;
+--------+-----------------------+
| user   | host                  |
+--------+-----------------------+
| root   | %                     |
| zabbix | %                     |
| root   | 127.0.0.1             |
| root   | localhost             |
| root   | localhost.localdomain |
+--------+-----------------------+
5 rows in set (0.00 sec)

比如我添加lte_v1 用户

mysql> CREATE USER 'lte_v1'@'%' IDENTIFIED BY 'broadtech';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'lte_v1'@'%' IDENTIFIED BY 'broadtech' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> select user,host from user;
+--------+-----------------------+
| user   | host                  |
+--------+-----------------------+
| lte_v1 | %                     |
| root   | %                     |
| zabbix | %                     |
| root   | 127.0.0.1             |
| root   | localhost             |
| root   | localhost.localdomain |
+--------+-----------------------+
6 rows in set (0.00 sec)

当然权限设置，通过update user 来设置

记得刷新。