Editing XAMPP (section)

== change the MySQL port ==
For AppServ or MySQL Server 5.6
* 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 <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 <ref>x:\AppServ\MySQL\bin\mysqld-nt --defaults-file=x:\AppServ\MySQL\my.ini mysql</ref>
* 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
* (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.



AppServ 修改 MySQL 的 port
* Windows: 控制台 -> 系統管理工具 -> 服務：停用 mysql 服務
* 修改 MySQL 設定檔，檔案位置 For AppServ v.2.5.10: x:\AppServ\MySQL\my.ini
* 找到這一行: port=3306, 修改成你想要的 port 例如 3307，儲存設定檔
* 控制台 -> 系統管理工具 -> 服務：啟用 mysql 服務