阿里云centos 7.6安装mysql_阿里云CentOS 7.6下安装mysql5.6.46

安装版

1、rpm -qa | grep mysql(检查是否已安装mysql)

2、rpm -qa|grep -i mariadb(查看Mariadb) && rpm -qa|grep mariadb|xargs rpm -e --nodeps(卸载Mariadb)

3、wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm(下载mysql)

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

5、yum install mysql-server

6、rpm -qa | grep mysql

7、systemctl start mysqld.service

8、设置密码

1.mysql -u root

2.use mysql;

3.update user set password=PASSWORD("123456") where User='root';

4.flush privileges;

5.GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";

9、修改端口

1.vi /etc/my.cnf

2.port=3306

10、阿里云开启对应端口，本地连接

安装成功

systemctl start mysqld.service #启动 mysql

systemctl restart mysqld.service #重启 mysql

systemctl stop mysqld.service #停止 mysql

systemctl enable mysqld.service #设置 mysql 开机启动