Centos7安装MySQL

MySQL8

# 解压
tar -xvf mysql-8.0.35-1.el7.x86_64.rpm-bundle.tar

# 安装软件包
yum install mysql-community-{libs,icu,client,common,server}-*.rpm

# 检查安装情况
ps -ef | grep mysql
mysqladmin --version

# 初始化
mysqld --initialize

# 目录权限授权
chown -R mysql:mysql /var/lib/mysql/

# 启动服务
systemctl start mysqld

# 开机启动
systemctl enable mysqld

# 查看root密码
grep 'temporary password' /var/log/mysqld.log

# 登录
mysql -uroot -p

# 修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

# 刷新
flush privileges;

# 支持远程连接
update user set host = '%' where host = 'localhost' and user = 'root';
flush privileges;