在线亚洲黄色-在线亚洲观看-在线亚洲电影-在线亚洲成人-岛国大片在线观看免费版-岛国大片在线播放高清

linux安裝mysql56實時教程和配置

導讀[root@iZ25in7iu0fZ ;rpm]# ;rpm ;-ivh ;MysqL-server-5.6.15-1.el6.x86_64.rpm。Preparing... ;########################################### ;[100%]。1:MysqL-server ;########################################### ;[100%]。

?接下來就是安裝了分別依次執行:[root@iZ25in7iu0fZ?rpm]#?rpm?-ivh?MysqL-server-5.6.15-1.el6.x86_64.rpmPreparing...?###########################################?[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喎?"pleted;?log?sequence?number?16259772015-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?disabled2015-03-06?08:16:08?28652?[Note]?InnoDB:?Mutexes?and?rw_locks?use?GCC?atomic?builtins2015-03-06?08:16:08?28652?[Note]?InnoDB:?Compressed?tables?use?zlib?1.2.32015-03-06?08:16:08?28652?[Note]?InnoDB:?Using?Linux?native?AIO2015-03-06?08:16:08?28652?[Note]?InnoDB:?Using?cpu?crc32?instructions2015-03-06?08:16:08?28652?[Note]?InnoDB:?Initializing?buffer?pool,?size?=?128.0M2015-03-06?08:16:08?28652?[Note]?InnoDB:?Completed?initialization?of?buffer?pool2015-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?start2015-03-06?08:16:08?28652?[Note]?InnoDB:?5.6.15?started;?log?sequence?number?16259772015-03-06?08:16:08?28652?[Note]?binlog?end2015-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.rpmPreparing...?###########################################?[100%]1:MysqL-devel?###########################################?[100%][root@iZ25in7iu0fZ?rpm]#?rpm?-ivh?MysqL-client-5.6.15-1.el6.x86_64.rpmPreparing...?###########################################?[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_dbcat?/root/.MysqL_secret?記錄最后的密碼MysqL?-p?---輸入記錄的密碼,即可登錄MysqL。set?password?for?'root'@'localhost'?=password('新密碼');flush?privileges;exit設置自啟動chkconfig?MysqL?onMysqL的默認安裝位置接下來就是安裝了分別依次執行:[root@iZ25in7iu0fZ?rpm]#?rpm?-ivh?MysqL-server-5.6.15-1.el6.x86_64.rpmPreparing...?###########################################?[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喎?"pleted;?log?sequence?number?16259772015-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?disabled2015-03-06?08:16:08?28652?[Note]?InnoDB:?Mutexes?and?rw_locks?use?GCC?atomic?builtins2015-03-06?08:16:08?28652?[Note]?InnoDB:?Compressed?tables?use?zlib?1.2.32015-03-06?08:16:08?28652?[Note]?InnoDB:?Using?Linux?native?AIO2015-03-06?08:16:08?28652?[Note]?InnoDB:?Using?cpu?crc32?instructions2015-03-06?08:16:08?28652?[Note]?InnoDB:?Initializing?buffer?pool,?size?=?128.0M2015-03-06?08:16:08?28652?[Note]?InnoDB:?Completed?initialization?of?buffer?pool2015-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?start2015-03-06?08:16:08?28652?[Note]?InnoDB:?5.6.15?started;?log?sequence?number?16259772015-03-06?08:16:08?28652?[Note]?binlog?end2015-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.rpmPreparing...?###########################################?[100%]1:MysqL-devel?###########################################?[100%][root@iZ25in7iu0fZ?rpm]#?rpm?-ivh?MysqL-client-5.6.15-1.el6.x86_64.rpmPreparing...?###########################################?[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_dbcat?/root/.MysqL_secret?記錄最后的密碼MysqL?-p?---輸入記錄的密碼,即可登錄MysqL。set?password?for?'root'@'localhost'?=password('新密碼');flush?privileges;exit設置自啟動chkconfig?MysqL?onMysqL的默認安裝位置??1arb/MysqL/?#數據庫目錄2/usr/MysqL?#配置文件目錄3/usr/bin?#相關命令目錄4/etc/init.d/MysqL?#啟動腳本?修改字符集和數據存放目錄原來配置文件:?更改之后為:?#Foradviceonhowtochangesettingspleasesee#/doc/refman/5.6/en/server-configuration-defaults.html#***DONOTEDITTHISFILE.It"satemplatewhichwillbecopiedtothe#***defaultlocationduringinstall,andwillbereplacedifyou#***upgradetoanewerversionofMysqL.??[client]port=3306default-character-set=utf8????[MysqLd]??#Removeleading#andsettotheamountofRAMforthemostimportantdata#cacheinMysqL.Startat70%oftotalRAMfordedicatedserver,else10%.#innodb_buffer_pool_size=128M??#Removeleading#toturnonaveryimportantdataintegrityoption:logging#changestothebinarylogbetweenbackups.#log_bin??#Thesearecommonlyset,removethe#andsetasrequired.#basedir=.....datadir=/mnt/data/MysqLport=3306#server_id=.....#socket=.....??lower_case_table_names=1??max_connections=1000??collation_server=utf8_general_cicharacter_set_server=utf8??#default-character-set=utf8#init_connect='SETNAMESutf8'????#Removeleading#tosetoptionsmainlyusefulforreportingservers.#TheserverdefaultsarefasterfortransactionsandfastSELECTs.#Adjustsizesasneeded,experimenttofindtheoptimalvalues.#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重啟數據庫:??serviceMysqLrestart大功告成。

