Mysql5.x二进制安装 查看系统是否有遗留mariadb的依赖软件需要移除 #rpm -qa|grep mariadb* mariadb-libs-5.5.60-1.el7_5.x86_64 移除，卸载掉 yum remove mariadb-libs -y 创建mysql用户 useradd -s /sbin/nologin mysql -M 解压： tar -xf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz -C /usr/local/ 创建软连接方便调用 ln -s /usr/local/mysql-5.7.28-linux-glibc2.12-x86_64/ /usr/local/mysql 创建系统变量，方便系统做调用 echo 'PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile.d/mysql.sh 让这一条系统变量生效 . /etc/profile.d/mysql.sh 创建数据库目录 mkdir -p /mysqldb/3306/data 创建日志目录 mkdir -p /mysqldb/3306/log 创建socket存放路径 mkdir -p /mysqldb/3306/socket 创建Pid存放目录 mkdir -p /mysqldb/3306/pid/ 授权pid文件 chown -R mysql.mysql /mysqldb/3306/pid/ 授权mysql目录和数据库存放目录 chown -R mysql.mysql /usr/local/mysql/ 授权数据库存放目录 chown -R mysql.mysql /mysqldb/ 初始化之前先来安装一个libaio-devel库文件，不然初始化会报错 yum install libaio-devel -y 再来初始化数据库 mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/mysqldb/3306/data 返回结果，如果结果和下面的类似说明数据库初始化就成功了 2020-04-29T08:35:03.806372Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-04-29T08:35:04.761963Z 0 [Warning] InnoDB: New log files created, LSN=45790 2020-04-29T08:35:04.918995Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2020-04-29T08:35:04.988715Z 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: 533f0806-89f4-11ea-aa87-000c29eaed33. 2020-04-29T08:35:04.992173Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2020-04-29T08:35:07.152961Z 0 [Warning] CA certificate ca.pem is self signed. 2020-04-29T08:35:07.837138Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option 解释： mysqld 数据服务 --initialize-insecure 数据初始化过程中，不分配随机密码，也就是没有密码 --user=mysql mysql运行用户 --basedir=/usr/local/mysql mysql软件存放路径 --datadir=/mysqldb/3306/data 数据库存放路径 扩展： --initialize 初始化完成后，会有12位临时密码，但是必须在使用之前重置这个密码 密码管理使用严格模式，3种密码复杂模式，密码最少8位大小写数字加英文 初始化以后再来编写配置文件 vim /etc/my.cnf [mysqld] user=mysql basedir=/usr/local/mysql datadir=/mysqldb/3306/data server_id=1 log-bin=mysql-bin log-slave-updates slave-skip-errors=all port=3306 socket=/mysqldb/3306/socket/mysql.socket pid-file=/mysqldb/3306/pid/mysql.pid [client] default-character-set=utf8 socket=/mysqldb/3306/socket/mysql.socket [mysql] default-character-set=utf8 解释： user=mysql mysql运行用户 basedir=/usr/local/mysql 数据库软件安装路径 datadir=/mysqldb/3306/data 数据库数据存放位置 server_id=1 服务端ID号 port=3306 服务端运行端口号 socket=/mysqldb/3306/socket/mysql.socket mysqld运行的接口 pid-file=/mysqldb/3306/pid/mysql.pid mysql启动的PID进程号存放位置 [client] socket=/mysqldb/3306/socket/mysql.socket 客户端连接接口 复制启动脚本，方便系统启动 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld 添加到系统服务中去 chkconfig --add mysqld 设置mysql开机自启动 chkconfig mysqld on mysql启动命令 service mysqld start mysql停止命令 service mysqld stop mysql重启命令 service mysqld restart