Linux - centos8 安装 mysql 8

淩亂°似流年 2022-11-05 07:29 206阅读 0赞

[感谢文章-Linux下安装mysql-5.7.24][-Linux_mysql-5.7.24]  
***centos8 + [mysql-8.0.22][]***

## 安装前 ##

MySQL [官网][Link 1]下载  
或命令

cd /usr/local/mysql
    wget https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDYyNjk4_size_16_color_FFFFFF_t_70]  
**查看是否已安装**`rpm -qa | grep mysql`  
下载目录 /usr/local/mysql  
![在这里插入图片描述][20210304161351992.png]  
解压`tar xvJf mysql-8.0.22-linux-glibc2.12-x86_64.tar`  
删除 `rm -rf mysql-8.0.22-linux-glibc2.12-x86_64.tar`  
![在这里插入图片描述][20210304163911307.png]  
检查用户组`cat /etc/group | grep mysql`用户`cat /etc/passwd |grep mysql`  
添加用户组 `groupadd mysql`  
添加用户`useradd -r -g mysql mysql`  
查看`groups mysql`  
创建data `mkdir /usr/local/mysql/mysql/data`  
目录拥有者 `cd /usr/local/mysql`

chown -R mysql:mysql /usr/local/mysql
    chmod -R 755 /usr/local/mysql

## 开始安装 ##

初始化

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

记住最后的密码`&F,see#3jOqt`  
![在这里插入图片描述][20210304165349136.png]  
配置文件`vi /etc/my.cnf`

[client]
      default-character-set=utf8
      #password   = your_password  
      port        = 3306  
      socket      = /tmp/mysql.sock   
      # Here follows entries for some specific programs  
      # The MySQL server  
      [mysqld]
      basedir=/usr/local/mysql/mysql
      datadir=/usr/local/mysql/mysql/data
      character-set-server=utf8
      init_connect='SET NAMES utf8
      port        = 3306  
      socket      = /tmp/mysql.sock  
      skip-external-locking  
      key_buffer_size = 16M  
      max_allowed_packet = 1M  
      table_open_cache = 64  
      sort_buffer_size = 512K  
      net_buffer_length = 8K  
      read_buffer_size = 256K  
      read_rnd_buffer_size = 512K  
      myisam_sort_buffer_size = 8M  
      character-set-server=utf8  
      init_connect='SET NAMES utf8' 
    
      log-bin=mysql-bin  
        # binary logging format - mixed recommended  
        binlog_format=mixed  
    
          server-id   = 1  
    
            [mysqldump]  
            quick  
            max_allowed_packet = 16M  
     
              [mysql]  
              no-auto-rehash  
              # Remove the next comment character if you are not familiar with SQL  
              #safe-updates  
              default-character-set=utf8   
     
            [myisamchk]  
            key_buffer_size = 20M  
            sort_buffer_size = 20M  
            read_buffer = 2M  
            write_buffer = 2M  
     
              [mysqlhotcopy]  
              interactive-timeout

`lower_case_table_names`：是否区分大小写，1表示存储时表名为小写，操作时不区分大小写；0表示区分大小写；不能动态设置，修改后，必须重启才能生效：  
`character_set_server`：设置数据库默认字符集，如果不设置默认为latin1  
`innodb_file_per_table`：是否将每个表的数据单独存储，1表示单独存储；0表示关闭独立表空间，可以通过查看数据目录，查看文件结构的区别；

## 远程访问 ##

测试`/usr/local/mysql/mysql/support-files/mysql.server start`  
查询服务 用

ps -ef|grep mysql | grep -v grep
    ps -ef|grep mysqld | grep -v grep
    #结束进程
    kill -9 PID

[报错][Link 2] 或 [报错][Link 3] 或 [报错][Link 4]  
添加软连接

ln -s /usr/local/mysql/mysql/support-files/mysql.server /etc/init.d/mysql
    ln -s /usr/local/mysql/mysql/bin/mysql /usr/bin/mysql
    sudo ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
    #重启
    service mysql restart

登录`mysql -u root -p`  
输入刚刚临时密码 `&F,see#3jOqt`  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDYyNjk4_size_16_color_FFFFFF_t_70 1]  
修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';

远程连接, 在mysql的命令行

mysql>use mysql;
    msyql>update user set user.Host='%' where user.User='root';
    mysql>flush privileges;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDYyNjk4_size_16_color_FFFFFF_t_70 2]  
退出`exit;`  
[开放端口][Link 5]

firewall-cmd --zone=public --add-port=3306/tcp --permanent
    systemctl restart firewalld

开机启动  
文件拷贝`cp /usr/local/mysql/mysql/support-files/mysql.server /etc/init.d/mysqld`  
执行权限`chmod +x /etc/init.d/mysqld`  
服务`chkconfig --add mysqld`  
服务列表`chkconfig --list`

[-Linux_mysql-5.7.24]: https://www.jianshu.com/p/276d59cbc529
[mysql-8.0.22]: https://download.csdn.net/download/qq_34462698/15566054
[Link 1]: https://downloads.mysql.com/archives/community/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDYyNjk4_size_16_color_FFFFFF_t_70]: /images/20221023/9d9491e8233345f6bd91f9aa96de79ac.png
[20210304161351992.png]: /images/20221023/099fb00072244dafb567b2c0c6f3a4dc.png
[20210304163911307.png]: /images/20221023/8bd3fe70684244869041ee37cf0e8ad3.png
[20210304165349136.png]: /images/20221023/2115fcacf34d4cf8a9e5dafc29306d47.png
[Link 2]: https://blog.csdn.net/eagle89/article/details/79813405
[Link 3]: https://blog.csdn.net/qevery678/article/details/96422599/
[Link 4]: https://blog.csdn.net/a15835774652/article/details/82151502
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDYyNjk4_size_16_color_FFFFFF_t_70 1]: /images/20221023/6784b183854541c28f33a5c31b1f33aa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDYyNjk4_size_16_color_FFFFFF_t_70 2]: /images/20221023/746948a71c404f58ae62cea4eeb7f719.png
[Link 5]: https://blog.csdn.net/qq_32656561/article/details/105619911