实训day21

glibc安装

装包解压
[root@zhu ~]# yum list installed | grep libaio

libaio.x86_64                         0.3.109-13.el7                   @anaconda

[root@zhu ~]#

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.33-linux-glibc2.12-x86_64.tar

[root@zhu ~]# tar -xvf mysql-8.0.33-linux-glibc2.12-x86_64.tar

mysql-test-8.0.33-linux-glibc2.12-x86_64.tar.xz

mysql-8.0.33-linux-glibc2.12-x86_64.tar.xz

mysql-router-8.0.33-linux-glibc2.12-x86_64.tar.xz

[root@zhu ~]# tar -xvf mysql-8.0.33-linux-glibc2.12-x86_64.tar.xz

[root@zhu ~]# ls mysql-8.0.33-linux-glibc2.12-x86_64

bin  docs  include  lib  LICENSE  man  README  share  support-files

[root@localhost ~]# mv mysql-8.0.33-linuxglibc2.12-x86_64/ /mysql8

[root@localhost ~]# ls /mysql8/

bin  docs  include  lib  LICENSE  man  README  share  support-files

指定不可登录
[root@zhu ~]# useradd -r -s /sbin/nologin mysql

[root@zhu ~]# id mysql

uid=997(mysql) gid=994(mysql) 组=994(mysql)

[root@zhu ~]#

创建文件
[root@localhost mysql8]# chown mysql:mysql mysqlfiles/

[root@localhost mysql8]# chmod 750 mysql-files/

初始数据库
[root@zhu mysql-8.0.33-linux-glibc2.12-x86_64]# ./bin/mysqld --initialize  --user=mysql -basedir=/mysql-8.0.33-linux-glibc2.12-x86_64/

[root@localhost mysql8]# cp supportfiles/mysql.server /etc/init.d/mysql8

[root@localhost mysql8]# ls /etc/init.d/mysql8

/etc/init.d/mysql8

[root@localhost mysql8]# ls /etc/init.d/

functions mysql8 mysql8ls netconsole network README

[root@localhost mysql8]#

二、密码安全策略

1、查看密码策略

修改策略
mysql> set global validate_password.length=0;

mysql> set global validate_password.policy=LOW;

三、⽤户

1、创建⽤户

mysql> create user 'efg'@'%' identified by 'efg';

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql> create user 'efgh'@'%' identified by 'efgh';

Query OK, 0 rows affected (0.01 sec)

2删除用户

mysql> drop user 'zhangmin';

Query OK, 0 rows affected (0.02 sec)

修改用户
mysql> alter user 'zhangmin' identified by 'abc123';

Query OK, 0 rows affected (0.01 sec)

创建角色
mysql> create role 'a';

Query OK, 0 rows affected (0.00 sec)

权限
1、刷新权限

mysql> create role 'a';

Query OK, 0 rows affected (0.00 sec)

2、为root账户刷新权限

mysql> grant system_user on *.* to "root";

3、修改权限

mysql> show grants for "efgh";

删除权限
mysql> revoke all on *.* from "efgh";

Query OK, 0 rows affected (0.00 sec)