Ceneos7 安装 MySQL8-CSDN博客

本文链接：https://blog.csdn.net/zgrwbb/article/details/120542897

Ceneos7 安装 MySQL8

1. 访问MySQL 社区 Yum Repository

下载

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

或

curl -O https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

验证md5sum

md5sum mysql80-community-release-el7-3.noarch.rpm

2. 安装

rpm -ivh mysql80-community-release-el7-3.noarch.rpm

yum install mysql-server -y

3. 服务启动/停止/状态/重启

启动: systemctl start mysqld
停止: systemctl stop mysqld
状态: systemctl status mysqld
重启: systemctl restart mysqld

4. 配置

grep 'temporary password' /var/log/mysqld.log

output: 2021-09-07T07:17:04.223763Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: /MrDvru8-aKO

mysqld --console --skip-grant-tables --shared-memory --user=root

修改密码: /usr/bin/mysqladmin -uroot -p/MrDvru8-aKO password xxxxxxx

5. 验证

mysql -uroot -pxxxxxxx

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1064
Server version: 8.0.26 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>