本文共 2428 字，大约阅读时间需要 8 分钟。

下载安装包

[root@localhost ~]# wget https://mirror.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.7/mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar

创建MySQL目录，用winscp把rpm包放进目录下

[root@localhost ~ ]# mkdir /usr/local/mysql

解压进mysql目录

[root@localhost ~]# tar -xvf mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql

安装错误，查看是否带有mariadb-lib

[root@localhost mysql]# rpm -qa|grep mariadbmariadb-libs-5.5.68-1.el7.x86_64

卸载

[root@localhost mysql]# rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps

安装common、libs、client、server

[root@localhost mysql]# rpm -ivh mysql-community-common-5.7.32-1.el7.x86_64.rpm[root@localhost mysql]# rpm -ivh mysql-community-libs-5.7.32-1.el7.x86_64.rpm[root@localhost mysql]# rpm -ivh mysql-community-client-5.7.32-1.el7.x86_64.rpm[root@localhost mysql]# rpm -ivh mysql-community-server-5.7.32-1.el7.x86_64.rpm

安装依赖 libncurses.so.5

yum -y install libncurses.so.5

依旧错误，解决方法执行命令

dnf install ncurses-compat-libs

启动 mysql

[root@localhost mysql]# systemctl start mysqld.service

查看生成的随机密码，（root@localhost: EE<*?50n/ak6）

[root@localhost mysql]# cat /var/log/mysqld.log | grep password2020-12-28T08:07:20.254654Z 1 [Note] A temporary password is generated for root@localhost: EE<*?50n/ak6

在 my.cnf 中加入 validate_password=off

[root@localhost mysql]# vim /etc/my.cnf[mysqld]validate_password=off

登录mysql

[root@localhost mysql]# mysql -uroot -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.7.32...mysql>

登录mysql，修改密码

[root@localhost mysql]# mysql -uroot -p...mysql> set password=password('123456');#修改密码mysql> FLUSH PRIVILEGES;#刷新权限

错误提示

mysql> set password=password('123456');ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

修改全局参数，输入以下命令，判断密码的标准就基于密码的长度

mysql> set global validate_password_policy=0;

密码长度参数默认为8，我们修改为1

mysql> set global validate_password_length=1;

继续修改密码

mysql> set password=password('123456');Query OK, 0 rows affected, 1 warning (0.00 sec)

PS:修改密码: 修改root用户的密码为123，以及客户端主机访问限制，允许所有主机访问

mysql> update user set host='%',authentication_string=password('123') where user='root';mysql> FLUSH PRIVILEGES;#刷新权限

登录mysql，输入密码root

[root@localhost mysql]# mysql -uroot -p...mysql>mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || sys                |+--------------------+4 rows in set (0.00 sec)mysql>

转载地址：https://blog.csdn.net/weixin_43389777/article/details/112039609 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！