MySQL安装教程

注：本教程通过自己下载安装包进行安装，yum安装参考菜鸟教程安装MySql
1.下载安装包
进入mysql官网（Mysql的官网https://www.mysql.com/）下载对应版本的安装包

2.上传压缩包、解压
将压缩包上传至目录 /usr/local
解压

[root@iz2ze3vjo3xi80fclvn6ldz local]# tar -zxvf mysql-8.0.18-el7-x86_64.tar.gz

并将文件夹“mysql-8.0.18-el7-x86_64”重命名为mysql

3.在mysql根目录下创建data目录，存放数据

[root@iz2ze3vjo3xi80fclvn6ldz ]# cd /usr/local/mysql/
[root@iz2ze3vjo3xi80fclvn6ldz mysql]# mkdir data

4.创建mysql用户组和mysql用户

[root@iz2ze3vjo3xi80fclvn6ldz local]# groupadd mysql
[root@iz2ze3vjo3xi80fclvn6ldz local]# useradd -g mysql mysql

5.给文件夹赋权

chown -R mysql.mysql /usr/local/mysql/

6.初始化
注：mysql8不支持在配置文件中修改此参数，所以初始化的时候设置“lower-case-table-names=1” 不区分大小写。

[root@iz2ze3vjo3xi80fclvn6ldz mysql]# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --lower-case-table-names=1

7.记住初始化结束后，生成的密码
注：图片来源于网络，本人安装过程未截图

临时密码：twi=Tlsi<0O!

8.MySQL配置

[root@iz2ze3vjo3xi80fclvn6ldz mysql]# cd /usr/local/mysql/support-files/
[root@iz2ze3vjo3xi80fclvn6ldz support-files]# touch my-default.cnf
[root@iz2ze3vjo3xi80fclvn6ldz support-files]# cp -a ./my-default.cnf /etc/my.cnf 

9.编辑配置文件

[root@iz2ze3vjo3xi80fclvn6ldz support-files]# vi /ect/my.cnf

将一下内容粘贴进去

[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /usr/local/mysql/mysql.sock
character-set-server=utf8
port = 3306
lower_case_table_names = 1
[client]
socket = /usr/local/mysql/mysql.sock
default-character-set=utf8

10.配置环境变量

[root@iz2ze3vjo3xi80fclvn6ldz support-files]# vim /etc/profile

将以下内容粘贴至最后

PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
export PATH

生效

[root@iz2ze3vjo3xi80fclvn6ldz support-files]# source /etc/profile

11.建立mysql服务

[root@iz2ze3vjo3xi80fclvn6ldz support-files]# cp mysql.server /etc/init.d/mysql
[root@iz2ze3vjo3xi80fclvn6ldz support-files]# chmod +x /etc/init.d/mysql

12.启动MySQL

[root@iz2ze3vjo3xi80fclvn6ldz mysql]# service mysql start

13.登录mysql

[root@iz2ze3vjo3xi80fclvn6ldz mysql]# mysql -u root -p

输入临时密码，输入密码时候不显示，直接按回车

14.修改密码

alter user 'root'@'localhost' identified by '123456';

15.修改root用户可以远程连接

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

16.刷新

flush privileges;

17.防火墙
将3306端口开放

[root@iz2ze3vjo3xi80fclvn6ldz data]# firewall-cmd --permanent --zone=public --add-port=3306/tcp  
[root@iz2ze3vjo3xi80fclvn6ldz data]# firewall-cmd --reload 

参考链接：https://blog.csdn.net/github_39533414/article/details/80144890