shell>useradd -r -g mysql mysql
shell>cd /usr/local
shell>tar zxvf mysql-5.5.32-linux2.6-x86_64.tar.gz
shell>mv mysql-5.5.32-linux2.6-x86_64 /usr/local/mysql3309
shell>cd /usr/local/mysql3309
shell>chown -R mysql .
shell>chgrp -R mysql .
2
shell>cat my3309.cnf
#/usr/local/mysql3309下新建my3309.cnf配置文件,内容复制my3308.cnf
shell>mkdir /usr/local/mysql3309/logs
shell>mkdir /usr/local/mysql3309/bin-log
shell>chown -R mysql.mysql .
shell>scripts/mysql_install_db --user=mysql --defaults-file=/usr/local/mysql3309/my3309.cnf
-----------------------my3309.cnf内容--------------------------------------
[client]
#password = your_password
port = 3307
socket = /tmp/mysql3307.sock
[mysql]
socket = /tmp/mysql3307.sock
# The MySQL server
[mysqld]
port = 3309
socket = /tmp/mysql3307.sock
basedir =/usr/local/mysql3307
datadir =/usr/local/mysql3307/data
skip-external-locking
skip-host-cache
skip-name-resolve
max_connection =1000
key_buffer_size = 600M
max_allowed_packet = 10M
table_open_cache = 1024
sort_buffer_size = 6M
read_buffer_size = 6M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 64
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-error=/usr/local/mysql3307/logs/mysqld3307.log
server-id = 1
log_slave_updates = 1
auto_increment_increment=2
auto_increment_offset=2
read-only
log_bin =/usr/local/mysql3307/binlog/mysql-bin.log
#log-bin-index= mysql-bin.index
max_binlog_size =1G
max_relay_log_size =1G
expire_logs_days = 30 #超过30天的binlog删除
replicate-do-db =test #只复制某个库
replicate-do-db =fab
replicate-do-db =fat
replicate-do-db =thca
replicate-do-db =fab_innodb
replicate-ignore-db=mysql #不复制某个库
3
(启动mysql)
shell>bin/mysqld_safe --defaults-file=/usr/local/mysql3309/my3309.cnf --user=mysql >/dev/null 2>&1 &
(进入mysql)
shell>bin/mysql --defaults-file=/usr/local/mysql3309/my3309.cnf
4
无法启动或进入:
查看日志shell>tail -f /usr/local/mysql3309/logs/mysql3309.log
END
注意事项
解压缩版的mysql可直接运行,执行时需指定my.cnf文件
注意添加--defaults-file=/usr/local/my3309.cnf命令
由于在my.cnf文件中指定了mysql.sock的位置,为了避免多个mysql同时读取/tmp/mysql.sock文件,在启动时指定读取的sock文件位置: --socket=/tmp/mysql3307.sock
http://dev.mysql.com/downloads/mysql/5.6.html#downloads这是mysql官网地址,你可以根据你的内核版本下载相应的msyql版本安装包,如:
MySQL-client-5.6.31-1.el7.x86_64.rpm
MySQL-server-5.6.31-1.el7.x86_64.rpm
下载好上述两个安装包后执行安装命令就可以了:
rpm -ivh MySQL-client-5.6.31-1.el7.x86_64.rpm
rpm -ivh MySQL-server-5.6.31-1.el7.x86_64.rpm
注意:安装之前要确认你的主机目前有没有默认安装的mysql版本,如果有,先删除就可以了。
你试着再终端输入:sudo /etc/init.d/mysql start要是你说的只是解压就运行的话,主要还得看你的安装目录,再在终端输入上面类似的命令,比如改下文件夹(/etc/init.d/),就是该成你在哪里解压的文件夹。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)