环境: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