linux安装mysql5.6实时教程和配置
系统教程导读
互联网集市收集整理了【linux安装mysql5.6实时教程和配置】操作系统教程，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含12548字，纯文字阅读大概需要18分钟。
系统教程内容图文
接下来就是安装了分别依次执行：
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-server-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
2015-03-06 08:16:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --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-06 08:16:07 28629 [Note] Binlog end
2015-03-06 08:16:07 28629 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 08:16:07 28629 [Note] InnoDB: Starting shutdown...
2015-03-06 08:16:08 28629 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2015-03-06 08:16:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-03-06 08:16:08 28652 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-06 08:16:08 28652 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-03-06 08:16:08 28652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-06 08:16:08 28652 [Note] InnoDB: Using Linux native AIO
2015-03-06 08:16:08 28652 [Note] InnoDB: Using CPU crc32 instructions
2015-03-06 08:16:08 28652 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-06 08:16:08 28652 [Note] InnoDB: Completed initialization of buffer pool
2015-03-06 08:16:08 28652 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-06 08:16:08 28652 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-06 08:16:08 28652 [Note] InnoDB: Waiting for purge to start
2015-03-06 08:16:08 28652 [Note] InnoDB: 5.6.15 started; log sequence number 1625977
2015-03-06 08:16:08 28652 [Note] Binlog end
2015-03-06 08:16:08 28652 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 08:16:08 28652 [Note] InnoDB: Starting shutdown...
2015-03-06 08:16:10 28652 [Note] InnoDB: Shutdown completed; log sequence number 1625987
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-devel-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
修改配置文件位置。
[root@iZ25in7iu0fZ rpm]# 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。
set password for 'root'@'localhost' =password('新密码');
flush privileges;
exit设置自启动
chkconfig mysql on
MySQL的默认安装位置接下来就是安装了分别依次执行：
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-server-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
2015-03-06 08:16:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --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-06 08:16:07 28629 [Note] Binlog end
2015-03-06 08:16:07 28629 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 08:16:07 28629 [Note] InnoDB: Starting shutdown...
2015-03-06 08:16:08 28629 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2015-03-06 08:16:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-03-06 08:16:08 28652 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-06 08:16:08 28652 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-03-06 08:16:08 28652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-06 08:16:08 28652 [Note] InnoDB: Using Linux native AIO
2015-03-06 08:16:08 28652 [Note] InnoDB: Using CPU crc32 instructions
2015-03-06 08:16:08 28652 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-06 08:16:08 28652 [Note] InnoDB: Completed initialization of buffer pool
2015-03-06 08:16:08 28652 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-06 08:16:08 28652 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-06 08:16:08 28652 [Note] InnoDB: Waiting for purge to start
2015-03-06 08:16:08 28652 [Note] InnoDB: 5.6.15 started; log sequence number 1625977
2015-03-06 08:16:08 28652 [Note] Binlog end
2015-03-06 08:16:08 28652 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 08:16:08 28652 [Note] InnoDB: Starting shutdown...
2015-03-06 08:16:10 28652 [Note] InnoDB: Shutdown completed; log sequence number 1625987
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-devel-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
修改配置文件位置。
[root@iZ25in7iu0fZ rpm]# 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。
set password for 'root'@'localhost' =password('新密码');
flush privileges;
exit设置自启动
chkconfig mysql on
MySQL的默认安装位置
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-server-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
2015-03-06 08:16:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --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-06 08:16:07 28629 [Note] Binlog end
2015-03-06 08:16:07 28629 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 08:16:07 28629 [Note] InnoDB: Starting shutdown...
2015-03-06 08:16:08 28629 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2015-03-06 08:16:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-03-06 08:16:08 28652 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-06 08:16:08 28652 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-03-06 08:16:08 28652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-06 08:16:08 28652 [Note] InnoDB: Using Linux native AIO
2015-03-06 08:16:08 28652 [Note] InnoDB: Using CPU crc32 instructions
2015-03-06 08:16:08 28652 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-06 08:16:08 28652 [Note] InnoDB: Completed initialization of buffer pool
2015-03-06 08:16:08 28652 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-06 08:16:08 28652 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-06 08:16:08 28652 [Note] InnoDB: Waiting for purge to start
2015-03-06 08:16:08 28652 [Note] InnoDB: 5.6.15 started; log sequence number 1625977
2015-03-06 08:16:08 28652 [Note] Binlog end
2015-03-06 08:16:08 28652 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 08:16:08 28652 [Note] InnoDB: Starting shutdown...
2015-03-06 08:16:10 28652 [Note] InnoDB: Shutdown completed; log sequence number 1625987
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-devel-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
修改配置文件位置。
[root@iZ25in7iu0fZ rpm]# 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。
set password for 'root'@'localhost' =password('新密码');
flush privileges;
exit设置自启动
chkconfig mysql on
MySQL的默认安装位置接下来就是安装了分别依次执行：
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-server-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
2015-03-06 08:16:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --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-06 08:16:07 28629 [Note] Binlog end
2015-03-06 08:16:07 28629 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 08:16:07 28629 [Note] InnoDB: Starting shutdown...
2015-03-06 08:16:08 28629 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2015-03-06 08:16:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-03-06 08:16:08 28652 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-06 08:16:08 28652 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-03-06 08:16:08 28652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-06 08:16:08 28652 [Note] InnoDB: Using Linux native AIO
2015-03-06 08:16:08 28652 [Note] InnoDB: Using CPU crc32 instructions
2015-03-06 08:16:08 28652 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-06 08:16:08 28652 [Note] InnoDB: Completed initialization of buffer pool
2015-03-06 08:16:08 28652 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-06 08:16:08 28652 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-06 08:16:08 28652 [Note] InnoDB: Waiting for purge to start
2015-03-06 08:16:08 28652 [Note] InnoDB: 5.6.15 started; log sequence number 1625977
2015-03-06 08:16:08 28652 [Note] Binlog end
2015-03-06 08:16:08 28652 [Note] InnoDB: FTS optimize thread exiting.
2015-03-06 08:16:08 28652 [Note] InnoDB: Starting shutdown...
2015-03-06 08:16:10 28652 [Note] InnoDB: Shutdown completed; log sequence number 1625987
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-devel-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
[root@iZ25in7iu0fZ rpm]# rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
修改配置文件位置。
[root@iZ25in7iu0fZ rpm]# 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。
set password for 'root'@'localhost' =password('新密码');
flush privileges;
exit设置自启动
chkconfig mysql on
MySQL的默认安装位置
1 arb/mysql/ #数据库目录
2 /usr/mysql #配置文件目录
3 /usr/bin #相关命令目录
4 /etc/init.d/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 = 3306
default-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/mysql
port = 3306
# server_id = .....
# socket = .....
lower_case_table_names=1
max_connections=1000
collation_server = utf8_general_ci
character_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 = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
default-character-set = utf8
注意标红的。
然后就是修改数据库的数据目录：
vi /etc/init.d/mysql
重启数据库：
service mysql restart
大功告成。
系统教程总结
以上是互联网集市为您收集整理的【linux安装mysql5.6实时教程和配置】操作系统教程的全部内容，希望文章能够帮你了解操作系统教程linux安装mysql5.6实时教程和配置。 如果觉得互联网集市操作系统教程内容还不错，欢迎将互联网集市网站推荐给好友。
系统教程备注
版权声明：本文内容由互联网用户贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
系统教程手机端
扫描二维码推送至手机访问。
来源：【匿名】