Linux 安装 MySQL8 且获取密码

1. 下载 MySQL

下载地址:
https://dev.mysql.com/downloads/repo/yum/

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

2. 安装 MySQL

rpm -ivh mysql80-community-release-el8-1.noarch.rpm
yum update
yum install mysql-server

3. 授权路径

chown mysql:mysql -R /var/lib/mysql

4. 初始化 MySQL

mysqld --initialize

5. 启动 MySQL

systemctl start mysqld

如果开始 MySQL 服务失败, 运行下面的语句, 重新启动

rm -rf /var/lib/mysql
mkdir /var/lib/mysql
chown mysql:mysql -R /var/lib/mysql

6. 查看 MySQL 运行状态

systemctl status mysqld

7. 查看 MySQL 初始密码

grep "A temporary password is generated for root@localhost" /var/log/mysql/mysqld.log

8. 修改 MySQL 密码

alter user user() identified by "vBSatLjrg1wf";

9. Docker 安装 MySQL8

docker run -d -it \
  -p 3306:3306 \
  -v /home/docker/mysql/my.cnf:/etc/mysql/my.cnf:rw \
  -v /home/docker/mysql/data:/var/lib/mysql \
  -v /home/docker/mysql/mysqlfile:/root \
  -e MYSQL_ROOT_PASSWORD=PASSWORD \
  --name=mysql8 mysql