CentOS6.5下MySQL5.6的安装进程
发布时间：2022-01-18 13:37:22 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要介绍CentOS6.5下MySQL5.6的安装过程，在日常操作中，相信很多人在CentOS6.5下MySQL5.6的安装过程问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答CentOS6.5下MySQL5.6的安装过程的疑惑有所帮助！接下来，请跟着小
|
这篇文章主要介绍“CentOS6.5下MySQL5.6的安装过程”，在日常操作中，相信很多人在CentOS6.5下MySQL5.6的安装过程问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”CentOS6.5下MySQL5.6的安装过程”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！ 1.切换到/usr/local目录下，上传MySQL的tar包 [root@hadoop001 ~]# cd /usr/local [root@hadoopnn001 local]# rz 2.检查是否安装过 [root@hadoop001 local]# ps -ef|grep mysqld root 2493 2423 0 19:48 pts/3 00:00:00 grep mysqld [root@hadoop0 01 local]# rpm -qa |grep -i mysql 3.解压复制 [root@hadoop001 local]# tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz [root@hadoopnn001 local]# mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql 4.创建用户组和用户 [root@hadoop001 local]# groupadd -g 101 dba [root@hadoop001 local]# useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin [root@hadoop001 local]# id mysqladmin uid=514(mysqladmin) gid=101(dba) groups=101(dba),0(root) [root@hadoop001 local]# 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. 5.修改用户的执行权限 [root@hadoop001 local]# usermod -u 514 -g dba -G root -d /usr/local/mysql mysqladmin 6.配置个人环境变量（copy 环境变量配置文件至mysqladmin用户的home目录中） [root@hadoop001 local]# cp /etc/skel/.* /usr/local/mysql cp: omitting directory `/etc/skel/.' cp: omitting directory `/etc/skel/..' cp: omitting directory `/etc/skel/.mozilla' 7.vi /etc/my.cnf ,把下列内容复制进去 (默认： /etc/my.cnf->/etc/mysql/my.cnf->SYSCONFDIR/my.cnf->$MYSQL_HOME/my.cnf-> --defaults-extra-file->~/my.cnf ) [root@hadoop001 ~]# vi /etc/my.cnf [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 = 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 注意：修改innodb_buffer_pool_size的参数 7.第一次安装更改文件归属 [root@hadoop001 local]# chown mysqladmin:dba /etc/my.cnf [root@hadoop001 local]# chmod 640 /etc/my.cnf [root@hadoop001 etc]# ll my.cnf -rw-r----- 1 mysqladmin dba 2201 Aug 25 23:09 my.cnf [root@hadoop001 local]# chown -R mysqladmin:dba /usr/local/mysql [root@hadoop001 local]# chmod -R 755 /usr/local/mysql [root@hadoop001 local]# su - mysqladmin [mysqladmin@hadoop001 ~]$ pwd /usr/local/mysql [mysqladmin@hadoop001 ~]$ mkdir arch 8.第一次安装 [mysqladmin@hadoop001 ~]$ scripts/mysql_install_db --user=mysqladmin --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory [root@hadoop001 local]# cat /proc/version Linux version 2.6.18-164.11.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-46)) #1 SMP Wed Jan 20 07:32:21 EST 2010 [root@hadoop001 local]# rpm -qa |grep gcc libgcc-4.1.2-46.el5_4.2 libgcc-4.1.2-46.el5_4.2 [root@hadoop001 local]# yum -y install libaio 9再次安装 [mysqladmin@hadoop001 ~]$ scripts/mysql_install_db --user=mysqladmin --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data Installing MySQL system tables...2015-08-25 22:49:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-08-25 22:49:02 11713 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-08-25 22:49:02 11713 [Note] InnoDB: The InnoDB memory heap is disabled 2015-08-25 22:49:02 11713 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-08-25 22:49:02 11713 [Note] InnoDB: Memory barrier is not used 2015-08-25 22:49:02 11713 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-08-25 22:49:02 11713 [Note] InnoDB: Using Linux native AIO 2015-08-25 22:49:02 11713 [Note] InnoDB: Using CPU crc32 instructions 2015-08-25 22:49:02 11713 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-08-25 22:49:02 11713 [Note] InnoDB: Completed initialization of buffer pool 2015-08-25 22:49:02 11713 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2015-08-25 22:49:02 11713 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2015-08-25 22:49:02 11713 [Note] InnoDB: Database physically writes the file full: wait... 2015-08-25 22:49:03 11713 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2015-08-25 22:49:07 11713 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2015-08-25 22:49:12 11713 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2015-08-25 22:49:12 11713 [Warning] InnoDB: New log files created, LSN=45781 2015-08-25 22:49:12 11713 [Note] InnoDB: Doublewrite buffer not found: creating new 2015-08-25 22:49:12 11713 [Note] InnoDB: Doublewrite buffer created 2015-08-25 22:49:12 11713 [Note] InnoDB: 128 rollback segment(s) are active. 2015-08-25 22:49:12 11713 [Warning] InnoDB: Creating foreign key constraint system tables. 2015-08-25 22:49:12 11713 [Note] InnoDB: Foreign key constraint system tables created 2015-08-25 22:49:12 11713 [Note] InnoDB: Creating tablespace and datafile system tables. 2015-08-25 22:49:12 11713 [Note] InnoDB: Tablespace and datafile system tables created. 2015-08-25 22:49:12 11713 [Note] InnoDB: Waiting for purge to start 2015-08-25 22:49:12 11713 [Note] InnoDB: 5.6.23 started; log sequence number 0 2015-08-25 22:49:13 11713 [Note] Binlog end 2015-08-25 22:49:13 11713 [Note] InnoDB: FTS optimize thread exiting. 2015-08-25 22:49:13 11713 [Note] InnoDB: Starting shutdown... 2015-08-25 22:49:15 11713 [Note] InnoDB: Shutdown completed; log sequence number 1625977 OK Filling help tables...2015-08-25 22:49:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-08-25 22:49:15 11735 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-08-25 22:49:15 11735 [Note] InnoDB: The InnoDB memory heap is disabled 2015-08-25 22:49:15 11735 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-08-25 22:49:15 11735 [Note] InnoDB: Memory barrier is not used 2015-08-25 22:49:15 11735 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-08-25 22:49:15 11735 [Note] InnoDB: Using Linux native AIO 2015-08-25 22:49:15 11735 [Note] InnoDB: Using CPU crc32 instructions 2015-08-25 22:49:15 11735 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-08-25 22:49:15 11735 [Note] InnoDB: Completed initialization of buffer pool 2015-08-25 22:49:15 11735 [Note] InnoDB: Highest supported file format is Barracuda. 2015-08-25 22:49:15 11735 [Note] InnoDB: 128 rollback segment(s) are active. 2015-08-25 22:49:15 11735 [Note] InnoDB: Waiting for purge to start 2015-08-25 22:49:15 11735 [Note] InnoDB: 5.6.23 started; log sequence number 1625977 2015-08-25 22:49:15 11735 [Note] Binlog end 2015-08-25 22:49:15 11735 [Note] InnoDB: FTS optimize thread exiting. 2015-08-25 22:49:15 11735 [Note] InnoDB: Starting shutdown... 2015-08-25 22:49:17 11735 [Note] InnoDB: Shutdown completed; log sequence number 1625987 OK 10.配置mysql服务和部署自动启动 [root@hadoop001 ~]# cd /usr/local/mysql #将服务文件拷贝到init.d下，并重命名为mysql [root@hadoop001 mysql]# cp support-files/mysql.server /etc/rc.d/init.d/mysql #赋予可执行权限 [root@hadoop001 mysql]# chmod +x /etc/rc.d/init.d/mysql #删除服务 [root@sht-sgmhadoopnn-01 mysql]# chkconfig --del mysql #添加服务 [root@0hadoop001 mysql]# chkconfig --add mysql [root@hadoop001 mysql]# chkconfig --level 345 mysql on 11.Start mysql and to view process and listening [root@hadoop001 mysql]# su - mysqladmin [mysqladmin@hadoop001 ~]$ pwd /usr/local/mysql [mysqladmin@hadoop001 ~]$ rm -rf my.cnf [mysqladmin@sht-sgmhadoopnn-01 ~]$ bin/mysqld_safe & 先卸载 [root@rzdatahadoop001 lib]# rpm --nodeps -e mysql-libs-5.1.71-1.el6.x86_64 改权限 [root@rzdatahadoop001 mysql]# chmod -R 757 /var/log [mysqladmin@sht-sgmhadoopnn-01 ~]$ 150825 22:53:38 mysqld_safe Logging to '/usr/local/mysql/data/hostname.err'. 150825 22:53:38 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 150825 22:53:39 mysqld_safe mysqld from pid file /usr/local/mysql/data/hostname.pid ended 14. 启动服务 [mysqladmin@hadoop001 ~]$ ps -ef|grep mysqld 514 6247 6219 0 17:30 pts/1 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe 514 6902 6247 2 17:30 pts/1 00:00:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/usr/local/mysql/data/hostname.err --pid-file=/usr/local/mysql/data/hostname.pid --socket=/usr/local/mysql/data/mysql.sock --port=3306 514 6927 6219 0 17:31 pts/1 00:00:00 grep mysqld [mysqladmin@hadoop001 ~]$ netstat -tulnp | grep mysql (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp 0 0 :::3306 :::* LISTEN 11541/mysqld [root@sht-sgmhadoopnn-01 local]# service mysql status MySQL running (21507) [ OK ] 15.登录 [mysqladmin@sht-sgmhadoopnn-01 ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.6.23-log MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec) 到此，关于“CentOS6.5下MySQL5.6的安装过程”的学习就结束了，希望能够解决大家的疑惑。 （编辑：通辽站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
