关于mysql:Centos7安装mysq5729

下载MySQL安装包和装置源：

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpmyum -y localinstall mysql57-community-release-el7-11.noarch.rpm 

在线装置MySQL后启动服务且设置开机启动

yum -y install mysql-community-serversystemctl start mysqldsystemctl enable mysqldsystemctl daemon-reload

批改root登录明码

vim /var/log/mysqld.log

登录数据库批改明码

mysql -u root -p#输出明码#设置root明码ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';# 设置近程登录GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;flush privileges;exit;

#开启3306端口firewall-cmd --zone=public --add-port=3306/tcp --permanent;firewall-cmd --reload;firewall-cmd --list-all;#重启数据库systemctl restart mysqld;