Centos6.6安装mysql记录

Mysql版本：mysql-5.6.34

二、安装操作：

1、卸载旧版本：

rpm -qa |<span style="color: #000000">grep mysql
mysql</span>-server-5.1.73-8<span style="color: #000000">.el6_8.x86_64
mysql</span>-libs-5.1.73-8<span style="color: #000000">.el6_8.x86_64 
mysql</span>-5.1.73-8<span style="color: #000000">.el6_8.x86_64
删除</span>/etc/<span style="color: #000000">my.cnf:
rm </span>-f /etc/<span style="color: #000000">my.cnf
rpm </span>-e mysql-libs-5.1.73-8.el6_8.x86_64 mysql-5.1.73-8.el6_8.x86_64  --nodeps     <span style="color: #008000">#</span><span style="color: #008000">强制删除<br><br>注：在CentOS 6.4版操作系统最小安装完成后，默认会在/etc目录下存在一个my.cnf，需要将此文件更名为其他的名字，如：/etc/my.cnf.bak，否则，该文件会干扰源码安装的MySQL的正确配置，造成无法启动。<br>在使用"yum update"更新系统后，需要检查下/etc目录下是否会多出一个my.cnf，如果多出，将它重命名成别的。否则，MySQL将使用这个配置文件启动，可能造成无法正常启动等问题。</span>

 2、安装依赖包：

yum -y install make gcc-c++ cmake bison-devel ncurses-<span style="color: #000000">devel
groupadd mysql    </span><span style="color: #008000">#</span><span style="color: #008000">有用户的话删除就行  userdel mysql</span>
useradd -g mysql mysql -M -s /sbin/nologin

3、下载MySQL，源码编译安装：

cd /usr/local/<span style="color: #000000">src
下载安装包：
百度云盘链接：http:</span>//pan.baidu.com/s/<span style="color: #000000">1hs8awRU    密码：ly4d
tar </span>-zxvf mysql-5.6.34<span style="color: #000000">.tar.gz
cd mysql</span>-5.6.34/<span style="color: #000000">
cmake </span>-DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=<span style="color: #000000">utf8_general_ci
make </span>&& make install

4、配置MySQL：

修改/usr/local/<span style="color: #000000">mysql权限
mkdir </span>-p /data/mysql/<span style="color: #000000">data
chown </span>-R mysql:mysql /usr/local/<span style="color: #000000">mysql
chown </span>-R mysql:mysql /data/mysql/<span style="color: #000000">data
 
执行初始化配置脚本，创建系统自带的数据库和表
cd </span>/usr/local/<span style="color: #000000">mysql
.</span>/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql/data --user=mysql <span style="color: #008000">#</span><span style="color: #008000">如果后续不小心删除了这个数据目录或这个目录下的文件被误操作删除了，可以利用这个命令重新初始化。</span>
cp support-files/mysql.server /etc/init.d/<span style="color: #000000">mysql
chkconfig mysql on
service mysql start   </span>//启动前，要先配置my.cnf文件（如下）， 并确保/data/mysql/data和/usr/local/mysql的mysql权限

<span style="color: #000000">[client]
port </span>= 3306<span style="color: #000000">
socket </span>= /usr/local/mysql/var/<span style="color: #000000">mysql.sock
 
[mysqld]
port </span>= 3306<span style="color: #000000">
socket </span>= /usr/local/mysql/var/<span style="color: #000000">mysql.sock
 
basedir </span>= /usr/local/mysql/<span style="color: #000000">
datadir </span>= /data/mysql/<span style="color: #000000">data
pid</span>-file = /data/mysql/data/<span style="color: #000000">mysql.pid
user </span>=<span style="color: #000000"> mysql
bind</span>-address = 0.0.0.0<span style="color: #000000">
server</span>-id = 1<span style="color: #000000">
sync_binlog</span>=1<span style="color: #000000">
log_bin </span>= mysql-<span style="color: #000000">bin
 
skip</span>-name-<span style="color: #000000">resolve
 
back_log </span>= 600<span style="color: #000000">
 
