linux下centos7 安装mysql8.0

1.下载mysql安装包或rpm（本次以tar.gz为例）

https://downloads.mysql.com/archives/community/

https://dev.mysql.com/downloads/repo/yum/

2.卸载旧版本

rpm -qa|grep mariadb

rpm -qa|grep mysql

rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

2.上传并解压/usr/local/mysql 并重命名【注意路径一定要是/usr/local/mysql】

tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz /etc/mysql/

mv mysql-8.0.11-linux-glibc2.12-x86_64 mysql-8.0.11

3.创建mysql用户,并设置权限

useradd -r mysql

chown mysql:mysql -R /usr/local/mysql

4.初始化(记住默认密码)

./mysqld --initialize

 

5.切换用户并启动

su mysql

./mysqld

如果启动出现Too many arguments (first extra is 'start') 请使用./mysqld start --user=mysql 启动

./mysqld -u root -p

输入记住的秘密

出现3306，启动成功

6.修改root用户密码，与远程登录权限

注意：5.7.6以后一定要用

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

use mysql；

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

flush privileges;

使用set password for root@localhost = password('root') 会提示法错误

使用客户端工具sqlyog 远程登录时提示：plugin caching_sha2_password could not be loaded

需要更改密码选项

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;

则可以远程登录

7.配置配置文件，

查看mysql 默认配置文件路径 ，进入mysql/bin目录

./mysqld --verbose --help |grep -A 1 'Default options' 

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf 

可知默认配置文件路径优先级分别为：/etc/my.cnf    /etc/mysql/my.cnf     /usr/local/mysql/etc/my.cnf，任选创建my.cnf文件路径

my.cnf文件配置内容

[mysqld]
# 使用旧式密码登录方式
default_authentication_plugin = mysql_native_password
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
user=root
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port=3306
socket=/usr/local/mysql/mysql.sock
character-set-server=utf8
log-error = /usr/local/mysql/data/mysqld.log
pid-file = /usr/local/mysql/data/mysqld.pid
 

8.配置服务与开机启动项

cp support-files/mysql.server /etc/init.d/mysql.server

#测试启动

./mysql.server start

9.添加开启启动

chkconfig --add mysql.server

#检查 是否添加成功
#systemctl status/start/stop mysql.server

chkconfig mysql.server on

#检查
chkconfig --list|grep mysql