枫の屋

1
yum install mysql-community-server

1
Loading mirror speeds from cached hostfile
2
没有可用软件包 mysql-community-server。
3
错误：无须任何处理

1
# 启动
2
systemctl start mysqld
3

4
# 第一次启动后，可以查看mysql初始化密码
5
grep 'temporary password' /var/log/mysqld.log
6

7
# 重启
8
systemctl restart mysqld
9

10
# 停止
11
systemctl stop mysqld
12

13
#查看状态
14
systemctl status mysqld
15

16
#开机启动
17
systemctl enable mysqld
18
systemctl daemon-reload
19

20
# 查看进程、版本信息
21
ps -ef | grep mysql
22
或
23
netstat -atp
24

25
# 登录
26
mysql -u root -p'密码内容'
27

28
# 查看所有表
29
show databases;
30

31
# 进入数据库
32
use 表名
33

34
# 查看所有表
35
show tables
36

37
# 查看某张表信息
38
desc 表名
39

40
# 查
41
select * from 表名
42
# 删
43
delete from 表名 where field=xx
44
# 改
45
update 表名 set field='xxx' where field='xxx';

1
# 第一次启动后，可以查看mysql初始化密码
2
grep 'temporary password' /var/log/mysqld.log
3

4
输出（root@localhost: 后面的是密码）：
5
2023-04-21T06:03:27.071550Z 6 [Note] [MY-010454] [Server] A temporary password
6
is generated for root@localhost: r2to%yZ%a)%s

1
# 登录mysql，一定要注意：-p和'密码'之间是没有空格的
2
mysql -u root -p'r2to%yZ%a)%s'

1
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_123';

1
1、先按照mysql的要求，修改一次密码
2
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_123';
3

4
2、退出mysql
5
exit
6

7
3、重新登录mysql
8
mysql -u root -p'Root_123'
9

10
4、安装密码验证插件
11
install plugin validate_password soname 'validate_password.so';
12

13
5、查看是否启用了插件
14
select plugin_name, plugin_status from information_schema.plugins where plugin_name like 'validate%';
15
+-------------------+---------------+
16
| plugin_name       | plugin_status |
17
+-------------------+---------------+
18
| validate_password | ACTIVE        |
19
+-------------------+---------------+
20
输出这样的内容，表示成功启用

1
SHOW VARIABLES LIKE 'validate_password%';
2

3
对于高版本的mysql，例如mysql 8，验证策略的key，是 validate_password.xxx
4
+--------------------------------------+-------+
5
| Variable_name                        | Value |
6
+--------------------------------------+-------+
7
| validate_password.check_user_name    | ON    |
8
| validate_password.dictionary_file    |       |
9
| validate_password.length             | 8     |
10
| validate_password.mixed_case_count   | 1     |
11
| validate_password.number_count       | 1     |
12
| validate_password.policy             | MEDIUM|
13
| validate_password.special_char_count | 1     |
14
+--------------------------------------+-------+
15

16

17
对于低版本的mysql，例如mysql 5.7，验证策略的key，是 validate_password_xxx
18
+--------------------------------------+-------+
19
| Variable_name                        | Value |
20
+--------------------------------------+-------+
21
| validate_password.check_user_name    | ON    |
22
| validate_password.dictionary_file    |       |
23
| validate_password.length             | 8     |
24
| validate_password.mixed_case_count   | 1     |
25
| validate_password.number_count       | 1     |
26
| validate_password.policy             | MEDIUM|
27
| validate_password.special_char_count | 1     |
28
+--------------------------------------+-------+

1
设置密码校验策略为：0（只验证密码长度）
2
set global validate.password_policy=0;
3

4
设置密码最低长度=N，例如设置密码最低长度=6，也就是密码最少要设置6个字符及以上
5
set global validate.password_length=6;

1
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

1
# 登录
2
mysql -u root -p'密码'
3

4
# 如果你的数据库是 mysql 8 及以上
5
# 1、进入数据库
6
use mysql
7
# 2、修改user表
8
update user set host='%' where user='root';
9

10
# mysql 5.7 及之前，执行这行代码即可
11
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
12

13
# 重载授权表
14
FLUSH PRIVILEGES;
15

16
# 退出
17
exit
18

19
# 重启
20
systemctl restart mysqld