為你推薦
資訊專欄
熱門視頻
相關推薦
Linux安裝之U盤引導 win8msvcr100dll丟失處理辦法 Win81開機進入OneDrive選項而不是正常桌面的解決辦 做DBA必須學會不會會死的11個Linux基本命令 Linux克隆虛擬機引起的Deviceeth0doesnotseemto 記錄Linux啟動流程的工具bootchart Win81如何設置自動連接寬帶 WIN8離線直接安裝NET35 ubuntu中taglist和ctags安裝簡單明了 Windows8的不讓輸入法使你困擾 Windows7旗艦版系統下設置文件選擇時前面有個復 Windows10build10240怎么升級 Win8系統中怎樣合并多個txt文件 有道云筆記如何設置鎖定密碼有道云筆記設置 win8提示你的計算機配置似乎是正確的怎么辦2 Win8谷歌瀏覽器提示沒有注冊類別該怎么辦 怎么樣隱藏Win81Update電源按鈕 Win8系統打開應用商店出現0x8086000c錯誤怎么辦 WindowsAnytimeUpgrade輸錯密鑰處理辦法 linux資源限制級別匯總 Windows81系統怎么樣安裝密鑰的詳細 linux命令系列之man linux多服務器之間的目錄文件同步辦法 Linux正則表達式通配符 Win8鼠標移動速度怎么調 Linux學習筆記之Linux相關 Win81藍屏提示錯誤MemoryManagement并重啟怎么辦 Win8如何使用步驟記錄器功能 linux下vi編輯器命令大全3 Win8系統ADSL寬帶連接空閑時自動斷網該如何解決 Linux中添加用戶刪除用戶時新手可能遇到的問題 windows7遠程控制windows81圖文方法教程 Linux服務器上輕松導入導出恢復備份MySQL數 Win8系統如何共享無線實現手機上網詳細教程 愛奇藝黑屏有聲音怎么解決愛奇藝黑屏有聲音 Win8系統開機出現藍屏錯誤代碼0x000008e怎么修復 linux如何后臺運行進程 怎么樣打開Win81設備管理器 qsed文件是什么快播qsed文件有什么作用 Win8注冊表怎么樣備份呢圖
Top 主站蜘蛛池模板: 国产一区欧美二区 | 国产精品视频专区 | 免费黄色网址在线观看 | 国产午夜在线观看 | 精品123区| 香蕉久久综合 | 亚洲日韩欧美综合 | 日本丶国产丶欧美色综合 | 一级特黄女毛毛片 | 一区二区在线观看视频 | 国产网站在线免费观看 | 国产精品第5页 | 日日天天| 亚洲一区日韩二区欧美三区 | 欧美在线视频网 | 国产原创一区 | 亚洲精品99久久久久中文字幕 | 六月丁香在线观看 | 国产精品久久久久久一级毛片 | 天天曰夜夜操 | 特一级大黄在线观看 | 国产福利一区二区 | 一级成人毛片免费观看 | 无遮挡黄色 | 国产精品激情综合久久 | 亚洲国产精品免费在线观看 | 久久伊人一区二区三区四区 | 国产欧美日韩高清专区手机版 | 精品在线免费观看 | 三男一女的伦交动态图 | 国产精品久久久久久久牛牛 | 欧美 日韩 国产 色 欧美 日韩 中文 | 精品成人一区二区三区免费视频 | 综合 欧美 亚洲日本 | 午夜欧美 | 国产成人欧美一区二区三区vr | 91精品日本久久久久久牛牛 | 欧美精品免费在线观看 | 欧美精品一区二区在线观看播放 | 欧美日韩国产在线成人网 | 免费一级毛片视频 |