二進(jìn)制包安裝mysql

準(zhǔn)備

1.先查看系統(tǒng)中是否已存在mysql，存在將其卸載

rpm -qa mysql
rpm -qa mariadb
yum remove xxx -y

2.環(huán)境清理 清空PATH有關(guān)的mysql 注釋掉之前的$PATH 沒有就跳過這步

#export PATH=/application/mysql/bin:$PATH

3.安裝所需的基礎(chǔ)依賴

yum install ncurses-devel libaio-devel gcc make cmake -y

4.創(chuàng)建用戶

useradd -s /sbin/nologin -M mysql

實驗步驟

mysql官網(wǎng)下載

1.下載二進(jìn)制安裝包

自行選擇一個下載目錄 這里我下載到/opt下

wget https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz

4.解壓到/usr/local/

tar -zxvf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz -C /usr/local

cd /usr/local/

mv mysql-5.6.40-linux-glibc2.12-x86_64/ mysql

5.mysql下面沒有data目錄則創(chuàng)建

mkdir /usr/local/mysql/data

6.修改屬主屬組

chown -R mysql.mysql /usr/local/mysql/

7.創(chuàng)建/etc/my.cnf文件

vim /etc/my.cnf

[mysqld]
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
character-set-server=utf8
log-error=/var/log/mysqld.log
pid-file=/tmp/mysqld.pid

[mysql]
socket=/usr/local/mysql/mysql.sock

[client]
socket=/usr/local/mysql/mysql.sock

8.初始化

/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --user=mysql

9.配置環(huán)境變量

vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH

10.復(fù)制啟動腳本 修改腳本 啟動

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

修改配置文件
vim /etc/init.d/mysqld

在46行 47行 補(bǔ)全路徑
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

執(zhí)行腳本啟動mysql
[root@localhost support-files]# /etc/init.d/mysqld start
Starting MySQL. SUCCESS!

11.將mysql添加到系統(tǒng)服務(wù)

先關(guān)閉服務(wù)
/etc/init.d/mysqld stop
vim /usr/lib/systemd/system/mysql.service

注意這里的路徑要跟你的安裝路徑一致 pid文件路徑可以通過 開啟mysql服務(wù)時 ps -ef | grep mysql來查看
PIDFile=/tmp/mysqld.pid
ExecStart=/usr/local/mysql/support-files/mysql.server start

[Unit]
Description=Mysql
After=syslog.target network.target remote-fs.target nss-lookup.target

[Service]
Type=forking
PIDFile=/tmp/mysqld.pid
ExecStart=/usr/local/mysql/support-files/mysql.server start
ExecReload=/bin/kill -s HUP $MAINPID
ExecStop=/bin/kill -s QUIT $MAINPID
PrivateTmp=false

[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemclt start mysql

12.測試，并修改root密碼

啟動mysql
/etc/init.d/mysqld start

執(zhí)行命令 默認(rèn)沒有密碼直接回車
mysql -uroot -p

修改密碼 先退出mysql
exit
第一次輸入密碼直接回車 因為沒有設(shè)置密碼 第二次輸入你想設(shè)置的密碼 第三次再次輸入密碼確認(rèn)
[root@localhost mysql]# mysqladmin -uroot -p password
Enter password: 
New password: 
Confirm new password: 
[root@localhost mysql]# 

13.遠(yuǎn)程登陸授權(quán)
指定網(wǎng)段內(nèi)192.168.70.*

先登錄mysql
mysql -uroot -p

grant all privileges on *.* to root@'192.168.70.%' identified by '123456';

flush privileges;

14.遠(yuǎn)程授權(quán)后可以再開一臺虛擬機(jī)進(jìn)行連接測試文章來源地址http://www.zghlxwxcb.cn/news/detail-651391.html

[root@localhost opt]# mysql -uroot -p -h192.168.70.24

到了這里，關(guān)于二進(jìn)制包安裝mysql的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！