Linux安装Mysql

Linux安装Mysql

1，查找mariadb包

rpm -qa | grep mariadb

2，卸载mariadb（如果有则卸载）

yum remove mariadb -y

3，删除遗留文件

rm -rf /var/lib/mysql/

4，安装MySQL

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

5，找到mysql57，修改内容

vim /etc/yum.repos.d/mysql-community.repo
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

6，rpm安装

yum install -y net-tools
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
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

注意：RPM安装按照顺序
7，启动服务

systemctl start mysqld
systemctl enable mysqld

8，查看临时密码

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

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

set global validate_password_policy=LOW; 
set global validate_password_length=4;
alter user 'root'@'localhost' identified by '123456你自己得mysql密码';

10，打开远程连接

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

11，刷新授权

flush privileges;

12，修改编码

vim /etc/my.cnf
在[mysqld]下添加:character-set-server=utf8

13，重启服务

service mysqld restart