CentOS6.5-64位安装二进制版的MySQL

1. 使用rz上传下载好的mysql

   rz

2. 检查是否已经安装MySQL

   ps -ef | grep mysql
   rpm -qa | grep mysql

   
3. 系统一般会自带一个libs的包，为了避免影响，直接删除掉即可（中间可能会有插件包安装提示，输入y，同意安装即可，删除完最好再执行以下第2步的命令检查一下）

   yum remove mysql-libs-5.1.71-1.el6.x86_64

   
   *出现上述信息即删除完成
4. 解压上传好的MySQL

   tar -zxvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz

   
   
5. 将解压好的MySQL移动至指定目录

   mv mysql-5.6.23-linux-glibc2.5-x86_64 /usr/local/src/mysql

   
   
   mv mysql-5.6.23-linux-glibc2.5-x86_64 /usr/local/src/mysql
6. 创建用户和用户组（依次执行下面三条命令）

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

   如果用户mysqladmin已存在，请执行下面的命令

   usermod -u 514 -g dba -G root -d /usr/local/mysql mysqladmin #

   
   
7. 设置用户mysqladmin的密码（输入密码时，无任何显示，直接输入然后回车即可）

   passwd mysqladmin

   
   
8. 拷贝环境变量配置文件至mysqladmin用户的home目录中,为了以下步骤配置个人环境变量

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

   
   
   
9. 创建/etc/my.cnf(640) 文件

   vi /etc/my.cnf

   将一下内容拷贝进去（注意以下配置中有关于安装路径的问题，请根据自己实际的安装路径做修改）

   [client]
   port            = 3306
   socket          = /usr/local/src/mysql/data/mysql.sock
    
   [mysqld]
   port            = 3306
   socket          = /usr/local/src/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/src/mysql
   datadir     = /usr/local/src/mysql/data
   pid-file     = /usr/local/src/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/src/mysql/data/hostname.err
   log-bin=/usr/local/src/mysql/arch/mysql-bin
   #other logs
   #general_log =1
   #general_log_file  = /usr/local/src/mysql/data/general_log.err
   #slow_query_log=1
   #slow_query_log_file=/usr/local/src/mysql/data/slow_log.err
   
   #for replication slave
   #log-slave-updates 
   #sync_binlog = 1
   
   #for innodb options 
   innodb_data_home_dir = /usr/local/src/mysql/data/
   innodb_data_file_path = ibdata1:500M:autoextend
   innodb_log_group_home_dir = /usr/local/src/mysql/arch
   innodb_log_files_in_group = 2
   innodb_log_file_size = 200M
   
   innodb_buffer_pool_size = 2048M
   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

   
   
   
   
10. 修改权限，依次执行下面的命令，并查看权限修改是否成功

    chown  mysqladmin:dba /etc/my.cnf
    chmod  640 /etc/my.cnf
    ll /etc/my.cnfchown
    chown -R mysqladmin:dba /usr/local/src/mysql
    chmod -R 755 /usr/local/src/mysql

    
    
11. 切换到mysqladmin用户，查看家目录是否为/usr/local/src/mysql，并创建arch文件夹

    su - mysqladmin
    pwd
    mkdir arch

    
    
12. 第一次安装

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

13. 如果出现下图所示内容说明安装成功
    
    
14. 设置mysql开机自启（使用的是root用户）
15. 将服务文件拷贝到init.d下，并重命名为mysql

    cp /usr/local/src/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql

    
    
    
16. 赋予可执行权限

    chmod +x /etc/rc.d/init.d/mysql

    
    
    
17. 删除服务

    chkconfig --del mysql

    
    
    
18. 添加服务

    chkconfig --add mysql
    chkconfig --level 345 mysql on

    
    
19. 切换用户

    su - mysqladmin

    
    
20. 删除my.cnf文件

    rm -rf my.cnf

    
    
21. 启动（打印日之后，记得按一下回车让mysql服务后台运行）

    bin/mysqld_safe & 

    
    
22. 登录msyql

    

    

    至此安装完成