Linux MySQL 8.0安装过程

###此教程适合一键安装，如无修改默认root密码为：youpassword###

1.安装依赖

yum -y install wget libaio-devel.x86_64

2.下载MySQL安装包

mkdir -p /tmp/mysql
cd /tmp/mysql
#####如碰到连接失效可以从百度网盘下载或联系作者#####
#百度网盘链接：https://pan.baidu.com/s/1wgvelL6CpA2_F5s8jI36ug?pwd=dj6y 提取码: dj6y
wget https://mirrors.huaweicloud.com/mysql/Downloads/MySQL-8.0/mysql-8.0.24-linux-glibc2.12-x86_64.tar.xz
tar -xvf mysql-8.0.24-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.24-linux-glibc2.12-x86_64 /opt/mysql
#创建用户和用户组
groupadd mysql
useradd -r -g mysql mysql

3.创建mysql数据目录并赋予权限

mkdir -p /data/mysql /var/log/mysql
chown mysql.mysql -R /data/mysql
chown mysql.mysql -R /var/log/mysql
chown mysql.mysql -R /opt/mysql

4.创建mysql配置文件

vi /etc/my.cnf
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
max_binlog_size = 1G
basedir=/opt/mysql
datadir=/data/mysql
socket=/opt/mysql/mysql.sock
log-error=/var/log/mysql/mysql.err
general_log_file=/var/log/mysql/mysql.log
long_query_time=1
slow_query_log=true
slow_query_log_file=/var/log/mysql/mysql-slow-query.log
pid-file=/opt/mysql/mysql.pid
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
default-storage-engine=INNODB
[client]
port=3306
socket=/opt/mysql/mysql.sock

5.初始化mysql

#添加mysql命令变量
vi /etc/profile
#添加到最后
export MYSQL_HOME="/opt/mysql"
export PATH="$MYSQL_HOME/bin:$PATH"
source /etc/profile

#复制mysql.server到/etc/init.d
cd /opt/mysql/support-files
cp mysql.server /etc/init.d/mysqld
#修改里面内容
vi /etc/init.d/mysqld
basedir=/opt/mysql
datadir=/data/mysql

#开始初始化
mysqld --initialize --user=mysql --basedir=/opt/mysql --datadir=/data/mysql
#查看初始化密码
cat /var/log/mysql/mysql.err |grep localhost |awk -F'host: ' '{print $2}'

6.启动mysql，并更改root密码

/etc/init.d/mysqld start
mysql -u root -p`cat /var/log/mysql/mysql.err |grep localhost |awk -F'host: ' '{print $2}'`
#修改mysql root用户密码
ALTER user 'root'@'localhost' IDENTIFIED BY 'youpassword';
#创建mysql 远程root登录用户
create user 'root'@'%' identified by 'youpassword';
grant all on *.* to 'root'@'%';
exit

#测试能否登录
mysql -uroot -p'youpassword'
#完

7.mysql管理

#启动命令
/etc/init.d/mysqld start
#重启命令
/etc/init.d/mysqld restart
#/停止命令
/etc/init.d/mysqld stop