环境安装
基于系统环境:
[root@localhost ~]$cat /etc/redhat-release
CentOS Linux release 7.6.1810 (Core)
安装mariadb客户端和服务端:
[root@localhost ~]$yum install mariadb-server mariadb
配置
禁止ip反解:
/etc/my.cnf配置文件mysqld块里加上skip_name_resolve=ON
应用
启动mysql服务,并设置为开启启动:
[root@localhost ~]$systemctl start mariadb.service
[root@localhost ~]$systemctl enable mariadb.service
执行安全加固脚本:
[root@localhost ~]$mysql_secure_installation
root身份登陆mysql:
[root@localhost ~]$mysql -uroot -p
列出用户列表:
MariaDB [(none)]> SELECT user,host,password FROM mysql.user;
创建用户:
MariaDB [(none)]> CREATE USER '9527'@'192.168.1.%' IDENTIFIED BY '111111';
显示当前以哪个用户登陆:
MariaDB [test]> SELECT user();
列出某个用户的权限:
MariaDB [(none)]> SHOW GRANTS FOR '9527'@'192.168.1.%';
给用户授权:(这里给了select权限)
MariaDB [(none)]> GRANT SELECT ON test.students TO '9527'@'192.168.1.%';
撤销某个用户某个权限:
MariaDB [(none)]> REVOKE SELECT ON test.students from '9527'@'localhost';
远程登陆:
[root@localhost ~]$mysql -u9527 -p -h192.168.1.22
切换数据库:
MariaDB [(none)]> USE test;
查看创建表的sql语句:
MariaDB [test]> SHOW CREATE TABLE students;