【centos安装部署】安装mysql

一、下载yum源：
wget ‘https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm’

二、安装yum源
rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

三、查看有哪些版本的mysql:
yum repolist all | grep mysql

四、安装
yum install -y mysql-community-server

五、启动
systemctl start mysqld
查看状态
systemctl status mysqld

六、查看原始密码
grep ‘temporary password’ /var/log/mysqld.log

七、登录mysql
mysql -uroot -p

八、修改密码
SET PASSWORD = PASSWORD(‘Admin123!’);

九、开启远程链接
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘Admin123!’ WITH GRANT OPTION;
flush privileges;

十、设置开机启动
systemctl enable mysqld
systemctl daemon-reload

十一、基本命令
启动：service mysqld start
停止：service mysqld stop
重启：service mysqld restart
状态：service mysqld status

注：收集于网络，侵权请联系作者