Linux离线安装mysql8.0.x mysql8.0.x安装配置

港控/mmm° 2024-04-18 18:58 31阅读 0赞

**〇、下载 安装包 链接：[点击下载][Link 1] 提取码：yn9z **

**一、上传安装包到Linux **

1、传路径：/usr/local/

![20190910180420508.png][]

**2、解压缩**

tar xvf mysql-8.0.17-linux-glibc2.12-x86_64.tar.xz

**3、重命名**

mv mysql-8.0.17-linux-glibc2.12-x86_64 mysql

![20190910180838416.png][]

**二、安装配置**

1、修改  vi /etc/my.cnf

[client]
    port=3306
    socket=/var/lib/mysql/mysql.sock
     
    [mysqld]
    port=3306
    user=mysql
    socket=/var/lib/mysql/mysql.sock
    basedir=/usr/local/mysql
    datadir=/usr/local/mysql/data

**2、创建mysql组与用户**

groupadd mysql
    useradd -g mysql mysql

**3、初始化mysql**

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

**  执行结果如下【**root@localhost: 跟着的是**初始密码。记下，后面用到 】：**

> 2019-09-10T10:24:51.816431Z 0 \[System\] \[MY-013169\] \[Server\] /usr/local/mysql/bin/mysqld (mysqld 8.0.17) initializing of server in progress as process 11400  
> 2019-09-10T10:24:56.404516Z 5 \[Note\] \[MY-010454\] \[Server\] A temporary password is generated for root@localhost: **)sTNHf/sp7er**  
> 2019-09-10T10:24:58.587884Z 0 \[System\] \[MY-013170\] \[Server\] /usr/local/mysql/bin/mysqld (mysqld 8.0.17) initializing of server has completed

**4、创建sock文件夹与命令链接**

mkdir -p /var/lib/mysql ; chown -R mysql:mysql /var/lib/mysql
    ln -s /usr/local/mysql/bin/mysql /usr/bin

**5、启动服务**

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

![20190910183255130.png][]

**6、修改初始密码**

mysql -uroot -p

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70][]

修改密码 ，我这里的新密码是123456

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

![20190910183945641.png][]

**7、开启远程访问**

use mysql;
    update user set host='%' where user='root';
    flush privileges; 
    exit;

![20190910184218797.png][]

**8、关闭防火墙**

systemctl stop firewalld.service            #停止firewall        
    systemctl disable firewalld.service         #禁止firewall开机启动

9、配置成服务并开机启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
    chkconfig mysql on
    chkconfig --add mysql

这样可以使用命令

service mysql start

service mysql stop

**二、远程访问**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 1][]

[Link 1]: https://pan.baidu.com/s/1IZbA4JmuBvnKWcSU5mt56w
[20190910180420508.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/2b04152a099b4947b76e18b97034c74a.png
[20190910180838416.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/475f10196a8e4acbaaaeb269faba35ee.png
[20190910183255130.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/5bf556c3bc3d4688b71ffd7d1c124d1d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/18bc606a77df4c2d927c7ced9494fe2e.png
[20190910183945641.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/4d0b472b0b3b47678407e906c3423d2c.png
[20190910184218797.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/566f6c5f8ced4a7aaa1bb3160da6b646.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/1c654a9d6c774dbdb21578271bb7cb27.png