RHEL7.6安裝MySQL5.6.30

[root@mysql ~]# cat /etc/redhat-release?
Red Hat Enterprise Linux Server release 7.6 (Maipo)
[root@mysql ~]# cat /proc/version?
Linux version 3.10.0-957.el7.x86_64 (mockbuild@x86-040.build.eng.bos.redhat.com)?
(gcc version 4.8.5 20150623 (Red Hat 4.8.5-36) (GCC) ) #1 SMP Thu Oct 4 20:48:51 UTC 2018

[root@mysql ~]# mkdir /software
[root@mysql ~]# cd /software/
[root@mysql software]# ll
total 31472
-rw-r--r--. 1 root root 32223818 Jul 27 12:05 mysql-5.6.30.tar.gz

安裝yum源，方便后面安裝相關軟件包
[root@mysql yum.repos.d]# mkdir /media/cdrom?
[root@mysql yum.repos.d]# mount /dev/cdrom /media/cdrom/
mount: /dev/sr0 is write-protected, mounting read-only
[root@mysql software]# cd /etc/yum.repos.d/
[root@mysql yum.repos.d]# ll
total 4
-rw-r--r--. 1 root root 358 Jul 27 11:23 redhat.repo
[root@mysql yum.repos.d]# rm -rf redhat.repo?
[root@mysql yum.repos.d]# vi rhel.repo
[root@mysql yum.repos.d]# cat rhel.repo?
[rhel]
name=rhel
baseurl=file:///media/cdrom
enable=1
gpgcheck=0
[root@mysql yum.repos.d]# yum clean all
[root@mysql yum.repos.d]# yum repolist all

查看相關安裝包是否安裝，未安裝的需要手動安裝，最好相關依賴包都安裝上
[root@mysql software]# rpm -qa | grep make
automake-1.13.4-3.el7.noarch
make-3.82-23.el7.x86_64

[root@mysql software]# rpm -qa | grep bison
bison-3.0.4-2.el7.x86_64

[root@mysql software]# rpm -qa | grep gcc
gcc-gfortran-4.8.5-36.el7.x86_64
gcc-4.8.5-36.el7.x86_64
libgcc-4.8.5-36.el7.x86_64
gcc-c++-4.8.5-36.el7.x86_64

[root@mysql software]# rpm -qa | grep cmake
cmake-2.8.12.2-2.el7.x86_64

[root@mysql software]# rpm -qa | grep ncurses
ncurses-libs-5.9-14.20130511.el7_4.x86_64
ncurses-devel-5.9-14.20130511.el7_4.x86_64 ??
ncurses-base-5.9-14.20130511.el7_4.noarch
ncurses-5.9-14.20130511.el7_4.x86_64

創建用戶和組
[root@mysql software]# groupadd mysql
[root@mysql software]# useradd mysql -g mysql -M -s /sbin/nologin
--------- ? ? -M表示不建立用戶根目錄，-s表示該用戶不能登錄操作系統

創建/data/mysql
[root@mysql software]mkdir -p /data/mysql

解壓并安裝MySQL軟件包
[root@mysql software]# tar -zxvf mysql-5.6.30.tar.gz
[root@mysql software]# cd mysql-5.6.30/
[root@mysql mysql-5.6.30]# cmake ./

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
cmake ./ ? 報錯curses library not found. please install appropriate package

刪除剛才編譯生成的 CMakeCache.txt 文件
rm -f CMakeCache.txt

安裝 ncurses-devel 包
yum install ncurses-devel
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

[root@mysql mysql-5.6.30]# make ?
------------ ? ?這個過程有點長，將近半個小時

[root@mysql mysql-5.6.30]# make install ? ??

[root@mysql mysql]# cd /usr/local/mysql

[root@mysql mysql]# chown -R root:mysql .
[root@mysql mysql]# chown -R mysql:mysql ./data
[root@mysql mysql]# chmod -R ug+rwx .
[root@mysql mysql]# cp support-files/my-default.cnf /etc/my.cnf
[root@mysql mysql]# vi /etc/my.cnf

在[mysqld]下面添加：

user=mysql
datadir=/data/mysql
default-storage-engine=MyISAM

[root@mysql mysql]#scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql --user=mysql

啟動MySQL
[root@mysql mysql]# bin/mysqld_safe --user=mysql &

查看MySQL是否啟動成功
[root@mysql ~]# ps -ef | grep mysql
avahi ? ? ?9327 ? ? ?1 ?0 15:28 ? ? ? ? ?00:00:00 avahi-daemon: running [mysql.local]
root ? ? ?83638 ?10619 ?0 16:47 pts/0 ? ?00:00:00 /bin/sh bin/mysqld_safe --user=mysql
mysql ? ? 83774 ?83638 ?0 16:47 pts/0 ? ?00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/mysql.err --pid-file=/data/mysql/mysql.pid
root ? ? ?83859 ?26291 ?0 16:52 pts/1 ? ?00:00:00 grep --color=auto mysql
[root@mysql ~]# netstat -tnl | grep 3306
tcp6 ? ? ? 0 ? ? ?0 :::3306 ? ? ? ? ? ? ? ? :::* ? ? ? ? ? ? ? ? ? ?LISTEN

在RHEL7中，使用systemctl 啟動mysql
[root@mysql mysql]# cp support-files/mysql.server /etc/init.d/mysql
[root@mysql mysql]# service mysql status
?SUCCESS! MySQL running (83774)
[root@mysql mysql]# service mysql stop
Shutting down MySQL. SUCCESS!?
[root@mysql mysql]# service mysql start
Starting MySQL. SUCCESS!

[root@mysql mysql]# vim /usr/lib/systemd/system/mysqld.service

[Unit]
Description=MySQL Server
After=network.target
After=syslog.target
[Service]
User=mysql
Group=mysql
Type=forking
PermissionsStartOnly=true
ExecStart= /etc/init.d/mysqld start
ExecStop= /etc/init.d/mysqld stop
ExecReload= /etc/init.d/mysqld restart
LimitNOFILE = 5000
[Install]
WantedBy=multi-user.target

[root@mysql mysql]# systemctl daemon-reload?
[root@mysql mysql]# systemctl start mysql
[root@mysql mysql]# systemctl status mysql
mysql.service - LSB: start and stop MySQL
Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
Active: active (exited) since Tue 2021-07-27 16:57:43 CST; 2s ago
Docs: man:systemd-sysv-generator(8)
Process: 84193 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=0/SUCCESS)
Jul 27 16:57:42 mysql systemd[1]: Starting LSB: start and stop MySQL...
Jul 27 16:57:43 mysql systemd[1]: Started LSB: start and stop MySQL.
Jul 27 16:57:43 mysql mysql[84193]: Starting MySQL SUCCESS!

測試
[root@mysql bin]# pwd
/usr/local/mysql/bin
[root@mysql bin]# ./mysql
Welcome to the MySQL monitor. ?Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.30 Source distribution

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

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> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host,user from mysql.user;
+-----------+------+
| host ? ? ?| user |
+-----------+------+
| 127.0.0.1 | root |
| ::1 ? ? ? | root |
| localhost | ? ? ?|
| localhost | root |
| mysql ? ? | ? ? ?|
| mysql ? ? | root |
+-----------+------+
6 rows in set (0.00 sec)

mysql> exit
Bye

總結

以上是生活随笔為你收集整理的RHEL7.6安装MySQL5.6.30的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。