Shulou(Shulou.com)06/01 Report--

CentOS6.5 binaries install MySQL5.6.39

Preparatory work

Lmysql-5.6.39-linux-glibc2.12-x86_64.tar.gz preparation for MySQ binary installation (download on official website)

Check whether MySQL has been installed and uninstall it

# check whether MySQL has been installed

[root@csxf ~] # rpm-qa | grep mysql

# Delete all MySQL

[root@csxf ~] # yum-y remove mysql*

2. Upload the image file to: / usr/local, decompress and move

[root@csxf ~] # su-root

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

[root@csxf local] # tar-xzvf mysql-5.6.39-linux-glibc2.12-x86_64.tar.gz

[root@csxf local] # mv mysql-5.6.39-linux-glibc2.12-x86_64/ mysql

Add MySQL users and groups to grant permissions

# add mysql users and groups

[root@csxf] # groupadd-g 101dba

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

[root@csxf ~] # id mysqladmin

# add environment variables

[root@csxf local] # cp / etc/skel/.* / usr/local/mysql

4. Configure my.cnf and modify permissions

# location of default configuration file / etc/my.cnf

[client] port = 3306socket = / usr/local/mysql/data/ mysql.sock [mysqld] port = 3306socket = / usr/local/mysql/data/mysql.sockskip-external-lockingkey_buffer_size = 256Msort_buffer_size = 2Mread_buffer_size = 2Mread_rnd_buffer_size = 4Mqueryroomcachesisize= 32Mmax_allowed_packet = 16Mmyisam_sort_buffer_size=128Mtmp_table_size=32Mtable_open_cache = 512thread_cache_size = 8wait_timeout = 86400interactive_timeout = 86400max_connections = 60 Try number of CPU's * 2 for thread_concurrencythread_concurrency = 32#isolation level and default enginedefault-storage-engine = INNODBtransaction-isolation = READ-COMMITTEDserver-id = 1basedir = / usr/local/mysqldatadir = / usr/local/mysql/datapid-file = / usr/local/mysql/data/hostname.pid#open performance schemalog-warningssysdate-is-nowbinlog_format = MIXEDlog_bin_trust_function_creators=1log-error = / usr/local/mysql/data/hostname.errlog-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 optionsinnodb_data_home_dir = / usr/local/mysql/data/innodb_data_file_path = ibdata1:500M:autoextendinnodb_log_group_home_dir = / usr/local/mysql/archinnodb_log_ Files_in_group = 2innodb_log_file_size = 200Minnodb_buffer_pool_size = 1024Minnodb_additional_mem_pool_size = 50Minnodb_log_buffer_size = 16Minnodb_lock_wait_timeout = 100#innodb_thread_concurrency = 0innodb_flush_log_at_trx_commit = 1innodb_locks_unsafe_for_binlog=1#innodb io features: add for mysql5.5.8performance_schemainnodb_read_io_threads=4innodb-write-io-threads=4innodb-io-capacity=200#purge threads change default (0) to 1 for purgeinnodb_ Purge_threads=1innodb_use_native_aio=on#case-sensitive file names and separate tablespaceinnodb_file_per_table = 1 lowerbroken caseplate tablebroken namespace = 1 [mysqldump] quickmax_allowed_packet = 16m [MySQL] no-auto-rehash [mysqlhotcopy] interactive- timeout [myisamchk] key_buffer_size = 256Msort_buffer_size = 256Mread_buffer = 2Mwrite_buffer = 2m

# modify my.cnf file permissions

[root@csxf local] # chown mysqladmin:dba / etc/my.cnf

[root@csxf local] # chmod 640 / etc/my.cnf

# modify the permissions of MySQL installation directory

[root@csxf local] # chown-R mysqladmin:dba / usr/local/mysql

[root@csxf local] # chmod-R 755 / usr/local/mysql

# switch mysqladmin users and prepare for installation

[root@csxf local] # su-mysqladmin

[mysqladmin@csxf ~] $pwd

/ usr/local/mysql

[mysqladmin@csxf ~] $mkdir arch

V. Database initialization

# switch initialization of MySQL user database

[mysqladmin@csxf] $scripts/mysql_install_db-- user=mysqladmin-- basedir=/usr/local/mysql-- datadir=/usr/local/mysql/data

# errors may occur

Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

# missing libaio.so package

[root@sht-sgmhadoopnn-01 local] # yum-y install libaio

# errors may occur

"/ usr/bin/perl: bad interpreter: No such file or directory"

# missing perl environment

[root@csxf mysql] # yum-y install perl perl-devel

[root@csxf mysql] # yum install-y perl-Data-Dumper

The error is reported and handled according to the actual situation of the error.

# Delete self-contained my.cnf files

[mysqladmin@csxf ~] $rm-rf my.cnf

VI. MySQL service configuration

# ROOT user creation service is copied to init.d service to facilitate start and stop

[root@csxf mysql] # cp / usr/local/mysql/support-files/mysql.server / etc/init.d/mysql

# Grant executable permissions

[root@csxf ~] # chmod + x / etc/init.d/mysql

# deleting a service

[root@csxf] # chkconfig-- del mysql

# add Services

[root@csxf] # chkconfig-- add mysql

[root@csxf] # chkconfig-- level 345 mysql on

[root@csxf] # chkconfig-- list mysql

Mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off

VI. MySQL starts the service

[root@csxf local] # su-mysqladmin

[mysqladmin@csxf ~] $bin/mysqld_safe &

[1] 10596

180508 17:21:55 mysqld_safe Logging to'/ usr/local/mysql/data/hostname.err'.

180508 17:21:55 mysqld_safe Starting mysqld daemon with databases from / usr/local/mysql/data

. Press enter

# check whether the startup is successful

[mysqladmin@csxf ~] $ps-ef | grep mysql

Root 10420 10210 0 16:52 pts/0 00:00:00 su-mysqladmin

Root 10550 10519 0 17:12 pts/0 00:00:00 su-mysqladmin

514 10596 10551 0 17:21 pts/0 00:00:00 / bin/sh bin/mysqld_safe

514 11239 10596 1 17:21 pts/0 00:00:00 / usr/local/mysql/bin/mysqld-basedir=/usr/local

7. Login and basic operation

# start the database

Service mysql start/stop/status/restart

# logging in for the first time

[mysqladmin@csxf ~] $mysql

# View all databases

Mysql > show databases

+-+

| | Database |

+-+

| | information_schema |

| | mysql |

| | performance_schema |

| | test |

+-+

# enter mysql database

Mysql > use mysql

# View all the tables under the mysql database

Mysql > show tables

# View user table, user and password

Mysql > select user,password,host from user

+-+

| | user | password | host | |

+-+

| | root | | localhost |

| | root | | csxf |

| | root | | 127.0.0.1 | |

| | root | |:: 1 |

| | localhost |

| | csxf |

+-+

# modify ROOT user password

Mysql > update user set password=password ('root') where user='root'

# refresh the cache

Mysql > flush privileges

# set remote connection permissions for root users

Mysql > grant all privileges on *. * to root@ "%" identified by 'root' with grant option

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.