说明:本文安装只是针对5.7.6之前的方法。5.7.6之后有点变化,具体看官方文档吧,没有多少难度。
1、create a mysql user and group
groupadd mysql
useradd -r -g mysql mysql
passwd mysql
2、obtain and unpack the distribution
cd /usr/local
tar -zxvf /tmp/mysql-advanced-5.6.18-linux-glibc2.5-x86_64.tar.gz
ln -s mysql-advanced-5.6.18-linux-glibc2.5-x86_64 mysql
3、mysql_install_db
cd /usr/local/mysql/scripts
./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
注意:等号后不能有空格(他的安装脚本还不是很智能)
4、修改mysql权限
cd /usr/local
chown -R mysql:mysql mysql/
chown -R mysql:mysql mysql
5、修改linux的limit.conf
注意:下面的配置不一定和示例中一样,根据需要可以调整
vi /etc/security/limits.conf
* soft nproc 65536
* hard nproc 65536
* soft nofile 1048576
* soft nofile 1048576
6、auto start
cd mysql/support-files/
cp mysql.server /etc/init.d/mysql
7、modify /etc/my.cnf
注意:这里的许多参数可能需要更具自己情况调整
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
user=mysql
symbolic-links=0
[mysqld_safe]
log-error=/usr/local/mysql/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid
8、start mysql
$vi .base_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin
export MYSQL_PS1="(\u@\h:\p) [\d]>"
$cd .;/usr/local/mysql/bin/mysqld_safe &