centos7.4 安装mysql详细流程

参考链接： https://blog.csdn.net/zxy987872674/article/details/81949430

1、下载mysql安装包

    下载地址：https://dev.mysql.com/downloads/mysql/

mkdir mysql
wget https://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-5.6.44-1.el7.x86_64.rpm-bundle.tar

2、解压缩安装包

tar xvf MySQL-5.6.44-1.el7.x86_64.rpm-bundle.tar

3、安装前，注意：

卸载自带的mariadb

#查看mariadb并卸载
sudo rpm -e --nodeps mariadb-
sudo rpm -e --nodeps mariadb-common
sudo rpm -e --nodeps mariadb-libs

https://blog.csdn.net/tianshuhao521/article/details/93854326

4、安装依赖

　【参考 https://blog.csdn.net/tianshuhao521/article/details/93854326】

$ sudo yum install perl
$ sudo yum -y install autoconf
$ sudo yum install libaio

5.安装mysql

$ sudo rpm -ivh MySQL-client-5.6.44-1.el7.x86_64.rpm
$ sudo rpm -ivh MySQL-devel-5.6.44-1.el7.x86_64.rpm
$ sudo rpm -ivh MySQL-embedded-5.6.44-1.el7.x86_64.rpm
$ sudo rpm -ivh MySQL-server-5.6.44-1.el7.x86_64.rpm

6、启动mysql

systemctl start mysql

 

问题汇总：

1、file /usr/share/mysql/charsets/README from install of MySQL-server-5.6.44-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64　

$ sudo yum remove mysql-libs

 2、ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

#找到 [mysqld] 这一项，然后在该配置项下添加 skip-grant-tables 这个配置，然后保存文件。 
$ sudo vim /usr/my.conf
$ sudo systemctl restart mysql

#敲入 mysql -u root -p 命令然后回车，当需要输入密码时，直接按enter键，便可以不用密码登录到数据库当中
#设置新的密码
$ set password for 'username'@'host' = newpassword
#用新密码登录mysql
$ mysql -u root -p
#进入mysql后
mysql> SET PASSWORD = PASSWORD('8579339baoshan');
mysql> FLUSH PRIVILEGES;

# 参考文档：

    【1】 https://blog.csdn.net/lisongjia123/article/details/57418989

　【2】https://blog.csdn.net/yanzi1225627/article/details/8694358