MysqL用户操作

环境准备

准备一台Centos7服务器

系统： Centos7.3

内存：1G

cpu： 2核

IP地址:10.0.0.42

# 首先安装数据库
yum -y install mariadb mariadb-server
# 安装完后启动数据库服务
systemctl start mariadb
# 查看数据库服务启动状态，如果有running代表启动成功
systemctl status mariadb
# 登录至数据库，因为是新安装的没有密码
mysql

#  创建用户
create user tom@'localhost';
#  授权
grant select,insert,update,delete,alter,drop on *.* to tom@'localhost' identified by '123';
#  查询用户的权限
select * from mysql.user where User='tom' \G;

# 也可以查看用户的权限
MariaDB [test]> show grants for tom@'localhost';
+--------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for tom@localhost                                                                                                                         |
+--------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, DROP, ALTER ON *.* TO 'tom'@'localhost' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' |
+--------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
# 收回用户的权限
MariaDB [test]> revoke delete,drop on *.* from tom@'localhost';
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> show grants for tom@'localhost';
+------------------------------------------------------------------------------------------------------------------------------------+
| Grants for tom@localhost                                                                                                           |
+------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, ALTER ON *.* TO 'tom'@'localhost' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' |
+------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> 

#  查询慢查询日志
MariaDB [test]> show variables like '%long_query_time%';
+-----------------+-----------+
| Variable_name   | Value     |
+-----------------+-----------+
| long_query_time | 10.000000 |
+-----------------+-----------+
1 row in set (0.00 sec)

MariaDB [test]> 

# 查询所有的日志
show variables like '%log%';