centos 6 mysql 安装

centos 6 与 centos 7 mysql 安装

centos 6
yum list installed | grep mysql
yum -y remove mysql-libs.i686
wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum install mysql-community-release-el6-5.noarch.rpm
yum repolist enabled | grep mysql
yum install mysql-community-server
service mysqld start
grep “password” /var/log/mysqld.log
mysql> SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘newpass’);
chkconfig --list | grep mysqld
chkconfig mysqld on
vim /etc/my.cnf
在[mysqld]部分添加：
character-set-server=utf8
在文件末尾新增[client]段，并在[client]段添加：
default-character-set=utf8
修改好之后重启mysqld服务：
service mysqld restart
修改mysql远程访问
grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
flush privileges;

show variables like “%character%”；

create database bootdo default charset utf8 collate utf8_general_ci;

centos7
wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm
yum repolist all | grep mysql
修改
/etc/yum.repos.d/mysql-community.repo

Disable MySQL 8.0

[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Enable to use MySQL 5.7

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
#查看
yum repolist enabled | grep mysql
#安装
yum install mysql-community-server
systemctl start mysqld.servic

查看临时密码

grep ‘temporary password’ /var/log/mysqld.log

结果

#2019-01-21T17:03:36.176457Z 1 [Note] A temporary password is generated for root@localhost: y%x%(tHai1Gd
mysql -uroot -p

输入临时密码

#进入mysql 命令行，修改为新的密码，需要密码有高复杂度，可用通过配置关闭这个选项
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘Abc*#06#’;

开机启动

systemctl list-unit-files | grep mysqld
systemctl enable mysqld.service