linux安装mysql5.6实时教程和配置

接下来就是安装了分别依次执行：
[root@iZ25in7iu0fZrpm]#rpm-ivhMySQL-server-5.6.15-1.el6.x86_64.rpm
Preparing…###########################################[100%]
1:MySQL-server###########################################[100%]
2015-03-0608:16:030[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse–explicit_defaults_fZ喎"http://www.2cto.com/kf/ware/vc/"target="_blank"class="keylink">vcl90aW1lc3RhbXAgc2VydmVyIG9wdGlvbiAoc2VlIGRvY3VtZW50YXRpb24gZm9yIG1vcmUgZGV0YWlscykuPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjAzIDI4NjI5IFtOb3RlXSBJbm5vREI6IFRoZSBJbm5vREIgbWVtb3J5IGhlYXAgaXMgZGlzYWJsZWQ8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDMgMjg2MjkgW05vdGVdIElubm9EQjogTXV0ZXhlcyBhbmQgcndfbG9ja3MgdXNlIEdDQyBhdG9taWMgYnVpbHRpbnM8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDMgMjg2MjkgW05vdGVdIElubm9EQjogQ29tcHJlc3NlZCB0YWJsZXMgdXNlIHpsaWIgMS4yLjM8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDMgMjg2MjkgW05vdGVdIElubm9EQjogVXNpbmcgTGludXggbmF0aXZlIEFJTzxicj4KMjAxNS0wMy0wNiAwODoxNjowMyAyODYyOSBbTm90ZV0gSW5ub0RCOiBVc2luZyBDUFUgY3JjMzIgaW5zdHJ1Y3Rpb25zPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjAzIDI4NjI5IFtOb3RlXSBJbm5vREI6IEluaXRpYWxpemluZyBidWZmZXIgcG9vbCwgc2l6ZSA9IDEyOC4wTTxicj4KMjAxNS0wMy0wNiAwODoxNjowMyAyODYyOSBbTm90ZV0gSW5ub0RCOiBDb21wbGV0ZWQgaW5pdGlhbGl6YXRpb24gb2YgYnVmZmVyIHBvb2w8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDMgMjg2MjkgW05vdGVdIElubm9EQjogVGhlIGZpcnN0IHNwZWNpZmllZCBkYXRhIGZpbGUgLi9pYmRhdGExIGRpZCBub3QgZXhpc3Q6IGEgbmV3IGRhdGFiYXNlIHRvIGJlIGNyZWF0ZWQhPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjAzIDI4NjI5IFtOb3RlXSBJbm5vREI6IFNldHRpbmcgZmlsZSAuL2liZGF0YTEgc2l6ZSB0byAxMiBNQjxicj4KMjAxNS0wMy0wNiAwODoxNjowMyAyODYyOSBbTm90ZV0gSW5ub0RCOiBEYXRhYmFzZSBwaHlzaWNhbGx5IHdyaXRlcyB0aGUgZmlsZSBmdWxsOiB3YWl0Li4uPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjAzIDI4NjI5IFtOb3RlXSBJbm5vREI6IFNldHRpbmcgbG9nIGZpbGUgLi9pYl9sb2dmaWxlMTAxIHNpemUgdG8gNDggTUI8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDQgMjg2MjkgW05vdGVdIElubm9EQjogU2V0dGluZyBsb2cgZmlsZSAuL2liX2xvZ2ZpbGUxIHNpemUgdG8gNDggTUI8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogUmVuYW1pbmcgbG9nIGZpbGUgLi9pYl9sb2dmaWxlMTAxIHRvIC4vaWJfbG9nZmlsZTA8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW1dhcm5pbmddIElubm9EQjogTmV3IGxvZyBmaWxlcyBjcmVhdGVkLCBMU049NDU3ODE8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogRG91Ymxld3JpdGUgYnVmZmVyIG5vdCBmb3VuZDogY3JlYXRpbmcgbmV3PGJyPgoyMDE1LTAzLTA2IDA4OjE2OjA2IDI4NjI5IFtOb3RlXSBJbm5vREI6IERvdWJsZXdyaXRlIGJ1ZmZlciBjcmVhdGVkPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjA2IDI4NjI5IFtOb3RlXSBJbm5vREI6IDEyOCByb2xsYmFjayBzZWdtZW50KHMpIGFyZSBhY3RpdmUuPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjA2IDI4NjI5IFtXYXJuaW5nXSBJbm5vREI6IENyZWF0aW5nIGZvcmVpZ24ga2V5IGNvbnN0cmFpbnQgc3lzdGVtIHRhYmxlcy48YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogRm9yZWlnbiBrZXkgY29uc3RyYWludCBzeXN0ZW0gdGFibGVzIGNyZWF0ZWQ8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogQ3JlYXRpbmcgdGFibGVzcGFjZSBhbmQgZGF0YWZpbGUgc3lzdGVtIHRhYmxlcy48YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogVGFibGVzcGFjZSBhbmQgZGF0YWZpbGUgc3lzdGVtIHRhYmxlcyBjcmVhdGVkLjxicj4KMjAxNS0wMy0wNiAwODoxNjowNiAyODYyOSBbTm90ZV0gSW5ub0RCOiBXYWl0aW5nIGZvciBwdXJnZSB0byBzdGFydDxicj4KMjAxNS0wMy0wNiAwODoxNjowNiAyODYyOSBbTm90ZV0gSW5ub0RCOiA1LjYuMTUgc3RhcnRlZDsgbG9nIHNlcXVlbmNlIG51bWJlciAwPGJyPgpBIHJhbmRvbSByb290IHBhc3N3b3JkIGhhcyBiZWVuIHNldC4gWW91IHdpbGwgZmluZCBpdCBpbiA="/root/.mysql_secret'.
2015-03-0608:16:0728629[Note]Binlogend
2015-03-0608:16:0728629[Note]InnoDB:FTSoptimizethreadexiting.
2015-03-0608:16:0728629[Note]InnoDB:Startingshutdown…
2015-03-0608:16:0828629[Note]InnoDB:Shutdowncompleted;logsequencenumber1625977

2015-03-0608:16:080[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse–explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2015-03-0608:16:0828652[Note]InnoDB:TheInnoDBmemoryheapisdisabled
2015-03-0608:16:0828652[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins
2015-03-0608:16:0828652[Note]InnoDB:Compressedtablesusezlib1.2.3
2015-03-0608:16:0828652[Note]InnoDB:UsingLinuxnativeAIO
2015-03-0608:16:0828652[Note]InnoDB:UsingCPUcrc32instructions
2015-03-0608:16:0828652[Note]InnoDB:Initializingbufferpool,size=128.0M
2015-03-0608:16:0828652[Note]InnoDB:Completedinitializationofbufferpool
2015-03-0608:16:0828652[Note]InnoDB:HighestsupportedfileformatisBarracuda.
2015-03-0608:16:0828652[Note]InnoDB:128rollbacksegment(s)areactive.
2015-03-0608:16:0828652[Note]InnoDB:Waitingforpurgetostart
2015-03-0608:16:0828652[Note]InnoDB:5.6.15started;logsequencenumber1625977
2015-03-0608:16:0828652[Note]Binlogend
2015-03-0608:16:0828652[Note]InnoDB:FTSoptimizethreadexiting.
2015-03-0608:16:0828652[Note]InnoDB:Startingshutdown…
2015-03-0608:16:1028652[Note]InnoDB:Shutdowncompleted;logsequencenumber1625987

[root@iZ25in7iu0fZrpm]#rpm-ivhMySQL-devel-5.6.15-1.el6.x86_64.rpm
Preparing…###########################################[100%]
1:MySQL-devel###########################################[100%]
[root@iZ25in7iu0fZrpm]#rpm-ivhMySQL-client-5.6.15-1.el6.x86_64.rpm
Preparing…###########################################[100%]
1:MySQL-client###########################################[100%]

修改配置文件位置。
[root@iZ25in7iu0fZrpm]#cp/usr

/mysql/my-default.cnf/etc/my.cnf初始化MySQL及设置密码
cp/usr

/mysql/my-default.cnf/etc/my.cnf
/usr/bin/mysql_install_db
cat/root/.mysql_secret
记录最后的密码
mysql-p—输入记录的密码，即可登录mysql。
setpasswordfor'root'@'localhost'=password('新密码');
flushprivileges;
exit设置自启动
chkconfigmysqlon

MySQL的默认安装位置接下来就是安装了分别依次执行：
[root@iZ25in7iu0fZrpm]#rpm-ivhMySQL-server-5.6.15-1.el6.x86_64.rpm
Preparing…###########################################[100%]
1:MySQL-server###########################################[100%]
2015-03-0608:16:030[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse–explicit_defaults_fZ喎"http://www.2cto.com/kf/ware/vc/"target="_blank"class="keylink">vcl90aW1lc3RhbXAgc2VydmVyIG9wdGlvbiAoc2VlIGRvY3VtZW50YXRpb24gZm9yIG1vcmUgZGV0YWlscykuPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjAzIDI4NjI5IFtOb3RlXSBJbm5vREI6IFRoZSBJbm5vREIgbWVtb3J5IGhlYXAgaXMgZGlzYWJsZWQ8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDMgMjg2MjkgW05vdGVdIElubm9EQjogTXV0ZXhlcyBhbmQgcndfbG9ja3MgdXNlIEdDQyBhdG9taWMgYnVpbHRpbnM8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDMgMjg2MjkgW05vdGVdIElubm9EQjogQ29tcHJlc3NlZCB0YWJsZXMgdXNlIHpsaWIgMS4yLjM8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDMgMjg2MjkgW05vdGVdIElubm9EQjogVXNpbmcgTGludXggbmF0aXZlIEFJTzxicj4KMjAxNS0wMy0wNiAwODoxNjowMyAyODYyOSBbTm90ZV0gSW5ub0RCOiBVc2luZyBDUFUgY3JjMzIgaW5zdHJ1Y3Rpb25zPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjAzIDI4NjI5IFtOb3RlXSBJbm5vREI6IEluaXRpYWxpemluZyBidWZmZXIgcG9vbCwgc2l6ZSA9IDEyOC4wTTxicj4KMjAxNS0wMy0wNiAwODoxNjowMyAyODYyOSBbTm90ZV0gSW5ub0RCOiBDb21wbGV0ZWQgaW5pdGlhbGl6YXRpb24gb2YgYnVmZmVyIHBvb2w8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDMgMjg2MjkgW05vdGVdIElubm9EQjogVGhlIGZpcnN0IHNwZWNpZmllZCBkYXRhIGZpbGUgLi9pYmRhdGExIGRpZCBub3QgZXhpc3Q6IGEgbmV3IGRhdGFiYXNlIHRvIGJlIGNyZWF0ZWQhPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjAzIDI4NjI5IFtOb3RlXSBJbm5vREI6IFNldHRpbmcgZmlsZSAuL2liZGF0YTEgc2l6ZSB0byAxMiBNQjxicj4KMjAxNS0wMy0wNiAwODoxNjowMyAyODYyOSBbTm90ZV0gSW5ub0RCOiBEYXRhYmFzZSBwaHlzaWNhbGx5IHdyaXRlcyB0aGUgZmlsZSBmdWxsOiB3YWl0Li4uPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjAzIDI4NjI5IFtOb3RlXSBJbm5vREI6IFNldHRpbmcgbG9nIGZpbGUgLi9pYl9sb2dmaWxlMTAxIHNpemUgdG8gNDggTUI8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDQgMjg2MjkgW05vdGVdIElubm9EQjogU2V0dGluZyBsb2cgZmlsZSAuL2liX2xvZ2ZpbGUxIHNpemUgdG8gNDggTUI8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogUmVuYW1pbmcgbG9nIGZpbGUgLi9pYl9sb2dmaWxlMTAxIHRvIC4vaWJfbG9nZmlsZTA8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW1dhcm5pbmddIElubm9EQjogTmV3IGxvZyBmaWxlcyBjcmVhdGVkLCBMU049NDU3ODE8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogRG91Ymxld3JpdGUgYnVmZmVyIG5vdCBmb3VuZDogY3JlYXRpbmcgbmV3PGJyPgoyMDE1LTAzLTA2IDA4OjE2OjA2IDI4NjI5IFtOb3RlXSBJbm5vREI6IERvdWJsZXdyaXRlIGJ1ZmZlciBjcmVhdGVkPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjA2IDI4NjI5IFtOb3RlXSBJbm5vREI6IDEyOCByb2xsYmFjayBzZWdtZW50KHMpIGFyZSBhY3RpdmUuPGJyPgoyMDE1LTAzLTA2IDA4OjE2OjA2IDI4NjI5IFtXYXJuaW5nXSBJbm5vREI6IENyZWF0aW5nIGZvcmVpZ24ga2V5IGNvbnN0cmFpbnQgc3lzdGVtIHRhYmxlcy48YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogRm9yZWlnbiBrZXkgY29uc3RyYWludCBzeXN0ZW0gdGFibGVzIGNyZWF0ZWQ8YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogQ3JlYXRpbmcgdGFibGVzcGFjZSBhbmQgZGF0YWZpbGUgc3lzdGVtIHRhYmxlcy48YnI+CjIwMTUtMDMtMDYgMDg6MTY6MDYgMjg2MjkgW05vdGVdIElubm9EQjogVGFibGVzcGFjZSBhbmQgZGF0YWZpbGUgc3lzdGVtIHRhYmxlcyBjcmVhdGVkLjxicj4KMjAxNS0wMy0wNiAwODoxNjowNiAyODYyOSBbTm90ZV0gSW5ub0RCOiBXYWl0aW5nIGZvciBwdXJnZSB0byBzdGFydDxicj4KMjAxNS0wMy0wNiAwODoxNjowNiAyODYyOSBbTm90ZV0gSW5ub0RCOiA1LjYuMTUgc3RhcnRlZDsgbG9nIHNlcXVlbmNlIG51bWJlciAwPGJyPgpBIHJhbmRvbSByb290IHBhc3N3b3JkIGhhcyBiZWVuIHNldC4gWW91IHdpbGwgZmluZCBpdCBpbiA="/root/.mysql_secret'.
2015-03-0608:16:0728629[Note]Binlogend
2015-03-0608:16:0728629[Note]InnoDB:FTSoptimizethreadexiting.
2015-03-0608:16:0728629[Note]InnoDB:Startingshutdown…
2015-03-0608:16:0828629[Note]InnoDB:Shutdowncompleted;logsequencenumber1625977

2015-03-0608:16:080[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse–explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2015-03-0608:16:0828652[Note]InnoDB:TheInnoDBmemoryheapisdisabled
2015-03-0608:16:0828652[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins
2015-03-0608:16:0828652[Note]InnoDB:Compressedtablesusezlib1.2.3
2015-03-0608:16:0828652[Note]InnoDB:UsingLinuxnativeAIO
2015-03-0608:16:0828652[Note]InnoDB:UsingCPUcrc32instructions
2015-03-0608:16:0828652[Note]InnoDB:Initializingbufferpool,size=128.0M
2015-03-0608:16:0828652[Note]InnoDB:Completedinitializationofbufferpool
2015-03-0608:16:0828652[Note]InnoDB:HighestsupportedfileformatisBarracuda.
2015-03-0608:16:0828652[Note]InnoDB:128rollbacksegment(s)areactive.
2015-03-0608:16:0828652[Note]InnoDB:Waitingforpurgetostart
2015-03-0608:16:0828652[Note]InnoDB:5.6.15started;logsequencenumber1625977
2015-03-0608:16:0828652[Note]Binlogend
2015-03-0608:16:0828652[Note]InnoDB:FTSoptimizethreadexiting.
2015-03-0608:16:0828652[Note]InnoDB:Startingshutdown…
2015-03-0608:16:1028652[Note]InnoDB:Shutdowncompleted;logsequencenumber1625987

[root@iZ25in7iu0fZrpm]#rpm-ivhMySQL-devel-5.6.15-1.el6.x86_64.rpm
Preparing…###########################################[100%]
1:MySQL-devel###########################################[100%]
[root@iZ25in7iu0fZrpm]#rpm-ivhMySQL-client-5.6.15-1.el6.x86_64.rpm
Preparing…###########################################[100%]
1:MySQL-client###########################################[100%]

修改配置文件位置。
[root@iZ25in7iu0fZrpm]#cp/usr

/mysql/my-default.cnf/etc/my.cnf初始化MySQL及设置密码
cp/usr

/mysql/my-default.cnf/etc/my.cnf
/usr/bin/mysql_install_db
cat/root/.mysql_secret
记录最后的密码
mysql-p—输入记录的密码，即可登录mysql。
setpasswordfor'root'@'localhost'=password('新密码');
flushprivileges;
exit设置自启动
chkconfigmysqlon

MySQL的默认安装位置
1

ar

b/mysql/#数据库目录
2 /usr

/mysql#配置文件目录
3 /usr/bin#相关命令目录
4 /etc/init.d/mysql#启动脚本修改字符集和数据存放目录
原来配置文件：

更改之后为：# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. It"s a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.[client]port = 3306default-character-set=utf8[mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required.# basedir = …..datadir = /mnt/data/mysqlport = 3306# server_id = …..# socket = …..lower_case_table_names=1max_connections=1000collation_server = utf8_general_cicharacter_set_server = utf8# default-character-set=utf8# init_connect='SET NAMES utf8'# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2Msql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[mysql]default-character-set = utf8注意标红的。然后就是修改数据库的数据目录：vi /etc/init.d/mysql

重启数据库：service mysql restart大功告成。