PHP study 升級預設的MYSQL版本 為5.7

逍遙俠發表於2018-11-26
PHPMySql

前言：由於專案需求，本地開發環境使用了phpstudy 的預設整合環境，但是由於其自帶的mysql只是5.5的版本。在laravel 應用中顯得尤為不足，而且這段時間需要學習laracms 其本身要求的資料庫就需要達到5.7沒辦法只能升級。看了網上很多的教程和方法，前期總是很好的，但是每次重啟的時候都會報無法連線本地的錯誤。

Can't connect to MySQL server on localhost (10061)

於是只能是慢慢地摸索和找方法，終於找到了解決方式，併為此記錄下來。分享給有需要的朋友。


1.備份原來的MySQL資料夾phpstudy\PHPTutorial\MySQL重新命名為MySQL5.5 2.將下載的mysql5.7壓縮檔案解壓縮，並放在phpstudy\PHPTutorial\資料夾下，命名為MySQL； 3.將目錄下的my-default.ini修改為my.ini (這裡本人嘗試過把原有的ini檔案直接放進去,但是在啟動的時候就是不停地報錯。)

我設定的my.ini,有需要的可以直接貼上複製使用，後期請自行重新根據各自的專案進行重新配置

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/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.
basedir="D:/phpstudy/PHPTutorial/MySQL/"
datadir="D:/phpstudy/PHPTutorial/MySQL/data/"
port=3306
# 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 
#skip-grant-tables
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=512
explicit_defaults_for_timestamp=true
複製程式碼

4.以管理員身份執行cmd進入phpstudy\PHPTutorial\MySQL\bin目錄；

執行 mysqld --install #此命令用於安裝mysql執行後顯示：Service successfully installed複製程式碼

5.執行 mysqld --initialize --user=root --console

執行後顯示:
2018-11-26T05:30:06.207044Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-11-26T05:30:06.310050Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-11-26T05:30:06.340052Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 5524df0e-f13c-11e8-8811-1c6f65e86efe.
2018-11-26T05:30:06.343052Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-11-26T05:30:06.359053Z 1 [Note] A temporary password is generated for root@localhost: :5OVJr5WO<Ws複製程式碼

其中（:5OVJr5WO<Ws）為新生成的隨機密碼

此時使用“net start mysql”成功啟動msyql複製程式碼

net start mysql
MySQL 服務正在啟動 .
MySQL 服務已經啟動成功。
複製程式碼

登入成功後可以通過隨機的賬號密碼對資料庫進行登入

mysql -u root -p
Enter password: （輸入生成的隨機密碼）

#登入後重新修改密碼
set password=password('123456');

#到此在phpstudy下重新升級mysql完成

最後記得刪除之前老的mysql版本
mysqld -remove
然後再phpstudy中重新安裝服務就可以了複製程式碼


相關文章