1. Operating system
CentOS Release 6.2 (Final)
2. Create users and Groups
[[email protected] ~]# Groupadd MySQL
[Email protected] ~]# useradd-r-G mysqlmysql
3. Unzip the installation package (unzip to where you want to store the database data)
[Email protected] ~]# Cd/data
[Email protected] data]# tar-xzvf/root/mysql_soft/mysql-5.6.19-linux-glibc2.5-x86_64.tar.gz
[[email protected] data]# ln-s mysql-5.6.19-linux-glibc2.5-x86_64 MySQL
4. View the decompression situation
[email protected] data]# LL
Total dosage 20
lrwxrwxrwx. 1 root root 6 months 15:31 MySQL --mysql-5.6.19-linux-glibc2.5-x86_64
drwxr-xr-x. rootroot 4096 6 Month 15:31 mysql-5.6.19-linux-glibc2.5-x86_64
5. Change the directory to belong to the user and group MySQL:
[[Email protected] data]# CD MySQL
[Email protected] mysql]# chown-r mysql:mysql.
6. Install the database, the data storage folder is/data/mysql/data
[[email protected] MySQL] #scripts/mysql_install_db--user=mysql--basedir=/data/mysql--datadir=/data/mysql/data
Warning:the host ' Mymaster1.localdomain ' could not being looked up with/data/mysql/bin/resolveip.
This probably means Thatyour libc libraries is not compatible
With this binary mysqlversion. The MySQL daemon, mysqld, should work
Normally with the Exceptionthat host name resolving won't work.
This means, youshould use IP addresses instead of hostnames
When specifying Mysqlprivileges!
When the above warning appears, the workaround is to add a mapping of the IP address and hostname in the/etc/hosts configuration file
Such as
[Email protected] packages]# cat/etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6
IP Address Mymaster1.localdomain
The correct prompt information such as the following:
[[email protected] MySQL] #scripts/mysql_install_db--user=mysql--basedir=/data/mysql--datadir=/data/mysql/data
Installing MySQL system tables ... 2014-06-2716:02:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. --explicit_defaults_for_timestamp server Option (see documentationfor more details).
2014-06-27 16:02:45 2134 [Note] innodb:using Atomics to ref count buffer pool pages
2014-06-27 16:02:45 2134 [Note] innodb:theinnodb memory heap is disabled
2014-06-27 16:02:45 2134 [Note] innodb:mutexes and rw_locks use GCC atomic builtins
2014-06-27 16:02:45 2134 [Note] innodb:compressed tables use zlib 1.2.3
2014-06-27 16:02:45 2134 [Note] innodb:using Linux native AIO
2014-06-27 16:02:45 2134 [Note] innodb:using CPU CRC32 Instructions
2014-06-27 16:02:45 2134 [Note] innodb:initializing buffer pool, size = 128.0M
2014-06-27 16:02:45 2134 [Note] innodb:completed initialization of buffer pool
2014-06-27 16:02:45 2134 [Note] innodb:thefirst specified data file./ibdata1 did not exist:a new database to becreated!
2014-06-27 16:02:45 2134 [Note] innodb:setting file./ibdata1 size to MB
2014-06-27 16:02:45 2134 [Note] Innodb:database physically writes the file full:wait ...
2014-06-27 16:02:45 2134 [Note] innodb:setting log file./ib_logfile101 size to + MB
2014-06-27 16:02:46 2134 [Note] innodb:setting log file./ib_logfile1 size to + MB
2014-06-27 16:02:46 2134 [Note] innodb:renaming log file./ib_logfile101 to./ib_logfile0
2014-06-27 16:02:46 2134 [Warning] innodb:new log files created, lsn=45781
2014-06-27 16:02:46 2134 [Note] innodb:doublewrite buffer not found:creating new
2014-06-27 16:02:46 2134 [Note] Innodb:doublewrite buffer created
2014-06-27 16:02:46 2134 [Note] innodb:128rollback segment (s) is active.
2014-06-27 16:02:46 2134 [Warning] innodb:creating FOREIGN KEY constraint system tables.
2014-06-27 16:02:46 2134 [Note] innodb:foreign key constraint system tables created
2014-06-27 16:02:46 2134 [Note] innodb:creating tablespace and datafile system tables.
2014-06-27 16:02:46 2134 [Note] innodb:tablespace and datafile system tables created.
2014-06-27 16:02:46 2134 [Note] innodb:waiting for purge to start
2014-06-27 16:02:46 2134 [Note] innodb:5.6.19 started; Log sequence number 0
2014-06-27 16:02:47 2134 [Note] Binlog End
2014-06-27 16:02:47 2134 [Note] innodb:ftsoptimize thread exiting.
2014-06-27 16:02:47 2134 [Note] innodb:starting shutdown ...
2014-06-27 16:02:48 2134 [Note] Innodb:shutdown completed; Log sequence Number 1625977
Ok
Filling Help Tables ... 2014-06-27 16:02:48 0[warning] TIMESTAMP with implicit the DEFAULT value is deprecated. Use--explicit_defaults_for_timestamp server option (see documentation for Moredetails).
2014-06-27 16:02:48 2157 [Note] innodb:using Atomics to ref count buffer pool pages
2014-06-27 16:02:48 2157 [Note] innodb:theinnodb memory heap is disabled
2014-06-27 16:02:48 2157 [Note] innodb:mutexes and rw_locks use GCC atomic builtins
2014-06-27 16:02:48 2157 [Note] innodb:compressed tables use zlib 1.2.3
2014-06-27 16:02:48 2157 [Note] innodb:using Linux native AIO
2014-06-27 16:02:48 2157 [Note] innodb:using CPU CRC32 Instructions
2014-06-27 16:02:48 2157 [Note] innodb:initializing buffer pool, size = 128.0M
2014-06-27 16:02:48 2157 [Note] innodb:completed initialization of buffer pool
2014-06-27 16:02:48 2157 [Note] innodb:highest supported file format is Barracuda.
2014-06-27 16:02:48 2157 [Note] innodb:128rollback segment (s) is active.
2014-06-27 16:02:48 2157 [Note] innodb:waiting for purge to start
2014-06-27 16:02:48 2157 [Note] innodb:5.6.19 started; Log sequence Number 1625977
2014-06-27 16:02:48 2157 [Note] Binlog End
2014-06-27 16:02:48 2157 [Note] innodb:ftsoptimize thread exiting.
2014-06-27 16:02:48 2157 [Note] innodb:startingshutdown ...
2014-06-27 16:02:50 2157 [Note] Innodb:shutdown completed; Log sequence Number 1625987
Ok
To start mysqld at boot time with tocopy
Support-files/mysql.server to the rightplace for your system
REMEMBER to SET A PASSWORD for themysql root USER!
To do, start the server, then issue thefollowing commands:
/data/mysql/bin/mysqladmin-u root password ' new-password '
/data/mysql/bin/mysqladmin-u root-h mymaster1.localdomain password ' new-password '
Alternatively you can run:
/data/mysql/bin/mysql_secure_installation
Which would also give you the option ofremoving the test
Databases and anonymous user created Bydefault. This is
Strongly recommended for Productionservers.
See the Manual for more instructions.
You can start the MySQL daemon with:
CD.; /data/mysql/bin/mysqld_safe &
You can test the MySQL daemon withmysql-test-run.pl
Cdmysql-test; Perl mysql-test-run.pl
Problems athttp://bugs.mysql.com/
The latest information about MySQL isavailable on the web at
Http://www.mysql.com
Support for MySQL by buying Support/licenses athttp://shop.mysql.com
New Default Config file was created as/data/mysql/my.cnf and
Would be used by default by the server whenyou start it.
You could edit this file to the change serversettings
7. Change the permissions for the relevant folder. Improve security:
[Email protected] mysql]# chown-r root.
[[email protected] mysql]# chown-r mysql data
8. Configure the MySQL service to host the service. The service can be started by using service MySQL start
[Email protected] mysql]# Cpsupport-files/mysql.server/etc/init.d/mysql
[Email protected] mysql]# Vi/etc/init.d/mysql
Put the following
Basedir=
Datadir=
Changed to
Basedir=/data/mysql
Datadir=/data/mysql/data
9. Start the database
[[Email protected] mysql]# service MySQL start
Starting mysql[OK]
10. Change Database Rootpassword
[[email protected] mysql]#/data/mysql/bin/mysqladmin-u root password ' wengjixi '
[Email protected] mysql]#/data/mysql/bin/mysqladmin-u root-h mymaster1.localdomain password ' wengjixi '
11. Change the environment variable to add the MySQL run file path to the environment variable
[Email protected] mysql]# Vi/etc/profile
Path= $PATH:/data/mysql/bin
Export PATH
[Email protected] mysql]# Source/etc/profile
12. Test Login
[Email protected] mysql]# mysql-u root-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 5
Server version:5.6.19 MySQL communityserver (GPL)
Copyright (c) and/or, Oracle, Itsaffiliates. All rights reserved.
Oracle is a registered trademark of oraclecorporation and/or its
Affiliates. Other names trademarksof their respective
Owners.
Type ' help ', ' or ' \h ' for help. Type ' \c ' toclear the current input statement.
Mysql>
Mysql> Show variables like '%data% ';
+-------------------------------+------------------------+
| variable_name | Value |
+-------------------------------+------------------------+
| Character_set_database | Latin1 |
| Collation_database | Latin1_swedish_ci |
| DataDir | /data/mysql/data/
Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.
MySQL 5.6.192 Binary Installation