1,准备mysql压缩包:https://dev.mysql.com/downloads/mysql/下载所需版本【本文以mysql-8.0.22-linux-glibc2.12-x86_64.tar为例】
2,将mysql包移动到linux一个目录本文放在opt/linux下了;
3,解压压缩包:tar -xvf mysql-8.0.22-linux-glibc2.12-x86_64.tar;
4,重命名文件夹方便操作:mv mysql-8.0.22-linux-glibc2.12-x86_64 mysql8;
5,创建mysql用户组和用户:
groupadd mysql;
useradd -r -g mysql mysql;
6,在/usr/local目录下创建mysql文件夹
mkdir /usr/local/mysql
7,将mysql复制到local目录:
cp mysql8/* /usr/local/mysql -r
8,进入/usr/local/mysql目录:cd /usr/local/mysql;
9,修改目录属于mysql用户:
chown -R mysql:mysql ./
10,初始化mysql:bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
11,初始化后会有个初始密码:2020-12-28T14:58:36.676689Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: pS(Bt)vpD2:i
12,进入etc目录创建my.cnf:
cd /etc;
touch my.cnf;
13,修改my.cnf 添加以下内容:
[mysqld]
basedir=/opt/mysql/mysql8.0
datadir=/opt/mysql/mysql8.0/data
port=3306
socket=/opt/mysql/tmp/mysql.sock
skip-external-locking
default_authentication_plugin=mysql_native_password
14,在usr/local/mysql/下创建tmp并赋予权限;
cd /usr/local/mysql;
mkdir tmp;
chmod 777 tmp;
15,将mysql添加为开机自启动:
cd /usr/local/mysql/support-files;
cp mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
16,注册服务:
chkconfig --add mysql;
17,查看服务:
chkconfig --list mysql;
看到此内容大概就是成功了:mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off;
18,配置环境变量:
vim /etc/profile;
加入以下内容:
export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib
应用变量:source /etc/profile;
19,启动mysql;
serivce mysql start
20,如果端口无法访问自行检查防火墙3306端口;