Linux centos 7离线安装MySQL

骑猪看日落 2023-06-08 06:42 30阅读 0赞

1.上传mysql安装包至服务器目录  /usr/local

官网[:https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]

百度云:[https://pan.baidu.com/s/1KIYfwWkSmC07EGFsQzj0kg][https_pan.baidu.com_s_1KIYfwWkSmC07EGFsQzj0kg]  提取码：xnb6

2.解压安装包并改名称为mysql（注意命令中的mysql安装包版本保持一致）

**cd /usr/local**

**`tar -xzvf /usr/local/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz`**

**mv `/usr/local/mysql-5.7.25-linux-glibc2.12-x86_64 mysql`**

3.创建用户组mysql，创建用户mysql并将其添加到用户组mysq中，并赋予读写权限

**groupadd mysql**

**useradd -r -g mysql mysql**

**chown -R mysql mysql/**

**chgrp -R mysql mysql/**

4.创建配置文件

**vi /etc/my.cnf**

①：首先按下insert键，如下状态：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQ1NjQ2Ng_size_27_color_FFFFFF_t_70][]

②：清空之前内容，并粘贴以下内容；

[client]
    port = 3306
    socket = /tmp/mysql.sock
    
    [mysqld]
    character_set_server=utf8
    init_connect='SET NAMES utf8'
    basedir=/usr/local/mysql
    datadir=/usr/local/mysql/data
    socket=/tmp/mysql.sock
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    #不区分大小写
    lower_case_table_names = 1
    #sql_mode配置项
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    default-time_zone = '+8:00'
    #最大连接数 默认150
    max_connections=1000

**③： **按下Esc键，并输入 :wq          （中间有冒号:，命令行意为保存并退出）

![20191017135316514.png][]

5.初始化数据库

\#创建日志文件 打开保存退出

**vi /var/log/mysqld.log**

**:wq**

\#赋予权限

**cd /var/log**

**chmod 777 mysqld.log**

**chown mysql:mysql mysqld.log**

\#执行初始化操作

**/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --lc\_messages\_dir=/usr/local/mysql/share --lc\_messages=en\_US**

6.启动mysql服务

\#创建文件并赋予权限

**mkdir \-p /var/run/mysqld**

**cd /var/run/mysqld/**

**vi mysqld.pid**

**:wq**

**chmod 777 mysqld.pid**

**chown mysql:mysql mysql.pid**

**mkdir -p /var/log/mariadb/  
cd /var/log/mariadb/  
touch mariadb.log**

**chmod -R 775 mariadb.log  
chown -R mysql:mysql mariadb.log**

\#启动

**/usr/local/mysql/support-files/mysql.server start**

7.登录并修改密码

\#查看生成的临时密码

**grep "password" /var/log/mysqld.log**

![2019101714090870.png][]

**/usr/local/mysql/bin/mysql -u root -p**

\#输入临时生成的密码

![20191017140947612.png][]

如果出现上述界面，证明mysql安装成功！

\#修改密码并允许可远程使用root账号连接

alter user 'root'@'localhost' identified by 'Password_123';
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Password_123';
    flush privileges;
    quit;

8.重新启动mysql

**/usr/local/mysql/support-files/mysql.server restart**

\#使用新密码进行登录

**/usr/local/mysql/bin/mysql -uroot -p**

**quit;**

9.设置开机自启

**cd /usr/local/mysql/support-files**

**cp mysql.server /etc/init.d/mysqld**

**chkconfig –add mysqld**

10.使用service mysqld命令启动

**service mysqld restart**

**11.添加系统路径（系统配置文件，操作需谨慎！！）**

**vi /etc/profile**

\#插入下面一行命令

**export PATH=/usr/local/mysql/bin:$PATH**

\#使用:wq保存退出

\#刷新系统配置文件(如果该配置文件出错，有几率使得服务器出现连接不上的问题哦~~)

**source /etc/profile**

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[https_pan.baidu.com_s_1KIYfwWkSmC07EGFsQzj0kg]: https://pan.baidu.com/s/1KIYfwWkSmC07EGFsQzj0kg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQ1NjQ2Ng_size_27_color_FFFFFF_t_70]: /images/20230531/18063848077e485ba3e82236e21dc347.png
[20191017135316514.png]: /images/20230531/36f14acfd815403abd66b3122a50c01f.png
[2019101714090870.png]: /images/20230531/87dff0f1ef0c42b4922c69620fdae92a.png
[20191017140947612.png]: /images/20230531/1bde5007a0274cc697e7f9e4cb943907.png