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>