環境:CentOS6.5
數據庫版本:5.6.40
1.下載mysql的安裝包
cd /home
mkdir mysql
wget --no-check-certificate https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz
2.放到對應位置,解壓
mv mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz /usr/local
tar -zxvf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz
3.修改mysql數據目錄
vim /etc/my.cnf
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/data/mysql.sock
4.添加系統mysql組和mysql用戶
groupadd mysql
useradd -r -g mysql mysql
5.修改目錄權限
cd mysql
chown -R mysql:mysql ./
6.安裝依賴庫
yum install cmake gcc-c++ ncurses-devel perl-Data-Dumper boost boost-doc boost-devel numactl
8.初始化數據庫
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
9,修改權限
chown -R root:root .
chown -R mysql:mysql data
10.添加啟動服務
cp support-files/mysql.server /etc/init.d/mysql
11.啟動mysql
service mysql start
12.將mysql.sock復制到指定位置否則無法打開mysqld
ln -s /usr/local/mysql/data/mysql.sock /tmp/mysql.sock
14.設置root用戶密碼
./bin/mysqladmin -u root password '12345'
15.連接數據庫
./bin/mysql -uroot -p12345