linux安装mysql5.6实时教程和配置
接下来就是安装了分别依次执行：
[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
大功告成。
相关文章
- win11如何设置绿色护眼模式？win11绿色护眼模式开启教程
- win10不显示新安装硬盘怎么办？win10新安装硬盘找不到解决方法
- win10如何修改开机问候语？win10系统开机问候语更改教程
- 360浏览器如何开启桌面搜索栏？360浏览器桌面搜索栏启动教程
- Word怎么切换成正常模式？Word兼容模式修改为正常模式教程
- win10如何把cad卸载干净？win10彻底卸载cad操作教程
- Win10响度均衡怎么设置？Win10响度均衡的设置方法
- win11怎么更改默认应用？win11系统修改默认应用教程
- win10便签程序怎么调出来？win10系统便签添加教程
- VMware Workstation怎么更改默认路径？VMware修改默认路径教程
系统下载排行榜71011xp
1
番茄花园 GHOST WIN7 SP1 X64 快速稳定版 V2017.03 (64位
2深度技术 GHOST WIN7 SP1 X64 稳定安全版 V2017.02（64位
3雨林木风 GHOST WIN7 SP1（32位）装机版 V2017.03
4深度技术 GHOST WIN7 SP1 X86 专业装机版 V2017.03（32位
5电脑公司 GHOST WIN7 SP1 X86 经典旗舰版 V2017.03（32位
6深度技术 GHOST WIN7 SP1 X86 稳定安全版 V2017.02
7深度技术 GHOST WIN7 SP1 X64 专业装机版 V2017.03（64位
8电脑公司 GHOST WIN7 SP1 X64 经典旗舰版 V2017.03（64位
9电脑公司 GHOST WIN7 SP1 X64 新春贺岁版 V2017.02（64位
10电脑公司 GHOST WIN7 SP1 X86 新春贺岁版 V2017.02（32位
1
win10系统下载 Win10 1607 精简安装版 LTSB长期服务版
2Win10专业工作站版最新镜像 V2022.06
3微软原版Win10 ISO镜像64位（win10纯净版）
4深度技术 Ghost Win10 64位 国庆特别版 V2021.10
5电脑公司Ghost Win10 64位装机版V2017.03
6雨晨 Win10 1703 15063.250 64位 极速精简版
7JUJUMAO Win8.1 Up3 X64 极速精简版v2019.11
8win10系统下载 稳安快 Win10 x64 极速精简版 V1.0
9lopatkin Win10专业精简版 V2022.05
10Win10 21H2 纯净版镜像 V2021
1
Win11PE网络纯净版 V2021
2风林火山 Ghost Win11 64位 专业正式版 V2021.10
3Win11官方纯净版 V2021
4Win11 23H2 25115 官方原版镜像 V2022.05
5新一代系统 JUJUMAO Win11专业版 64位 v2021.08
6雨林木风 Ghost Win11 64位 正式版 V2021.10
7微软MSDN原版Win11系统 V2021
8Win11 22000.282正式版镜像 V2021.10
9深度技术 Ghost Win11 64位 专业版 V2021.10
10微软Win11游戏系统 V2021.10
1
深度技术 GHOST XP SP3 电脑专用版 V2017.03
2深度技术 GGHOST XP SP3 电脑专用版 V2017.02
3Win7系统下载 PCOS技术Ghost WinXP SP3 2017 夏季装机版
4萝卜家园 GHOST XP SP3 万能装机版 V2017.03
5番茄花园 GHOST XP SP3 极速体验版 V2017.03
6雨林木风 GHOST XP SP3 官方旗舰版 V2017.03
7电脑公司 GHOST XP SP3 经典旗舰版 V2017.03
8雨林木风GHOST XP SP3完美纯净版【V201710】已激活
9萝卜家园 GHOST XP SP3 完美装机版 V2016.10
10雨林木风 GHOST XP SP3 精英装机版 V2017.04
热门教程
装机必备 更多+
重装工具
