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