CentOS8安装mysql步骤

CentOS8安装mysql步骤

安装mysql5.6

wget https://mirrors.tencent.com/mysql/yum/mysql-5.6-community-el6-x86_64/mysql-community-bench-5.6.21-2.el6.x86_64.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum install mysql-server -y

service mysqld start

service mysqld status

systemctl enable mysqld.service

grep “password” /var/log/mysqld.log找初始密码，如果报找不到文件那就试试grep “password” /var/log/mysql/mysqld.log

mysqladmin -uroot -p password NewPassword回车输入初始密码来重置密码

安装mysql5.7

wget http://repo.mysql.com/mysql57-community-release-el7-11.noarch.rpm

rpm -ivh mysql57-community-release-el7-11.noarch.rpm

yum install mysql-server -y

service mysqld start

service mysqld status

systemctl enable mysqld.service

grep “password” /var/log/mysqld.log找初始密码，如果报找不到文件那就试试grep “password” /var/log/mysql/mysqld.log

mysqladmin -uroot -p password NewPassword回车输入初始密码来重置密码

安装mysql8.0

wget http://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

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

yum install mysql-server -y

service mysqld start

service mysqld status

systemctl enable mysqld.service

grep “password” /var/log/mysql/mysqld.log找初始密码，如果报找不到文件那就试试grep “password” /var/log/mysqld.log

mysqladmin -uroot -p password NewPassword回车输入初始密码来重置密码

为了下载速度快一些，可以替换URL为腾讯源地址

具体地址需自行打开如下URL找到精确URL

http://mirrors.tencent.com/mysql/yum/

注:1.查看初始密码vim /var/log/mysql/mysqld.log
2.如果为空,alter user ‘root’@‘localhost’ identified by ‘这里是你的密码’;
3.远程连接授权:grant all privileges on . to ‘root’ @’%’ identified by ‘root’;
flush privileges;