解壓版mysql+免破解版Navicat，好用！

Coding測試發表於2020-12-11
MySql

解壓版mysql安裝流程

  • 獲取mysql壓縮包
    獲取地址：
連結：https://pan.baidu.com/s/1HqdFDQn_6ccPM0gOftApIg 
提取碼：n19t

獲取壓縮包後可安裝壓縮包內的安裝說明執行安裝流程（整體配置環境變數和路徑即可）

  • 具體流程如下：
    1、如果本地已安裝mysql可執行如下命令：
# 刪除服務
sc delete mysql
#返回：[SC]
 Delete Service (成功)

2、配置mysql環境變數：在path中新增“MySQL\bin”的路徑（詳情可百度）
3、修改my-default.ini配置檔案，找到如下配置指向自己的安裝路徑

basedir = "D:\work\MySQL\mysql-5.6.24-win32"
datadir = "D:\work\MySQL\mysql-5.6.24-win32\data"

4、安裝MySQL服務，具體命令如下：

1)、進入安裝目錄
		cd D:\work\MySQL\mysql-5.6.24\bin
		e:
2)、安裝
		mysqld -install 	
		返回：Service successfully installed

5、啟動MySQL服務,具體命令如下：

net start MySQL

6、修改密碼

因為預設密碼為空。
	在\bin目錄下，執行：
		mysqladmin -uroot -p password 輸入你的新密碼   回車
		返回：Enter password
		不用管，直接回車，密碼修改成功。

到此mysql安裝成功，通過cmd驗證mysql如下：

  • 附my.ini配置檔案
附錄A：my.ini
--------------------------------------------------------------------------------
# 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.

[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.
# mysql根目錄
basedir = "D:\work\MySQL\mysql-5.6.24-win32"
# 資料檔案存放目錄
datadir = "D:\work\MySQL\mysql-5.6.24-win32\data"
# port = .....
# server_id = .....


# 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 

#服務端的編碼方式
character-set-server=utf8
[client]
#客戶端編碼方式，最好和服務端儲存一致
loose-default-character-set = utf8
[WinMySQLadmin]  
Server = "D:\work\MySQL\mysql-5.6.24-win32\bin\mysqld.exe"

-------------------------------my.ini <end>----------------------------------------

免破解版Navicat,解壓即可用

  • Navicat獲取地址：
連結：https://pan.baidu.com/s/1HBoyZ3p593JgXR5erh31wg 
提取碼：o50h
  • 下載後直接解壓，找到navicat.exe，直接啟動即可，整個過程無需破解！
    執行過程配置的mysql已經成功，如下：

簡單幾步即可完成mysql安裝！

更多測試技術分享、學習資源以及一些其他福利可關注公眾號：【Coding測試】獲取：
Coding測試

相關文章