centos7离线安装mysql 二进制方式

centos安装mysql

1. 创建用户

groupadd mysql
useradd -r -g mysql -s /bin/false mysql

2. 上传mysql二进制文件到/home

mysql-5.7.34-linux-glibc2.12-x86_64.tar

3. 解压到/home/mysql目录

tar -zxvf mysql-5.7.34-linux-glibc2.12-x86_64.tar /home/mysql

4. 创建目录

cd /home/mysql
mkdir data logdir

5. 修改目录权限

cd /home
chown -R mysql:mysql mysql
chmod 750 mysql

6. 修改环境变量

vi /etc/profile
export PATH=/home/mysql/bin:$PATH
source /etc/profile

7. 配置service支持mysqld，mysql命令

cp /home/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
cp /home/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql

8. 初始化数据库

mysqld  --initialize-insecure  --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data

9. 添加并修改my.cnf

cd /etc
vi my.cnf

my.cnf文件如下

[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
basedir=/home/mysql
datadir=/home/mysql/data
socket=/tmp/mysql.sock
log-error=/home/mysql/logdir/mysqld.log
pid-file=/home/mysql/data/mysqld.pid
#不区分大小写
lower_case_table_names = 1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=5000
default-time_zone = '+8:00'

10. 启动mysql

    service mysql start
    

报错：
Starting MySQL.2022-09-29T11:26:43.367099Z mysqld_safe error: log-error set to '/home/mysql/logdir/mysqld.log', however file don't exists. Create writable for user 'mysql'.
 ERROR! The server quit without updating PID file (/home/mysql/data/mysqld.pid).
因为my.cnf配置的日志文件没有创建：

执行如下命令

```
touch /home/mysql/logdir/mysqld.log
chmod -R mysql:mysql /home/mysql
```

11. 修改登录密码

mysql -uroot -p
密码为空

ALTER USER 'root'@'localhost'  IDENTIFIED WITH mysql_native_password BY 'hisense';
FLUSH PRIVILEGES;

12. 增加远程登录

    grant all privileges on *.* to 'root'@'%' identified by 'hisense';
    

13. 设置开机启动

    chkconfig mysql on
    查看是否成功
    chkconfig --list | grep msyql