Linux中MySQL安装与配置

1.卸载mariadb

yum remove mariadb -y

 

2.查找mariadb包

rpm -qa | grep mariadb

会找到 mariadb-libs-5.5.60-1.el7_5.x86_64 也删除：

yum remove mariadb-libs-5.5.60-1.el7_5.x86_64 -y

 

3.删除遗留文件

rm -rf /var/lib/mysql/

 

wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm

下载mysql:

直接把tar上传到/software上

 

4.安装rpm

rpm -ivh mysql57-community-release-el6-7.noarch.rpm

编辑   /etc/yum.repos.d/mysql-community.repo

vim /etc/yum.repos.d/mysql-community.repo

 

 

5.rpm安装

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm

 

rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm

 

rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm

 

yum install -y net-tools

 

rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

 

6.启动服务

systemctl start mysqld

systemctl enable mysqld(开启自启)

 

7.查看临时密码 最后写是临时密码

cat /var/log/mysqld.log | grep "temporary password"

如果没有显示出密码，可以删除/var/lib/mysql，然后重新启动服务

注意：然后通过 mysql -u root -p 回车， 进入后将临时密码粘贴进去，回车就进去了。

 

8.修改密码

set global validate_password_policy=LOW;

set global validate_password_length=4;

alter user 'root'@'localhost' identified by '123456你自己得mysql密码';

 

9.打开远程连接

update mysql.user set host='%' where user='root';

10.刷新授权

flush privileges;

 

11.退出mysql

输入：quit

12.修改编码

vim /etc/my.cnf

在[mysqld]下添加:

character-set-server=utf8

 

重启服务

service mysqld restart

13进mySql

命令mysql -u root -p123456