二进制安装:mysql-5.6.28 (可多端口多mysql安装)

回复 收藏
二进制安装:mysql-5.6.28   (可多端口多mysql安装)

系统:Centos 6.7 64位
cd /usr/local/src/
wget http://219.239.26.10/files/41740 ... bc2.5-x86_64.tar.gz
tar zxvf mysql-5.6.28-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.6.28-linux-glibc2.5-x86_64 /mnt/mysql3306
cd /mnt/mysql3306
useradd -s /sbin/nologin mysql  //创建mysql运行用户

vim my.cnf   //输入以下内容   //提示:mysql5.5起,my.cnf配置文件参数有异,建议改的时候查资料确认下
[client]
port = 3306
socket = /mnt/mysql3306/mysql3306.sock
[mysqld]
character_set_server = utf8
basedir = /mnt/mysql3306
datadir = /mnt/mysql3306/data
port = 3306
socket = /mnt/mysql3306/mysql3306.sock
skip-name-resolve
max-connections = 300
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
general_log = 1
general_log_file = /mnt/mysql3306/log/general.log
event_scheduler = 1
[mysqld_safe]
log-error = /mnt/mysql3306/log/error.log
pid-file = /mnt/mysql3306/data/mysql.pid

mkdir log
touch /mnt/mysql3306/log/general.log
touch /mnt/mysql3306/log/error.log

vim support-files/mysql.server  //修改如下
basedir=/mnt/mysql3306
datadir=/mnt/mysql3306/data
conf=$basedir/my.cnf

cp -rf support-files/mysql.server /etc/init.d/mysql3306
chkconfig --add mysql3306
chkconfig mysql3306 on
chown -R mysql.mysql /mnt/mysql3306
scripts/mysql_install_db --user=mysql --basedir=/mnt/mysql3306 --datadir=/mnt/mysql3306/data      
//检查过程中有两个OK和 echo $? =0 则初始化成功

service mysql3306 start
/mnt/mysql3306/bin/mysql -uroot -S /mnt/mysql3306/mysql3306.sock
//登陆成功即可

此过程我遇到过的问题:

linux libaio.so.1: cannot open shared object file: No such file or directory
缺少安装包libaio和libaio-devel
yum -y install libaio*  自动安装这两个包

error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file or directory
用yum查询一下依赖:yum whatprovides libstdc++.so.6   是否缺少
yum -y install libstdc++-4.4.7-16.el6.i686



2016-01-05 22:34 举报
已邀请:
0
mv mysql-5.6.28-linux-glibc2.5-x86_64 /mnt/mysql3306  //程序文件放在mnt不规范
useradd -s /sbin/nologin mysql  //创建mysql运行用户,规范化用上 - M选项(‘-M’ 不建立家目录)
0
庚庚 发表于 2016-4-7 11:12
mv mysql-5.6.28-linux-glibc2.5-x86_64 /mnt/mysql3306  //程序文件放在mnt不规范
useradd -s /sbin/nolo ...

受教了,我这边环境都是阿里云环境,所以一直在mnt挂着盘里面操作的,这次长知识了;  建立用户确实-M不错,长知识了

回复帖子,请先登录注册

退出全屏模式 全屏模式 回复
评分
可选评分理由: