linux下安装mysql——解压缩版
linux安装mysql，配置文件、数据文件自定义，同系统下多个mysql安装配置。
操作方法
- 01
shell> groupadd mysql 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 .
- 02
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 #不复制某个库
- 03
(启动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
- 04
无法启动或进入： 查看日志shell> tail -f /usr/local/mysql3309/logs/mysql3309.log