背景
Centos7以后的系统,默认的数据库是MariaDB,虽然MariaDB是完全兼容MySQL的,但是无法使用yum安装的Mysql包。那要怎样在Centos7系统上安装Mysql5.7呢?
安装步骤
-
卸载MariaDB安装包
yum list installed | grep mariadb
yum -y remove mariadb*
-
安装mysql的yum源
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
rpm -ivh mysql57-community-release-el7-11.noarch.rpm
-
安装mysql
yum install mysql-community-server
-
修改密码
免检查方式启动mysql:
mysqld --user=root --skip-grant-tables &
输入
mysql
进入客户端,更新密码:UPDATE mysql.user SET authentication_string=PASSWORD('XXXXXX') where USER='root';flush privileges;
-
重启mysql
停止mysqld
systemctl stop mysqld
启动mysql
systemctl star mysqld
-
其他命令:
登录: mysql -uroot -p'XXXXXX' -phost
授权: grant all privileges on *.* to root@"%" identified by 'XXXXXX';flush privileges;