Mysql数据库管理

最新推荐文章于 2023-05-10 15:56:19 发布

Mr.Ron

最新推荐文章于 2023-05-10 15:56:19 发布

阅读量865

点赞数

分类专栏： linux 文章标签： mysql 数据库 mariadb

本文链接：https://blog.csdn.net/weixin_38787592/article/details/124973800

版权

一、MySQL 用户账号管理

1、新建用户

格式:

CREATE USER ‘用户名’@’来源地址’ [IDENTIFIED BY [PASSWORD] ‘密码’];

示例:

mysql> select user,host,password from mysql.user;

+---------+--------------+-------------------------------------------+
| user    | host         | password                                  |
+---------+--------------+-------------------------------------------+
| root    | localhost    | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root    | mysql-master | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root    | 127.0.0.1    | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root    | ::1          | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root    | 192.168.0.85 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| linuxli | localhost    | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| linuxli | %            | *E56A114692FE0DE073F9A1DD68A00EEB9703F3F1 |
| linuxli | 192.168.0.93 | *E56A114692FE0DE073F9A1DD68A00EEB9703F3F1 |
+---------+--------------+-------------------------------------------+
8 rows in set (0.00 sec)

mysql> create user'admin'@'%' identified by '123456';

Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,password from mysql.user;

+---------+--------------+-------------------------------------------+
| user    | host         | password                                  |
+---------+--------------+-------------------------------------------+
| root    | localhost    | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root    | mysql-master | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root    | 127.0.0.1    | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root    | ::1          | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root    | 192.168.0.85 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| linuxli | localhost    | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| linuxli | %            | *E56A114692FE0DE073F9A1DD68A00EEB9703F3F1 |
| linuxli | 192.168.0.93 | *E56A114692FE0DE073F9A1DD68A00EEB9703F3F1 |
| admin   | %            | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+---------+--------------+-------------------------------------------+
9 rows in set (0.00 sec)

2、删除用户

格式:

DROP USER ‘用户名’@’来源地址’;

示例:

mysql> drop user'admin'@'%';

Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,password from mysql.user;

+---------+--------------+-------------------------