14,954
edits
XAMPP: Difference between revisions
Jump to navigation
Jump to search
→change the MySQL port
| Line 59: | Line 59: | ||
For AppServ or MySQL Server 5.6 | For AppServ or MySQL Server 5.6 | ||
* Windows: '''Start''' -> '''Control Panel''' -> '''Administrative Tools''' -> '''Services''' -> stop the '''MySQL''' service | * Windows: '''Start''' -> '''Control Panel''' -> '''Administrative Tools''' -> '''Services''' -> stop the '''MySQL''' service | ||
* | * open the MySQL configuration file: {{exclaim}} location of configuration file: You can check the path from '''Services''' -> '''MySQL''' service -> (Right mouse click the service name) '''Content''' -> '''Path to executable''', and find the parameter of --defaults-file | ||
** For MySQL Server 5.6: x:\ProgramData\MySQL\MySQL Server 5.6\my.ini {{exclaim}} not the file located: x:\Program Files\MySQL\MySQL Server 5.6\my-default.ini | ** For MySQL Server 5.6: x:\ProgramData\MySQL\MySQL Server 5.6\my.ini <ref>"x:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="x:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56</ref> {{exclaim}} not the file located: x:\Program Files\MySQL\MySQL Server 5.6\my-default.ini | ||
** For AppServ v.2.5.10: x:\AppServ\MySQL\my.ini | ** For AppServ v.2.5.10: x:\AppServ\MySQL\my.ini <ref>x:\AppServ\MySQL\bin\mysqld-nt --defaults-file=x:\AppServ\MySQL\my.ini mysql</ref> | ||
* find this line: port=3306, and change the port what you want ex: 3307. And save the configuration file. | * modify the MySQL configuration file | ||
** find this line: port=3306, and change the port what you want ex: 3307. And save the configuration file. | |||
* restart the MySQL service | * restart the MySQL service | ||
* (optional) If you using [http://www.phpmyadmin.net/home_page/index.php phpMyAdmin] for MySQL management, you need to change port setting of the phpMyAdmin config file. | * (optional) If you using [http://www.phpmyadmin.net/home_page/index.php phpMyAdmin] for MySQL management, you need to change port setting of the phpMyAdmin config file. | ||
| Line 73: | Line 74: | ||
* 找到這一行: port=3306, 修改成你想要的 port 例如 3307，儲存設定檔 | * 找到這一行: port=3306, 修改成你想要的 port 例如 3307，儲存設定檔 | ||
* 控制台 -> 系統管理工具 -> 服務：啟用 mysql 服務 | * 控制台 -> 系統管理工具 -> 服務：啟用 mysql 服務 | ||
<reference /> | |||
[[Category:Server]] | [[Category:Server]] | ||