Ceneos7 安装 MySQL8

1. 下载

• 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

2. 验证md5sum

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

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

2. yum install mysql-server -y

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

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

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>