CentOS二进制安装MySQL5.6

mysql二进制安装

mysql日志：/usr/local/mysql/data/$(主机名).err

 

关系型数据库：Oracle、MySQL、PostgreSQL

非关系型数据库（NOSQL）：HBase、Redis

图形数据库：Titan

时序数据库：influxdb

安装MySQL步骤

1、上传安装包至/uer/local目录下，执行解压（使用root用户）

 

  cd /usr/local/
 tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
 mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql

 

2、创建mysql管理用户组与用户（使用root用户）

   groupadd -g 101 dba
   useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin
   验证：id mysqladmin

注意：

## if user mysqladmin is existing,please execute the following command of usermod.
#[root@sht-sgmhadoopnn-01 local]# usermod -u 514 -g dba -G root -d /usr/local/mysql mysqladmin

3、修改mysqladmin用户密码（使用root用户）

  passwd mysqladmin
   提示：
  Changing password for user mysqladmin.
 New UNIX password: 
 BAD PASSWORD: it is too simplistic/systematic
 Retype new UNIX password: 
 passwd: all authentication tokens updated successfully.

4、copy 环境变量配置文件至mysqladmin用户的home目录

cp /etc/skel/.* /usr/local/mysql

提示信息如下：  
  cp: omitting directory `/etc/skel/.'
  cp: omitting directory `/etc/skel/..'
  cp: omitting directory `/etc/skel/.mozilla'

5、修改/etc/my.cnf文件，并删除原文件内容，将以下内容填写到my.cnf文件中--使用root用户

[client]
port            = 3306
socket          = /usr/local/mysql/data/mysql.sock
 
[mysqld]
port            = 3306
socket          = /usr/local/mysql/data/mysql.sock


skip-external-locking
key_buffer_size = 256M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
query_cache_size= 32M
max_allowed_packet = 16M
myisam_sort_buffer_size=128M
tmp_table_size=32M


table_open_cache = 512
thread_cache_size = 8
wait_timeout = 86400
interactive_timeout = 86400
max_connections = 600


# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 32


#isolation level and default engine 
default-storage-engine = INNODB
transaction-isolation = READ-COMMITTED


server-id  = 1
basedir     = /usr/local/mysql
datadir     = /usr/local/mysql/data
pid-file     = /usr/local/mysql/data/hostname.pid


#open performance schema
log-warnings
sysdate-is-now


binlog_format = MIXED
log_bin_trust_function_creators=1
log-error  = /usr/local/mysql/data/hostname.err
log-bin=/usr/local/mysql/arch/mysql-bin
#other logs
#general_log =1
#general_log_file  = /usr/local/mysql/data/general_log.err
#slow_query_log=1
#slow_query_log_file=/usr/local/mysql/data/slow_log.err


#for replication slave
#log-slave-updates 
#sync_binlog = 1


#for innodb options 
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:500M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/arch
innodb_log_files_in_group = 2
innodb_log_file_size = 200M


innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 50M
innodb_log_buffer_size = 16M


innodb_lock_wait_timeout = 100
#innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 1
innodb_locks_unsafe_for_binlog=1


#innodb io features: add for mysql5.5.8
performance_schema
innodb_read_io_threads=4
innodb-write-io-threads=4
innodb-io-capacity=200
#purge threads change default(0) to 1 for purge
innodb_purge_threads=1
innodb_use_native_aio=on


#case-sensitive file names and separate tablespace
innodb_file_per_table = 1
lower_case_table_names=1


[mysqldump]
quick
max_allowed_packet = 16M


[mysql]
no-auto-rehash


[mysqlhotcopy]
interactive-timeout


[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

 

6、修改/etc/my.cnf文件用户组与用户、权限（使用root用户）

 cd /usr/local
 chown  mysqladmin:dba /etc/my.cnf
 chmod  640 /etc/my.cnf
   验证：
     ll my.cnf
     -rw-r----- 1 mysqladmin dba 2201 Dec 19 11:19:40 my.cnf

 

7、修改mysql安装文件用户组与用户、权限（使用root用户）

   chown -R mysqladmin:dba /usr/local/mysql
   chmod -R 755 /usr/local/mysql
   su - mysqladmin

8、创建arch目录--使用mysqladmin用户
   cd /usr/local/mysql
   mkdir arch

9、检查gcc、libaio、perl以及perl-devel包是否安装
   rpm -qa|grep gcc libaio perl perl-devel
   如未安装，则切换到root用户，使用yum方式安装：

                  yum -y install libaio

                  yum -y install gcc

                  yum -y install perl

10、二进制安装

   su - mysqladmin
   scripts/mysql_install_db  --user=mysqladmin --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
 

11、启动mysql--使用mysqladmin用户
    su - mysqladmin
    cd /usr/local/mysql
    rm -rf my.cnf
    bin/mysqld_safe &
    验证是否启动：ps -ef|grep mysqld  或者   netstat -tulnp | grep mysql

 

12、登录mysql，并修改mysql中的root密码内容--使用mysqladmin用户
   mysql  
   mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
注：如mysql数据库名称，则退出(exit)使用：mysql -uroot -p，提示输入密码时直接回车
   mysql> use mysql
   mysql> update user set password=password('123456') where user='root';
   mysql> select host,user,password from user;
   mysql> delete from user where user='';
   mysql> select host,user,password from user;
   mysql> flush privileges;

 

重新安装：

rm -rf data
rm -rf arch/*
scripts/mysql_install_db  --user=mysqladmin --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 

如果没有报错强行退出会报：

swap的错误
改正：
    rm -f .my.cnf.swaf
之后重新编译