首先升级yum yum update#
查看已安装的MySQL
[root@ceshi ~]# rpm -qa | grep -i mysql
mysql-community-common-8.0.26-1.el7.x86_64
mysql80-community-release-el7-1.noarch
mysql-community-libs-8.0.26-1.el7.x86_64
mysql-community-devel-8.0.26-1.el7.x86_64
mysql-community-client-8.0.26-1.el7.x86_64
mysql-community-server-8.0.26-1.el7.x86_64
mysql-community-client-plugins-8.0.26-1.el7.x86_64 卸载
[root@ceshi ~]# yum remove -y mysql*
删除剩余的MySQL相关文件和文件夹
[root@ceshi ~]# find / -name mysql
安装mysql8.0
下载mysql8.0.20
[root@ceshi ~]# wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.20-el7-x86_64.tar.gz
解压mysql包
[root@ceshi src]# tar -xvf mysql-8.0.26-el7-x86_64.tar.gz
创建安装目录
[root@ceshi src]# mkdir -p /usr/local/mysql
[root@ceshi src]# mv mysql-8.0.26-el7-x86_64/* /usr/local/mysql/
创建mysql用户和组
[root@ceshi src]# groupadd mysql
[root@ceshi src]# useradd -r -g mysql -s /sbin/nologin mysql
创建数据目录并授权
[root@ceshi src]# cd /usr/local/mysql/
[root@ceshi mysql]# mkdir data logs
[root@ceshi mysql]# chown -R mysql:mysql /usr/local/mysql/
在etc下新建配置文件my.cnf,加入下面配置
[root@ceshi mysql]# touch /etc/my.cnf
[root@ceshi mysql]# ls /etc/my.cnf
/etc/my.cnf
[root@ceshi mysql]# vim /etc/my.cnf
[mysqld]
#设置mysql客户端连接服务端时默认使用的端口
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql/logs/mysql.log
socket=/tmp/mysql.sock
event_scheduler=ON
slow_query_log = ON
slow_query_log_file = /usr/local/mysql/logs/mysql-slow.log
long_query_time = 1
innodb_buffer_pool_size = 6G
default-authentication-plugin=mysql_native_password
server-id=10
log-bin=/usr/local/mysql/logs/mysql-bin
max_connect_errors=1000
log-error=/usr/local/mysql/logs/mysql.log
pid-file=/usr/local/mysql/data/mysql.pid 安装数据库，生成初始密码并查看
[root@ceshi mysql]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
[root@ceshi mysql]# cat logs/mysql.log | grep password 配置mysql服务
[root@ceshi mysql]# vim /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 65536
LimitNPROC = 65536 重新加载
[root@ceshi mysql]# systemctl daemon-reload
软链接
[root@ceshi mysql]# ln -s /usr/local/mysql/bin/mysql /usr/bin/
[root@ceshi mysql]# ln -s /usr/local/mysql/bin/mysqldump /usr/bin/
启动服务并设置开机自启
[root@ceshi mysql]# systemctl stop mysqld
[root@ceshi mysql]# systemctl start mysqld
[root@ceshi mysql]# systemctl enable mysqld
查看运行状态
[root@ceshi mysql]# ps -ef | grep mysqld
[root@ceshi mysql]# systemctl status mysqld
修改root密码，并设置远程登录
[root@ceshi mysql]# mysql -uroot -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234';
Query OK, 0 rows affected (0.04 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> update mysql.user set host='%' where user='root';
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)