歡迎來到Linux教程網
Linux教程網
Linux教程網
Linux教程網
Linux教程網 >> Linux基礎 >> 關於Linux >> linux安裝mysql5.6實時教程和配置

linux安裝mysql5.6實時教程和配置

日期:2017/3/3 16:56:53   编辑:關於Linux
\
接下來就是安裝了分別依次執行:
[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/share/mysql/my-default.cnf /etc/my.cnf初始化MySQL及設置密碼
cp /usr/share/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的默認安裝位置
Copyright © Linux教程網 All Rights Reserved