Linux7.6二進制安裝Mysql8.0.27詳細操作步驟
更新時間：2021年11月26日 10:40:44 作者：IT邦德
大家好，本篇文章主要講的是Linux7.6二進制安裝Mysql8.0.27詳細操作步驟，感興趣的同學(xué)快來看一看吧，希望對你起到幫助
一、環(huán)境準備
1.1 操作系統(tǒng)版本
[root@rhel76 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.6 (Maipo)
1.2 磁盤空間
[root@rhel76 ~]# df -TH Filesystem Type Size Used Avail Use% Mounted on /dev/mapper/rhel-root xfs 32G 4.6G 27G 15% / devtmpfs devtmpfs 2.1G 0 2.1G 0% /dev tmpfs tmpfs 2.1G 0 2.1G 0% /dev/shm tmpfs tmpfs 2.1G 14M 2.1G 1% /run tmpfs tmpfs 2.1G 0 2.1G 0% /sys/fs/cgroup /dev/sda1 xfs 996M 172M 825M 18% /boot /dev/mapper/rhel-u01 xfs 30G 34M 30G 1% /u01 tmpfs tmpfs 413M 4.1k 413M 1% /run/user/42 tmpfs tmpfs 413M 46k 413M 1% /run/user/0
1.3 關(guān)閉防火墻
[root@rhel76 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2021-11-23 23:46:04 UTC; 9min ago
Docs: man:firewalld(1)
Main PID: 9621 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─9621 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
Nov 23 23:46:03 rhel76 systemd[1]: Starting firewalld - dynamic firewall daemon...
Nov 23 23:46:04 rhel76 systemd[1]: Started firewalld - dynamic firewall daemon.
[root@rhel76 ~]# systemctl stop firewalld
[root@rhel76 ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
1.4 關(guān)閉 selinux
[root@rhel76 ~]# getenforce Enforcing [root@rhel76 ~]# cp /etc/selinux/config /etc/selinux/config_`date +"%Y%m%d_%H%M%S"` [root@rhel76 ~]# sed -i 's/SELINUX\=enforcing/SELINUX\=disabled/g' /etc/selinux/config 以上修改完后重啟 [root@rhel76 ~]# reboot [root@rhel76 ~]# getenforce Disabled [root@rhel76 ~]# sestatus SELinux status: disabled
1.5 HOST解析
[root@rhel76 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.6.81 rhel76 [root@rhel76 ~]# hostname rhel76
1.6 Mysql下載
https://dev.mysql.com/downloads/mysql/ MD5: 0bdd171cb8464ba32f65f7bf58bc9533
二、 yum安裝及配置
2.1 掛載本地光盤鏡像
[root@rhel76 ~]# mkdir -p /mnt/dvd/ [root@rhel76 ~]# df -TH Filesystem Type Size Used Avail Use% Mounted on /dev/mapper/rhel-root xfs 32G 4.7G 27G 15% / devtmpfs devtmpfs 2.1G 0 2.1G 0% /dev tmpfs tmpfs 2.1G 0 2.1G 0% /dev/shm tmpfs tmpfs 2.1G 14M 2.1G 1% /run tmpfs tmpfs 2.1G 0 2.1G 0% /sys/fs/cgroup /dev/sda1 xfs 996M 172M 825M 18% /boot /dev/mapper/rhel-u01 xfs 30G 34M 30G 1% /u01 tmpfs tmpfs 413M 21k 413M 1% /run/user/0 tmpfs tmpfs 413M 13k 413M 1% /run/user/42 /dev/sr0 iso9660 4.5G 4.5G 0 100% /run/media/root/RHEL-7.6 Server.x86_64 [root@rhel76 ~]# mount /dev/sr0 /mnt/dvd mount: /dev/sr0 is write-protected, mounting read-only You have mail in /var/spool/mail/root
2.2 配置yum源
[root@rhel76 ~]# cd /etc/yum.repos.d/ [root@rhel76 yum.repos.d]# cat >> /etc/yum.repos.d/redhat.repo << "EOF" > [rhel7] > name=jeames repo > baseurl=file:///mnt/dvd/ > gpgcheck=0 > EOF
2.3 安裝依賴包
[root@rhel76 ~]# yum -y groupinstall "DeveLopment tools" Loaded plugins: fastestmirror, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. There is no installed groups file. Maybe run: yum groups mark convert (see man yum) Loading mirror speeds from cached hostfile Warning: Group development does not have any packages to install. Maybe run: yum groups mark install (see man yum) No packages in any requested group available to install or update [root@rhel76 ~]# yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make
三、卸載MariaDB
[root@rhel76 ~]# rpm -qa |grep mariadb mariadb-libs-5.5.60-1.el7_5.x86_64 [root@rhel76 ~]# rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
四、安裝 MySQL
4.1 用戶及目錄創(chuàng)建
注：可以部署多個實例，通過端口區(qū)分root 用戶操作：mkdir -p /mysql/data/mysql3306mkdir -p /mysql/app/mkdir -p /mysql/conf/mkdir -p /mysql/data/mysql3306/pid/mkdir -p /mysql/data/mysql3306/socket/mkdir -p /mysql/data/mysql3306/log/mkdir -p /mysql/data/mysql3306/binlog/mkdir -p /mysql/data/mysql3306/errlogmkdir -p /mysql/data/mysql3306/relaylog/mkdir -p /mysql/data/mysql3306/slowlog/mkdir -p /mysql/data/mysql3306/tmp/
4.2 用戶及組
[root@rhel76 ~]# groupadd mysql [root@rhel76 ~]# useradd -g mysql mysql [root@rhel76 ~]# chown -R mysql:mysql /mysql [root@rhel76 ~]# passwd mysql Changing password for user mysql. New password: BAD PASSWORD: The password is shorter than 8 characters Retype new password: passwd: all authentication tokens updated successfully. [root@rhel76 ~]# cat /etc/group | grep mysql mysql:x:1001: [root@rhel76 ~]# cat /etc/passwd | grep mysql mysql:x:1001:1001::/home/mysql:/bin/bash
4.3 上傳軟件包并解壓
[root@rhel76 ~]# cp mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz /mysql/app [root@rhel76 ~]# chown -R mysql:mysql /mysql mysql用戶操作 [root@rhel76 ~]# su - mysql md5 值驗證，保證下載到的軟件包無破損無木馬 [mysql@rhel76 ~]$ cd /mysql/app [mysql@rhel76 app]$ ll total 1168588 -rw-r--r-- 1 mysql mysql 1196633756 Nov 24 00:49 mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz [mysql@rhel76 app]$ md5sum mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz 0bdd171cb8464ba32f65f7bf58bc9533 mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz 解壓軟件包并重命名 [mysql@rhel76 app]$ tar xvf mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz [mysql@rhel76 app]$ mv mysql-8.0.27-linux-glibc2.12-x86_64 mysql8.0.27 [mysql@rhel76 app]$ ll total 1168588 drwxrwxr-x 9 mysql mysql 129 Nov 24 00:54 mysql8.0.27 -rw-r--r-- 1 mysql mysql 1196633756 Nov 24 00:49 mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz
五.環(huán)境變量配置
cat >> /home/mysql/.bash_profile << "EOF" MYSQL_HOME=/mysql/app/mysql8.0.27 PATH=$PATH:$HOME/.local/bin:$HOME/bin:$MYSQL_HOME/bin EOF source ~/.bash_profile which mysql
六.創(chuàng)建參數(shù)文件
由于是二進制文件安裝，數(shù)據(jù)庫參數(shù)文件需要自己配置 cat >> /mysql/conf/my3306.cnf << "EOF" [mysqld] server_id = 80273306 default-storage-engine= InnoDB basedir=/mysql/app/mysql8.0.27 datadir=/mysql/data/mysql3306/data/ socket=/mysql/data/mysql3306/socket/mysql.sock log-error=/mysql/data/mysql3306/log/mysqld.log pid-file=/mysql/data/mysql3306/pid/mysqld.pid port=3306 default-time_zone='+8:00' default_authentication_plugin=mysql_native_password # 加此參數(shù)可遠程登陸 transaction_isolation=READ-COMMITTED max_connections=1500 back_log=500 wait_timeout=1800 max_user_connections=800 innodb_buffer_pool_size=1024M innodb_log_file_size=512M innodb_log_buffer_size=40M slow_query_log=ON long_query_time=5 # log settings # slow_query_log = ON slow_query_log_file = /mysql/data/mysql3306/slowlog/slow3306.log log_error = /mysql/data/mysql3306/errlog/err3306.log log_error_verbosity = 3 log_bin = /mysql/data/mysql3306/binlog/mysql_bin log_bin_index = /mysql/data/mysql3306/binlog/mysql_binlog.index general_log_file = /data/mysql/mysql3306/generallog/general.log log_queries_not_using_indexes = 1 log_slow_admin_statements = 1 expire_logs_days = 90 binlog_expire_logs_seconds = 2592000 #30d long_query_time = 2 min_examined_row_limit = 100 log_throttle_queries_not_using_indexes = 1000 innodb_flush_log_at_trx_commit=1 EOF
七.數(shù)據(jù)庫初始化
mysql用戶操作： mysqld --defaults-file=/mysql/conf/my3306.cnf --initialize --user=mysql --basedir=/mysql/app/mysql8.0.27 --datadir=/mysql/data/mysql3306/data/ 注意：以上同一行執(zhí)行
八.啟動Mysql
[mysql@rhel76 ~]$ mysqld_safe --defaults-file=/mysql/conf/my3306.cnf --user=mysql & [1] 21406 [mysql@rhel76 ~]$ 2021-11-24T06:14:23.240372Z mysqld_safe Logging to '/mysql/data/mysql3306/errlog/err3306.log'. 2021-11-24T06:14:23.296992Z mysqld_safe Starting mysqld daemon with databases from /mysql/data/mysql3306/data
九.登陸Mysql
第一次登錄 MySQL 時，需要到錯誤日志下找初始化密碼，我這里的密碼為：-(Qy5Aj9t,=a 使用 socket 加密碼登錄進去后，無法查詢?nèi)魏螙|西，提示先要修改 root 密碼。 [mysql@rhel76 ~]$ cat /mysql/data/mysql3306/errlog/err3306.log | grep password 2021-11-24T06:12:14.610657Z 0 [Note] [MY-010309] [Server] Auto generated RSA key files through --sha256_password_auto_generate_rsa_keys are placed in data directory. 2021-11-24T06:12:14.610686Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory. 2021-11-24T06:12:14.615367Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: -(Qy5Aj9t,=a 2021-11-24T06:14:26.153958Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory. 2021-11-24T06:14:26.153979Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory. [mysql@rhel76 ~]$ mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ##此處通過sock登陸 [mysql@rhel76 ~]$ mysql -uroot -p -P 3306 -S /mysql/data/mysql3306/socket/mysql.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.27 Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> status ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
十.修改密碼
mysql> alter user root@'localhost' identified by 'root';Query OK, 0 rows affected (0.01 sec)mysql> status--------------mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - GPL)Connection id: 8Current database:Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: 8.0.27Protocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8mb4Db characterset: utf8mb4Client characterset: utf8mb4Conn. characterset: utf8mb4UNIX socket: /mysql/data/mysql3306/socket/mysql.sockBinary data as: HexadecimalUptime: 8 min 0 secThreads: 2 Questions: 7 Slow queries: 0 Opens: 398 Flush tables: 3 Open tables: 36 Queries per second avg: 0.014--------------
十一.遠程登陸設(shè)置
使用如下語句創(chuàng)建 root 用戶是無法通過 navicat 等客戶端登錄的， 由于從 MySQL8 開始，身份驗證插件發(fā)生改變， 默認的 “caching_sha2_password” 不允許遠程登錄， 故需將此插件修改為 “mysql_native_password” 便可登錄。 mysql> create user root@'%' identified with mysql_native_password by 'root'; mysql> grant all on *.* to root@'%' with grant option; mysql> flush privileges; mysql> select user,host,plugin from mysql.user; +------------------+-----------+-----------------------+ | user | host | plugin | +------------------+-----------+-----------------------+ | root | % | mysql_native_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | root | localhost | mysql_native_password | +------------------+-----------+-----------------------+ 5 rows in set (0.00 sec)
到此這篇關(guān)于Linux7.6二進制安裝Mysql8.0.27詳細操作步驟的文章就介紹到這了,更多相關(guān)Linux7.6二進制安裝Mysql8.0.27內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！
相關(guān)文章
這篇文章主要介紹了MySQL使用命令備份和還原數(shù)據(jù)庫,本文使用Mysql內(nèi)置命令實現(xiàn)備份和還原,比較簡單,需要的朋友可以參考下2015-01-01
深入探尋mysql自增列導(dǎo)致主鍵重復(fù)問題的原因
前幾天開發(fā)的同事反饋一個利用load data infile命令導(dǎo)入數(shù)據(jù)主鍵沖突的問題，分析后確定這個問題可能是mysql的一個bug，這里提出來給大家分享下。以免以后有童鞋遇到類似問題百思不得其解，難以入眠，哈哈。2014-08-08
這篇文章主要介紹了mysql如何在存儲過程中輸出日志信息問題,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教2023-11-11
下面小編就為大家?guī)硪黄猄QL查詢語句優(yōu)化的實用方法總結(jié)。小編覺得挺不錯的，現(xiàn)在就分享給大家，也給大家做個參考。一起跟隨小編過來看看吧2016-12-12
MySQL DISTINCT 的基本實現(xiàn)原理詳解
這篇文章主要介紹了MySQL DISTINCT 的基本實現(xiàn)原理詳解,文中通過示例代碼介紹的非常詳細，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友可以參考下2019-07-07
mysql 存儲過程判斷重復(fù)的不插入數(shù)據(jù)
這篇文章主要介紹了下面是一個較常見的場景，判斷表中某列是否存在某值，如果存在執(zhí)行某操作,需要的朋友可以參考下2017-01-01
這篇文章主要介紹了解決Mysql服務(wù)器啟動時報錯問題的方法，需要的朋友可以參考下2015-11-11
死鎖是指兩個或兩個以上的進程在執(zhí)行過程中,因爭奪資源而造成的一種互相等待的現(xiàn)象,若無外力作用，它們都將無法推進下去.此時稱系統(tǒng)處于死鎖狀態(tài)或系統(tǒng)產(chǎn)生了死鎖，本文就給大家介紹一下MySQL死鎖產(chǎn)生的原因和解決方法2023-07-07
這篇文章主要介紹了mysql的case when字段為空，null的問題。具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教2022-12-12
這篇文章主要給大家介紹了關(guān)于MySQL設(shè)置用戶權(quán)限的簡單步驟,學(xué)習(xí)MySQL數(shù)據(jù)庫,MySQL用戶權(quán)限設(shè)置是需要首先學(xué)習(xí)的,需要的朋友可以參考下2023-07-07