centos7下安装mysql，centos7安装mysql

centos7下安装mysql，centos7安装mysql

centos7默认安装了mariadb数据库，安装mysql是首先卸载mariadb数据库。

rpm -qa | grep mariadb   检测安装的mariadb数据库。

mariadb-libs-5.5.44-2.el7.centos.x86_64
mariadb-server-5.5.44-2.el7.centos.x86_64
mariadb-5.5.44-2.el7.centos.x86_64

卸载mariadb数据库

rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

rpm -e --nodeps mariadb-server-5.5.44-2.el7.centos.x86_64

rpm -e --nodeps mariadb-5.5.44-2.el7.centos.x86_64

去mysql官网下载mysql5.6.24版本安装文件，解压安装一下三个文件 

rpm -ivh MySQL-server-advanced-5.6.24-1.el6.x86_64.rpm

rpm -ivh MySQL-devel-advanced-5.6.24-1.el6.x86_64.rpm

rpm -ivh MySQL-client-advanced-5.6.24-1.el6.x86_64.rpm

开启3306端口

firewall -cmd --zone=public --add-port=3306/tcp --permanent

重启防火墙

systemctl restart firewalld

设置数据库密码

[root@localhost opt]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

[root@localhost opt]# mysql -uroot mysql

mysql> UPDATE user SET Password=PASSWORD('123456') where USER='root';

mysql> FLUSH PRIVILEGES;

mysql>quit;

[root@localhost opt]# service mysql restart

[root@localhost opt]# mysql -uroot -p

mysql> SET PASSWORD = PASSWORD('123456');

mysql> FLUSH PRIVILEGES;

mysql>quit;

到此数据安装完毕!

如果要设置为任何客户端都可以以root连接的话,登录mysql执行：

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Huawei123' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

mysql>quit;