1. 下载mysql8
https://pan.baidu.com/s/13tz1msTHrqLqLNLoiOxUoQ?pwd=1rs5
2. 准备工作
- 检查系统有没有自带的mariadb
- 解压mysql安装文件,在/home目录下安装
- 创建mysql数据存储data目录
1.
rpm -qa|grep mariadb
存在就卸载
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
2.
tar -xzvf mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.27-linux-glibc2.12-x86_64 /home/mysql
3.
mkdir -p /home/mysql/data
mkdir -p /home/mysql/log
2. 创建mysql用户组和用户
1. groupadd mysql
2. useradd -r -g mysql mysql
4. 修改mysql目录的用户组和用户为mysql
chown mysql.mysql -R /home/mysql
5. 修改/etc/my.cnf配置文件
(1)修改文件
vim /etc/my.cnf
(2)添加配置
[mysqld]
bind-address=0.0.0.0
port=3306 # mysql端口号
user=mysql
basedir=/home/mysql # mysql安装目录
datadir=/home/mysql/data # 数据存放目录
socket=/tmp/mysql.sock
log-error=/home/mysql/log/mysqld.log
pid-file=/home/mysql/mysqld.pid
#character config
log_bin=master-a-bin
binlog-format=ROW
lower_case_table_names=1
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
6. 初始化数据库
- 进入mysql的bin目录
- 执行初始化命令
1.
cd /home/mysql/bin
2.
./mysql --defaults-file=/etc/my.cnf --basedir=/home/mysql/ --datadir=/home/mysql/data/ --user=mysql --initialize
7. 检查mysqld.log里面的初始化密码
1.
cd /home/mysql/log
2.
cat mysqld.log
8. 拷贝mysql.server到/etc/init.d
1.
cd /home/mysql/support-files
2.
cp mysql.server /etc/init.d/mysql
9. 启动mysql服务
service mysql start
10. 通过临时密码登录mysql,修改密码
1.
cd /home/mysql/bin
2.
./mysql -uroot -p
3.
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '新密码';
11. 设置远程连接
1.
cd /home/mysql/bin
2.
./mysql -uroot -p
3.
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;
PS
如果启动报错,且报错信息如下,尝试关闭selinux,再重新重启mysql
(1)临时关闭selinux
setenforce 0
(2)永久关闭selinux
1.
vim /etc/selinux/config
2. 修改SELINUX=disabled
3. 重启服务器