mysql安装

yum -y install  gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake

 

groupadd mysql

 

useradd -r -g mysql mysql

 

tar -zxvf mysql-5.6.16.tar.gz

 

cd mysql-5.6.16

 

cmake  .  （注意cmake与.中间是有一个空格）

 

make && make install

 

chown -R mysql.mysql /usr/local/mysql

 

cd /usr/local/mysql/scripts

 

./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

 

cd /usr/local/mysql/support-files

 

cp mysql.server /etc/rc.d/init.d/mysql

 

cp my-default.cnf /etc/my.cnf

 

chkconfig --add mysql

 

chkconfig mysql on

 

ln -s /usr/local/mysql/bin/mysql /usr/bin

 

cd /usr/local/mysql/

 

cp -a data /home/mysql/

 

mkdir /home/mysql/binlog

 

mkdir /home/mysql/logs

 

chown -R mysql.mysql /home/mysql/binlog

 

chown -R mysql.mysql /home/mysql/logs

 

service mysql restart;

 

mysql;

 

若提示：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

则执行下面语句：

ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

 

use mysql;

delete from user where User = '' or Host <> 'localhost';//请谨慎执行

update user set Host = '%', Password = PASSWORD('2B1B39E09A5B403A'); //修改密码

update user set Password = PASSWORD('root') where User = 'root' or host = 'locahost'; //修改指定用户密码

 

update user set host = ‘%’ //修改可以全部登录

flush privileges;

quit

 

备份/etc/my.cnf文件为my.conf.bak，

cp /etc/my.cnf  /etc/my.cnf.bak

 

vi /etc/my.cnf

将以下内容放入my.cnf文件并保存

[client]

port            = 3306

socket          = /var/lib/mysql/mysql.sock

 

[mysqld]

port            = 3306

socket          = /var/lib/mysql/mysql.sock

#skip-locking

back_log = 50

#skip-networking

max_connections = 3000

max_connect_errors = 10

table_open_cache = 2048

#external-locking

key_buffer_size = 32M

max_allowed_packet = 64M

binlog_cache_size = 1M

expire_logs_days  = 30

max_heap_table_size = 64M

read_buffer_size = 2M

read_rnd_buffer_size = 16M

sort_buffer_size = 8M

join_buffer_size = 8M

thread_cache_size = 8

thread_concurrency = 8

query_cache_size = 64M

query_cache_limit = 2M

ft_min_word_len = 4

#memlock

default-storage-engine = INNODB

thread_stack = 192K

transaction_isolation = REPEATABLE-READ

tmp_table_size = 64M

log-bin=/home/mysql/binlog/bin_log

binlog_format=mixed

expire_logs_days = 30

slow_query_log

long_query_time = 2

server-id = 1

 

bulk_insert_buffer_size = 64M

myisam_sort_buffer_size = 128M

myisam_max_sort_file_size = 10G

myisam_repair_threads = 1

myisam_recover

datadir = /home/mysql/data/

#skip-innodb

innodb_additional_mem_pool_size = 16M

innodb_buffer_pool_size = 2G

innodb_data_file_path = ibdata1:10M:autoextend

innodb_data_home_dir = /home/mysql/data

#/var/lib/mysql

innodb_log_group_home_dir = /home/mysql/data

#/var/lib/mysql

innodb_file_io_threads = 4

#innodb_force_recovery=1

innodb_thread_concurrency = 16

innodb_flush_log_at_trx_commit = 1

#innodb_fast_shutdown

innodb_log_buffer_size = 8M

innodb_log_file_size = 256M

innodb_log_files_in_group = 3

innodb_max_dirty_pages_pct = 90

#innodb_flush_method=O_DSYNC

innodb_lock_wait_timeout = 120

 

skip-name-resolve

 

wait_timeout = 2880000

interactive_timeout = 2880000

net_read_timeout = 300

net_write_timeout = 300

 

log-bin-trust-function-creators = 1

lower_case_table_names = 1

 

[mysqldump]

quick

max_allowed_packet = 64M

 

[mysql]

no-auto-rehash

default-character-set=utf8

 

[myisamchk]

key_buffer_size = 512M

sort_buffer_size = 512M

read_buffer = 8M

write_buffer = 8M

 

[mysqlhotcopy]

wait_timeout = 2880000

interactive_timeout = 2880000

 

[mysqld_safe]

open-files-limit = 8192

log-error=/home/mysql/logs/mysql_error.log

 

启动mysql

service mysql start;

 

#若启动失败，看看内存是否够用

free –m

#重启服务器

reboot

 

相关安装文件，见如下链接

http://pan.baidu.com/s/1jIwyIoQ