环境:centos6.5 mysql-5.6.17.tar.gz
wgethttp://cdn.mysql.com/downloads/mysql-5.6/mysql-5.6.17.tar.gz
yum install -y gcc gcc-c++ gcc-c++.x86_64 bison.x86_64 libaio.x86_64 cmake.x86_64 ncurses-devel.x86_64
后面根据官方文档: mysql 5.6 manual 2.8.2 installing mysql using a standard source distribution
shell> groupadd mysqlshell> useradd -r -g mysql mysql
shell> tar zxvf mysql-version.tar.gzshell> cd mysql-versionshell> cmake .shell> makeshell> make install
shell> cd /usr/local/mysqlshell> chown -r mysql .shell> chgrp -r mysql .shell> scripts/mysql_install_db --user=mysqlshell> chown -r root .shell> chown -r mysql datashell> bin/mysqld_safe --user=mysql &
安装完了 ,启动的时候就报错:
/usr/local/mysql/bin/mysqld: can't create/write to file '/var/run/mysqld/mysqld.pid' (errcode: 2 - no such file or directory)
cd /var/run/
mkdir mysqld
chown -r mysql mysqld
chgrp -r mysql mysqld
再重新启动:
[error] fatal error: can't open and lock privilege tables: table 'mysql.user' doesn't exist
修改:/usr/local/mysql/my.cnf
datadir =/usr/local/mysql/data
重启电脑
mysql.server start 启动成功
./bin/mysql
error 2002 (hy000): can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
执行这个命令后,成功运行mysql
