centos7安装mysql

centos7安装mysql

一、检查mariadb

rpm -qa|grep mariadb

二、删除mariadb

rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64

三、安装mysql

mysql5.7镜像地址
下载这个文件mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar
然后放到centos7即可

创建文件夹
mkdir mysql
将文件解压到mysql文件夹
tar -xvf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar -C ./mysql
进入该文件夹
cd mysql

安装这四个文件即可
mysql-community-common-5.7.29-1.el7.x86_64.rpm
mysql-community-libs-5.7.29-1.el7.x86_64.rpm
mysql-community-client-5.7.29-1.el7.x86_64.rpm
mysql-community-server-5.7.29-1.el7.x86_64.rpm

安装命令如下
rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm
。。。

有些安装server会出现fail

error: Failed dependencies:
	libaio.so.1()(64bit) is needed by mysql-community-server-5.7.30-1.el7.x86_64
	libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.30-1.el7.x86_64
	libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.30-1.el7.x86_64

需要安装这个文件

yum install -y libaio

有的可能还需要

yum install -y numactl

四、启动mysql

启动mysql服务
systemctl start mysqld
查看mysql的密码
cat /var/log/mysqld.log |grep password

root@localhost后面的就是mysql的密码

三、进入mysql

进入mysql
mysql -uroot -p
然后输入刚才查的密码即可

三、修改mysql

编辑文件
vim /etc/my.cnf

在mysqld的下面加上验证密码为off
[mysqld]
validate_password=off

然后重启mysql
systemctl restart mysqld

然后进入mysql
执行

alter user 'root'@'localhost' identified by 'root';

密码为root
到此 安装成功！！！

如果远程连接不成功
use mysql;
update user set host = '%' where user = 'root';

再重启  即可远程链接成功
systemctl restart mysqld