mysql5.7和mysql5.6同在CentOS7.4安装差异对比之5.7.18

Mysql5.7.18

rpm -qa|grep mariadb // 查询出来已安装的mariadb rpm -e --nodeps 文件名 // 卸载mariadb，文件名为上述命令查询出来的文件

yum install libaio

groupadd mysql useradd -r -g mysql -s /bin/false mysql tar zxvf /path/to/mysql-VERSION-OS.tar.gz mv mysql-VERSION-OS /usr/local/ ln -s full-path-to-mysql-VERSION-OS mysql cd /usr/local/mysql mkdir mysql-files chown mysql:mysql mysql-files chmod 750 mysql-files cd /data/ chown mysql.mysql mysql/ -R bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data bin/mysql_ssl_rsa_setup bin/mysqld_safe --user=mysql &

cp support-files/mysql.server /etc/init.d/mysqld echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile source /etc/profile

MySQL> set password='xxxxx';  修改密码 MySQL> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; 设置密码不过期

ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';