Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the installation process of MySQL5.6 under CentOS6.5". In the daily operation, I believe that many people have doubts about the installation process of MySQL5.6 under CentOS6.5. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "the installation process of MySQL5.6 under CentOS6.5". Next, please follow the editor to study!

1. Change to the / usr/local directory and upload the tar package of MySQL

[root@hadoop001 ~] # cd / usr/local

[root@hadoopnn001 local] # rz

two。 Check if it has been installed

[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. Decompression replication

[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. Create user groups and users

[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. Modify the user's execution permissions

[root@hadoop001 local] # usermod-u 514-g dba-G root-d / usr/local/mysql mysqladmin

6. Configure personal environment variables (copy environment variable configuration file to the home directory of the mysqladmin user)

[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, copy the following

(default: / 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

Note: modify the parameters of innodb_buffer_pool_size

7. Change the file attribution on the first installation

[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. First installation

[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 install again

[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 logfile. / ib_logfile101 size to 48 MB

2015-08-25 22:49:07 11713 [Note] InnoDB: Setting logfile. / ib_logfile1 size to 48 MB

2015-08-25 22:49:12 11713 [Note] InnoDB: Renaming logfile. / 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: 128rollback 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: 128rollback 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. Configure mysql services and deployment to start automatically

[root@hadoop001 ~] # cd / usr/local/mysql

# copy the service file to init.d and rename it to mysql

[root@hadoop001 mysql] # cp support-files/mysql.server / etc/rc.d/init.d/mysql

# Grant executable permissions

[root@hadoop001 mysql] # chmod + x / etc/rc.d/init.d/mysql

# deleting a service

[root@sht-sgmhadoopnn-01 mysql] # chkconfig-- del mysql

# add Services

[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 &

Uninstall first

[root@rzdatahadoop001 lib] # rpm-- nodeps-e mysql-libs-5.1.71-1.el6.x86_64

Change the authority

[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. Start the service

[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. Log in

[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)

At this point, the study on "the installation process of MySQL5.6 under CentOS6.5" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.