# 二進位包安裝mysql ## 準備 1.先查看系統中是否已存在mysql，存在將其卸載 ``` rpm -qa mysql rpm -qa mariadb yum remove xxx -y ``` 2.環境清理 清空PATH有關的mysql 註釋掉之前的$PATH 沒有就跳過這步 ``` #e ...
二進位包安裝mysql
準備
1.先查看系統中是否已存在mysql，存在將其卸載
rpm -qa mysql
rpm -qa mariadb
yum remove xxx -y
2.環境清理 清空PATH有關的mysql 註釋掉之前的$PATH 沒有就跳過這步
#export PATH=/application/mysql/bin:$PATH
3.安裝所需的基礎依賴
yum install ncurses-devel libaio-devel gcc make cmake -y
4.創建用戶
useradd -s /sbin/nologin -M mysql
實驗步驟
1.下載二進位安裝包
自行選擇一個下載目錄 這裡我下載到/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目錄則創建
mkdir /usr/local/mysql/data
6.修改屬主屬組
chown -R mysql.mysql /usr/local/mysql/
7.創建/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.配置環境變數
vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH
10.複製啟動腳本 修改腳本 啟動
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
修改配置文件
vim /etc/init.d/mysqld
在46行 47行 補全路徑
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
執行腳本啟動mysql
[root@localhost support-files]# /etc/init.d/mysqld start
Starting MySQL. SUCCESS!
11.將mysql添加到系統服務
先關閉服務
/etc/init.d/mysqld stop
vim /usr/lib/systemd/system/mysql.service
註意這裡的路徑要跟你的安裝路徑一致 pid文件路徑可以通過 開啟mysql服務時 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
執行命令 預設沒有密碼直接回車
mysql -uroot -p
修改密碼 先退出mysql
exit
第一次輸入密碼直接回車 因為沒有設置密碼 第二次輸入你想設置的密碼 第三次再次輸入密碼確認
[root@localhost mysql]# mysqladmin -uroot -p password
Enter password:
New password:
Confirm new password:
[root@localhost mysql]#
13.遠程登陸授權
指定網段內192.168.70.*
先登錄mysql
mysql -uroot -p
grant all privileges on *.* to root@'192.168.70.%' identified by '123456';
flush privileges;
14.遠程授權後可以再開一臺虛擬機進行連接測試
[root@localhost opt]# mysql -uroot -p -h192.168.70.24
