MySQL（2）CentOS 7 安装 MySQL-8.0.17 以及常见问题

最新推荐文章于 2023-09-08 10:00:00 发布

ruyulin

最新推荐文章于 2023-09-08 10:00:00 发布

阅读量1k

点赞数

分类专栏： MySQL 文章标签： linux mysql centos 安装MYsql8.0

本文链接：https://blog.youkuaiyun.com/ruyulin/article/details/101438308

版权

MySQL 专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了在京东云服务器CentOS7系统上安装MySQL8.0.17的过程，包括创建文件夹、安装必要软件、下载并安装MySQL各组件、启动数据库、查询启动状态及修改初始密码等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

我使用的是京东的云服务器，CentOS7系统。安装MySQL8.0.17整体都比较顺利

安装过程

1.创建文件夹，安装vim

mkdir /usr/local/mysql8
cd /usr/local/mysql8
yum install vim

2.下载MySQL8.0.17安装文件

wget http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64//mysql-community-common-8.0.17-1.el7.x86_64.rpm
wget http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64//mysql-community-libs-8.0.17-1.el7.x86_64.rpm
wget http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64//mysql-community-client-8.0.17-1.el7.x86_64.rpm
wget http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64//mysql-community-server-8.0.17-1.el7.x86_64.rpm

3.依次安装

安装完成会提示：Complete，如果如下安装都成功了，mysql就安装完成了。还是挺简单的。

yum localinstall mysql-community-common-8.0.17-1.el7.x86_64.rpm
yum localinstall mysql-community-libs-8.0.17-1.el7.x86_64.rpm
yum localinstall mysql-community-client-8.0.17-1.el7.x86_64.rpm
yum localinstall mysql-community-server-8.0.17-1.el7.x86_64.rpm

4.启动数据库

systemctl start mysqld.service

5.查询数据库启动状态

service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2019-09-26 10:37:25 CST; 5s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 8605 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 8731 (mysqld)
   Status: "Server is operational"
   CGroup: /system.slice/mysqld.service
           └─8731 /usr/sbin/mysqld

6.登录数据库修改密码

默认密码是MySQL自动生成的。需要查询MySQL日志文件查询初始密码

使用命令后注意这句话，**root@localhost:**后面的就是初始密码
A temporary password is generated for root@localhost: lS:K+i*oQ9k&

[root@JD log]# cat /var/log/mysqld.log 
2019-09-26T02:37:17.239976Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 8632
2019-09-26T02:37:22.122733Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: lS:K+i*oQ9k&
2019-09-26T02:37:23.695844Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
2019-09-26T02:37:25.313645Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 8731
2019-09-26T02:37:25.761109Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-09-26T02:37:25.780776Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2019-09-26T02:37:25.911653Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-09-26T02:49:43.431002Z 10 [Warning] [MY-011234] [Server] Effective value of validate_password_length is changed. New value is 4
2019-09-26T03:01:09.197110Z 14 [Warning] [MY-010055] [Server] IP address '111.201.149.51' could not be resolved: Name or service not known

[root@JD log]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.17

修改密码

mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password.length=1;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER root@localhost IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)

这样密码修改成功