【MySQL】二進位分發安裝

標籤：初始化   family   str   end   編輯   系統   5.6   授權   span   

作業系統：Red Hat Enterprise Linux Server release 6.5

Mysql安裝包：mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz

 

1. Linux中建立mysql組和mysql使用者

[[email protected] ~]# groupadd -g 1000 mysql

[[email protected] ~]# useradd mysql -g mysql -p mysql

 

2. 上傳安裝包到/usr/local目錄下

  ---上傳過程略---

 

3. 解壓安裝包

[[email protected] local]# tar -zxvf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz

 

4. 把解壓後安裝包名稱改為‘mysql‘

[[email protected] local]# mv mysql-5.6.34-linux-glibc2.5-x86_64 mysql

 

5. 授權：解壓的檔案屬主屬組改為root:root，其中data改為mysql：mysql

[[email protected] ~]# cd /usr/local/mysql

[[email protected] mysql]# chown root:root *

[[email protected] mysql]# chown mysql:mysql data

[[email protected] mysql]# ll

total 68

drwxr-xr-x.  2 root  root   4096 Jan  9 22:26 bin

-rw-r--r--.  1 root  root  17987 Sep 30 19:41 COPYING

drwxr-xr-x.  3 mysql mysql  4096 Jan  9 22:26 data

drwxr-xr-x.  2 root  root   4096 Jan  9 22:26 docs

drwxr-xr-x.  3 root  root   4096 Jan  9 22:26 include

drwxr-xr-x.  3 root  root   4096 Jan  9 22:26 lib

drwxr-xr-x.  4 root  root   4096 Jan  9 22:26 man

drwxr-xr-x. 10 root  root   4096 Jan  9 22:26 mysql-test

-rw-r--r--.  1 root  root   2496 Sep 30 19:41 README

drwxr-xr-x.  2 root  root   4096 Jan  9 22:26 scripts

drwxr-xr-x. 28 root  root   4096 Jan  9 22:26 share

drwxr-xr-x.  4 root  root   4096 Jan  9 22:26 sql-bench

drwxr-xr-x.  2 root  root   4096 Jan  9 22:26 support-files

 

6. 初始化 建立授權表

[[email protected] ~]# cd /usr/local/mysql

[[email protected] mysql]# scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data

 

7. 編輯設定檔

[[email protected] ~]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

 

[[email protected] ~]# vi /etc/my.cnf

---修改其中的如下內容---

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

port = 3306

 

8. 映射mysql和mysqladmin目錄

 

[[email protected] ~]# cd /usr/local/bin

[[email protected] bin]# ln -fs /usr/local/mysql/bin/mysql mysql

[[email protected] bin]# ln -fs /usr/local/mysql/bin/mysqladmin mysqladmin

##標紅部分為MySQL的實際安裝目錄，根據實際目錄修改

 

9. 拷貝mysql.server啟動指令碼到init.d目錄下

 [[email protected] ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

 

10. 啟動MySQL Servier

[[email protected] bin]# service  mysql start

 

11. 修改root使用者的密碼

[[email protected] ~]# mysqladmin -uroot password

 

12. 串連MySQL Server

[[email protected] bin]# mysql -u root -p

 

The End!

2017-08-17

【MySQL】二進位分發安裝