97爱亚洲综合成人,丰满少妇被猛烈进av毛片,欧美精品18videos性欧美,欧美成年视频在线观看,国产97成人亚洲综合在线观看

首頁 > 軟件下載> 數(shù)據(jù)庫類 > Mysql 5.7.11 32位官方解壓版
Mysql 5.7.11 32位官方解壓版
  • 軟件大?。?span itemprop="fileSize">202.00MB
  • 更新日期:2016/04/05
  • 軟件語言:簡體中文
  • 軟件類別:數(shù)據(jù)庫類
  • 軟件授權(quán):免費軟件
  • 軟件官網(wǎng):
  • 適用平臺:WinAll
7
軟件評分
392 1

91本地下載文件大?。?02.00MB

  • 軟件介紹
  • 人氣軟件
  • 相關(guān)文章
  • 精品推薦

給大家分享下Mysql 5.7.11 32位官方解壓版,該本為目前最新的My SQL 版本,用戶下載后按照本篇下面教程配置后可以直接使用,有需要的可以來本站下載。

mysql 5.7.11解壓版安裝教程

1、解壓安裝包

2、將my-default.ini文件另存為my.ini,并新建data目錄(5.7以后沒有data目錄了)

3、修改my.ini文件,主要是添加如下幾項

 

1

 

2

 

3

 

4

 
 

< class="xml plain" style="border: 0px; margin: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; box-sizing: content-box !important; font-size: 1em !important; overflow: visible !important; height: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; width: auto !important; vertical-align: baseline !important; right: auto !important; position: static !important; float: none !important; color: black !important; outline: invert none 0px !important; padding: 0px !important; left: auto !important; line-height: 1.1em !important; top: auto !important; bottom: auto !important; background: none 0% 0% repeat scroll transparent;">basedir = D:⁄mysql-5.7.11-winx64</>

 

< class="xml plain" style="border: 0px; margin: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; box-sizing: content-box !important; font-size: 1em !important; overflow: visible !important; height: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; width: auto !important; vertical-align: baseline !important; right: auto !important; position: static !important; float: none !important; color: black !important; outline: invert none 0px !important; padding: 0px !important; left: auto !important; line-height: 1.1em !important; top: auto !important; bottom: auto !important; background: none 0% 0% repeat scroll transparent;">datadir = D:⁄mysql-5.7.11-winx64⁄data</>

 

< class="xml plain" style="border: 0px; margin: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; box-sizing: content-box !important; font-size: 1em !important; overflow: visible !important; height: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; width: auto !important; vertical-align: baseline !important; right: auto !important; position: static !important; float: none !important; color: black !important; outline: invert none 0px !important; padding: 0px !important; left: auto !important; line-height: 1.1em !important; top: auto !important; bottom: auto !important; background: none 0% 0% repeat scroll transparent;">port = 3306</>

 

< class="xml plain" style="border: 0px; margin: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; box-sizing: content-box !important; font-size: 1em !important; overflow: visible !important; height: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; width: auto !important; vertical-align: baseline !important; right: auto !important; position: static !important; float: none !important; color: black !important; outline: invert none 0px !important; padding: 0px !important; left: auto !important; line-height: 1.1em !important; top: auto !important; bottom: auto !important; background: none 0% 0% repeat scroll transparent;">character_set_server = utf8</>

   

注:D:⁄mysql-5.7.11-winx64為我的解壓目錄

4、安裝MySQL服務(wù),啟動命令提示符(管理員)并切換到[MySQL安裝目錄]/bin下,并依次執(zhí)行如下命令

 

1

 
 

< class="php plain" style="border: 0px; margin: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; box-sizing: content-box !important; font-size: 1em !important; overflow: visible !important; height: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; width: auto !important; vertical-align: baseline !important; right: auto !important; position: static !important; float: none !important; color: black !important; outline: invert none 0px !important; padding: 0px !important; left: auto !important; line-height: 1.1em !important; top: auto !important; bottom: auto !important; background: none 0% 0% repeat scroll transparent;">mysqld  --initialize-insecure</>

   

注:該命令初始化數(shù)據(jù)庫并且初始化的root用戶沒有密碼(mysqld --initialize也能進行初始化但是root用戶的密碼為一隨機值),執(zhí)行完后data目錄下會多出一些數(shù)據(jù)庫相關(guān)的文件

 

1

 
 

< class="php plain" style="border: 0px; margin: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; box-sizing: content-box !important; font-size: 1em !important; overflow: visible !important; height: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; width: auto !important; vertical-align: baseline !important; right: auto !important; position: static !important; float: none !important; color: black !important; outline: invert none 0px !important; padding: 0px !important; left: auto !important; line-height: 1.1em !important; top: auto !important; bottom: auto !important; background: none 0% 0% repeat scroll transparent;">mysqld install</>

   

注:該命令為將MySQL服務(wù)安裝進Windows服務(wù)里,方便使用如下命令啟動和關(guān)閉服務(wù)

啟動MySQL服務(wù):net start mysql

關(guān)閉MySQL服務(wù):net stop mysql

5、修改root用戶的密碼

 

1

 
 

< class="php plain" style="border: 0px; margin: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; box-sizing: content-box !important; font-size: 1em !important; overflow: visible !important; height: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; width: auto !important; vertical-align: baseline !important; right: auto !important; position: static !important; float: none !important; color: black !important; outline: invert none 0px !important; padding: 0px !important; left: auto !important; line-height: 1.1em !important; top: auto !important; bottom: auto !important; background: none 0% 0% repeat scroll transparent;">mysqladmin -uroot -p password</>

   

Mysql 5.7.11新功能特性:

InnoDB: 增加 InnoDB 新的配置參數(shù) innodb_tmpdir, 用于配置一個單獨的臨時目錄用于聯(lián)機 ALTER TABLE 操作,避免 tmpdir 超出限制

InnoDB: InnoDB 現(xiàn)在支持 at-rest 數(shù)據(jù)加密,用于 file-per-table 表空間,通過指定 ENCRYPTION 參數(shù)啟用,詳情請看 InnoDB Tablespace Encryption. Linux學(xué)習(xí),http:// linux.it.net.cn

Replication: 新增 log_statements_unsafe_for_binlog 變量用于控制是否生成 1592 錯誤的警告添加到二進制日志

yaSSL 更新到 2.3.9 版本

Valgrind 功能簽名升級到 3.11 版本

audit_log 插件可在 MYSQL_AUDIT_TABLE_ACCESS_CLASS 類中生成事件,事件可終止 (Bug #21458192) Linux學(xué)習(xí),http:// linux.it.net.cn

mysqld_safe 生成的日志格式可通過 --mysqld-safe-log-timestamps 參數(shù)進行配置

廢棄 mysql_kill(), mysql_list_fields(), mysql_list_processes(), 和 mysql_refresh() 等 C API,將來這些 API 將被移除,可通過 mysql_query() 來執(zhí)行 KILL, SHOW COLUMNS, SHOW PROCESSLIST, or FLUSH 操作

mysql_plugin 工具已被廢棄,將在以后版本中移除,可在服務(wù)器啟動時候通過 --plugin-load 或者 --plugin-load-add 參數(shù)進行控制,或者在運行時使用 INSTALL PLUGIN 語句. Linux學(xué)習(xí),http:// linux.it.net.cn

存儲引擎現(xiàn)在可請求關(guān)于元數(shù)據(jù)鎖的獲得和釋放