mysql 安装记录

1、查看原来安装的Mysql  
rpm -qa | grep mysql

2、Mysql卸载
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64 

3、依赖包
yum install numactl libaio perl-Time-HiRes per-devel -y

yum -y install make gcc-c++ cmake bison-devel ncurses-devel numactl libaio

4、tar -xvf mysql-8.0.0-0.1.dmr.el6.x86_64.rpm-bundle.tar

5、安装

rpm -ivh  mysql-community-common-8.0.13-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.13-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-compat-8.0.13-1.el6.x86_64.rpm

rpm -ivh mysql-community-client-8.0.13-1.el6.x86_64.rpm

rpm -ivh mysql-community-server-8.0.13-1.el6.x86_64.rpm

如果报错：

使用：rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm --force --nodeps

6、启动（启动前，如果要mysql忽略大小写，要提前设置lower_case_table_names = 1（vim /etc/my.cnf），否则一但启动后就无法再修改了）

service mysqld start

查看启动状态

service mysqld status

设置开机启动   
chkconfig mysqld on
 

7、生成随机密码 
grep 'temporary password' /var/log/mysqld.log

8、使用随机密码登陆
mysql -uroot -p  

9、修改密码（这里直接修改为123456会提示密码太弱[非要改为123456，先要修改mysql8的密码规则]，这里最好先将配置文件改了再来改密码，配置文件里面的密码规则影响navicat的登陆）

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';  

如果报错：

是设置的密码规则不符合要求，可以修改一下设置

set global validate_password_policy=0;

set global validate_password_length=4;

10、授权远程连接

use mysql;

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

11、刷新配置
FLUSH PRIVILEGES;

12、mysql的配置优化 /etc/my.cnf

port=3369
character-set-server=utf8
max_connect_errors=10
max_connections=200
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


[mysql]
default-character-set=utf8
[client]
port=3369
default-character-set=utf8

service mysql stop

service mysql start