centos 7下 安装mysql 5.7.33

下载mysql安装包

官网下载地址：mysql5.7.33

---

采用wget下载

查看CentOS7 系统是否已安装wget：

[root@tao ~]# rpm -qa|grep wget
wget-1.14-18.el7_6.1.x86_64

如果没有安装的话，使用如下命令安装

[root@tao ~]# yum install -y wget

使用wget下载mysql5.7.33

[root@tao soft]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz

---

解压安装mysql

用tar解压并移动到安装目录（我的安装目录是/home/mysql），然后创建data、log、log_big、tmp。4个文件夹

root@iZwz94frx7uycgt86fcerpZ soft]# tar -zxvf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz 
[root@tao soft]# mv mysql-5.7.33-linux-glibc2.12-x86_64 /home/mysql
[root@iZwz94frx7uycgt86fcerpZ soft]# cd /home/mysql/

添加系统mysql组和mysql用户：

[root@tao mysql]# groupadd mysql
[root@tao mysql]# useradd -r -g mysql -s /bin/false mysql

修改当前目录拥有者为mysql用户
给data目录及子目录755权限（未执行可能会导致启动失败）：

[root@tao mysql]# chown -R mysql:mysql ./
[root@tao mysql]# chmod -R 755 /home/mysql/data/

配置mysql配置文件，

[root@tao mysql]# vim /etc/my.cnf

---

my.cnf内容如下

[client]
port = 3306
socket = /home/mysql/tmp/mysql.sock
default-character-set=utf8mb4

[mysqld]
basedir = /home/mysql
datadir = /home/mysql/data
port = 3306
server_id = 73
log_bin=/home/mysql/log_big/mysql_bin
socket = /home/mysql/tmp/mysql.sock
character-set-server=utf8mb4
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error=/home/mysql/log/mysqld.log
pid-file=/home/mysql/mariadb.pid

---

初始化数据目录

[root@tao mysql]# bin/mysqld --initialize --user=mysql
bin/mysqld: error while loading shared libraries: libaio.so.1: cannot o

出现上述错误是因为没有安装libaio 库，MySQL依赖于libaio 库，安装libaio 库，然后再重新初始化数据

[root@iZwz94frx7uycgt86fcerpZ mysql]# yum install libaio
[root@iZwz94frx7uycgt86fcerpZ mysql]# bin/mysqld --initialize --user=mysql
.
.
.
.... for root@localhost: OBE?-pL8WuO:

root的临时密码为OBE?-pL8WuO:

---

配置启动项

添加mysql服务，开启软链，加入开机自启动

[root@iZwz94frx7uycgt86fcerpZ mysql]# cp support-files/mysql.server /etc/init.d/mysql
[root@iZwz94frx7uycgt86fcerpZ mysql]# bin/mysql_ssl_rsa_setup 
[root@iZwz94frx7uycgt86fcerpZ mysql]# service mysql start
Starting MySQL.                                            [  OK  ]
[root@iZwz94frx7uycgt86fcerpZ mysql]# chkconfig --add mysql
[root@iZwz94frx7uycgt86fcerpZ mysql]# chkconfig --list

Note: This output shows SysV services only and does not include native
      systemd services. SysV configuration data might be overridden by native
      systemd configuration.

      If you want to list systemd services use 'systemctl list-unit-files'.
      To see services enabled on particular target use
      'systemctl list-dependencies [target]'.

aegis          	0:off	1:off	2:on	3:on	4:on	5:on	6:off
mysql          	0:off	1:off	2:on	3:on	4:on	5:on	6:off
netconsole     	0:off	1:off	2:off	3:off	4:off	5:off	6:off
network        	0:off	1:off	2:on	3:on	4:on	5:on	6:off

---

使用临时密码连接数据库，修改root密码，创建数据库并授权新用户权限

[root@iZwz94frx7uycgt86fcerpZ mysql]# mysql -u root -p
.
.
.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
.
.
mysql>
mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> CREATE DATABASE IF NOT EXISTS firstSql DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_general_ci;
Query OK, 1 row affected (0.01 sec)

mysql> 
mysql> grant select,insert,update,delete on firstSql.* to appuser@"%" identified by "123456";
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

---

最后使用Navicat测试连接

mysql安装完成！！！

感谢阅读！