max_connections </span>= 3000<span style="color: #000000">
max_connect_errors </span>= 3000<span style="color: #000000">
 
table_open_cache </span>= 512<span style="color: #000000">
max_allowed_packet </span>=<span style="color: #000000"> 16M
binlog_cache_size </span>=<span style="color: #000000"> 16M
max_heap_table_size </span>=<span style="color: #000000"> 16M
tmp_table_size </span>=<span style="color: #000000"> 256M
 
read_buffer_size </span>=<span style="color: #000000"> 1024M
read_rnd_buffer_size </span>=<span style="color: #000000"> 1024M
sort_buffer_size </span>=<span style="color: #000000"> 1024M
join_buffer_size </span>=<span style="color: #000000"> 1024M
key_buffer_size </span>=<span style="color: #000000"> 8192M
 
thread_cache_size </span>= 8<span style="color: #000000">
 
query_cache_size </span>=<span style="color: #000000"> 512M
query_cache_limit </span>=<span style="color: #000000"> 1024M
 
ft_min_word_len </span>= 4<span style="color: #000000">
 
binlog_format </span>=<span style="color: #000000"> mixed
expire_logs_days </span>= 30<span style="color: #000000">
 
log_error </span>= /data/mysql/data/mysql-<span style="color: #000000">error.log
slow_query_log </span>= 1<span style="color: #000000">
long_query_time </span>= 1<span style="color: #000000">
slow_query_log_file </span>= /data/mysql/data/mysql-<span style="color: #000000">slow.log
 
performance_schema </span>=<span style="color: #000000"> 0
explicit_defaults_for_timestamp
 
skip</span>-external-<span style="color: #000000">locking
 
default_storage_engine </span>=<span style="color: #000000"> InnoDB
innodb_file_per_table </span>= 1<span style="color: #000000">
innodb_open_files </span>= 500<span style="color: #000000">
innodb_buffer_pool_size </span>=<span style="color: #000000"> 1024M
innodb_write_io_threads </span>= 1000<span style="color: #000000">
innodb_read_io_threads </span>= 1000<span style="color: #000000">
innodb_thread_concurrency </span>= 8<span style="color: #000000">
innodb_purge_threads </span>= 1<span style="color: #000000">
innodb_flush_log_at_trx_commit </span>= 2<span style="color: #000000">
innodb_log_buffer_size </span>=<span style="color: #000000"> 4M
innodb_log_file_size </span>=<span style="color: #000000"> 32M
innodb_log_files_in_group </span>= 3<span style="color: #000000">
innodb_max_dirty_pages_pct </span>= 90<span style="color: #000000">
innodb_lock_wait_timeout </span>= 120<span style="color: #000000">
 
bulk_insert_buffer_size </span>=<span style="color: #000000"> 8M
myisam_sort_buffer_size </span>=<span style="color: #000000"> 8M
myisam_max_sort_file_size </span>=<span style="color: #000000"> 10G
myisam_repair_threads </span>= 1<span style="color: #000000">
 
interactive_timeout </span>= 28800<span style="color: #000000">
wait_timeout </span>= 28800<span style="color: #000000">
 
[mysqldump]
quick
max_allowed_packet </span>=<span style="color: #000000"> 16M
 
[myisamchk]
key_buffer_size </span>=<span style="color: #000000"> 8M
sort_buffer_size </span>=<span style="color: #000000"> 8M
read_buffer </span>=<span style="color: #000000"> 4M
write_buffer </span>=<span style="color: #000000"> 4M
 
sql_mode</span>=<span style="color: #000000">NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
port </span>= 3306

启动报错的话：

[root@localhost mysql]<span style="color: #008000">#</span><span style="color: #008000"> ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (111)</span>
登录报以上错误的话，删除/var/lib/mysql/<span style="color: #000000">mysql.sock这个文件：
rm </span>-f /var/lib/mysql/<span style="color: #000000">mysql.sock
ln </span>-s /usr/local/mysql/var/mysql.sock /var/lib/mysql/mysql.sock

Centos6.6安装mysql记录

标签：其他   roo   binlog   sql_mod   rip   pad   sql   kconfig   源码编译安装