linux mysql5.7 安装教程_Linux（Centos 7）安装 Mysql 5.7 步骤配置过程

喜欢ヅ旅行 2023-01-11 13:17 137阅读 0赞

一、检查是否已经安装了mysql

\[root@localhost /\]\# rpm -qa | grep -i mysql

如果有，则使用删除语句删除

\[root@localhost /\]\# yum -y remove mariadb-libs-5.5.56-2.el7.x86\_64

再使用查询命令，查找mysql相关的文件

\[root@localhost /\]\# find / -name mysql

然后把存在的文件都删除

\[root@localhost /\]\# rm –rf \{目录名\}

二、下载mysql安装包

进入包下载所放位置下载

\[root@localhost /\]\# cd /usr/local/src

\[root@localhost src\]\# wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86\_64.tar.gz

进行解压

\[root@localhost src\]\# tar zxvf mysql-5.7.25-linux-glibc2.12-x86\_64.tar.gz

\[root@localhost src\]\# ls

mysql-5.7.25-linux-glibc2.12-x86\_64 mysql-5.7.25-linux-glibc2.12-x86\_64.tar.gz

移位置并改名

\[root@localhost src\]\# mv mysql-5.7.25-linux-glibc2.12-x86\_64 /usr/local/mysql

\[root@localhost src\]\# cd /usr/local/mysql

\[root@localhost mysql\]\# ls

bin COPYING docs include lib man README share support-files

三、配置初始化mysql

添加用户组和新用户名

\[root@localhost mysql\]\# groupadd mysql

\[root@localhost mysql\]\# useradd -r -g mysql -s /bin/false mysql

创建data目录

\[root@localhost mysql\]\# mkdir data

修改mysql目录用户为刚刚新建的mysql组中的mysql用户

\[root@localhost mysql\]\# chown -R mysql:mysql ./

安装必要文件包

\[root@localhost mysql\]\# yum install -y libaio

初始化安装mysql数据库

\[root@localhost mysql\]\#./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize

2019-07-07T07:51:36.066665Z 0 \[Warning\] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).

2019-07-07T07:51:37.197916Z 0 \[Warning\] InnoDB: New log files created, LSN=45790

2019-07-07T07:51:37.299392Z 0 \[Warning\] InnoDB: Creating foreign key constraint system tables.

2019-07-07T07:51:37.823229Z 0 \[Warning\] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0c916440-a08c-11e9-87be-000c2954a0d9.

2019-07-07T07:51:37.846198Z 0 \[Warning\] Gtid table is not ready to be used. Table 'mysql.gtid\_executed' cannot be opened.

2019-07-07T07:51:37.847191Z 1 \[Note\] A temporary password is generated for root@localhost: yrntyj)qo6Nd

修改my.cnf配置文件，从版本5.7.18开始，mysql免安装二进制包中就不包含该文件了，即不需要my.cnf文件也可以正常运行；my.conf文件中配置的选项会在命令行启动mysql的时候作为参数进行启动，为了后面搭建mysql主从环境方便，下面可以添加了一个简单的my.cnf文件作为实例(如果只是单纯的搭建一个mysql实例，可以直接忽略此步骤)，使用vim /etc/my.cnf命令，如果在该目录上不存在则会新建

\[mysqld\]

datadir=/data/mysql/data

socket=/tmp/mysql.sock

\[mysqld\_safe\]

log-error=/var/log/mysqld.log

pid-file=/usr/local/mysql/data/mysqld.pid

四、其他配置

添加开机启动

\[root@localhost mysql\]\# cp ./support-files/mysql.server /etc/init.d/mysqld

修改mysqld，使用vim /etc/init.d/mysqld 命令 修改以下代码部分

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data