XAMPP: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
|||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[http://www.apachefriends.org/en/xampp.html XAMPP](all old version and latest version of XAMPP [http://sourceforge.net/projects/xampp/files/ files]) | [http://www.apachefriends.org/en/xampp.html XAMPP](all old version and latest version of XAMPP [http://sourceforge.net/projects/xampp/files/ files]) | ||
== installation == | |||
{{Software version| software=XAMPP | url=http://www.apachefriends.org/en/xampp.html | version=5.6.3}} | |||
# Download the [https://www.apachefriends.org/index.html XAMPP Installers] and install | |||
# Configure the Windows {{kbd | key=PATH}} if you want to run the PHP script from command line ([[How to setup my system path]]). And(replace the {{kbd | key=X}} to other folder where XAMPP installed)<ref>[http://stackoverflow.com/questions/10753024/how-to-access-the-command-line-for-xampp-on-windows php - how to access the command line for xampp on windows - Stack Overflow]</ref><pre>;X:\xampp\mysql\bin;X:\xampp\php;</pre> | |||
# Restart the command line window to make sure the {{kbd | key=PATH}} updated! | |||
== Roll back to the old version of [http://www.mysql.com/ MySQL] at XAMPP == | == Roll back to the old version of [http://www.mysql.com/ MySQL] at XAMPP == | ||
| Line 25: | Line 31: | ||
Server=C:/mysql_old/bin/mysqld-nt.exe | Server=C:/mysql_old/bin/mysqld-nt.exe | ||
</pre> | </pre> | ||
==== Modify the path of MySQL service ==== | ==== Modify the path of MySQL service ==== | ||
| Line 32: | Line 39: | ||
restart the MySQL service | restart the MySQL service | ||
== PHP path == | |||
* on {{Mac}} {{kbd | key=<nowiki>/Applications/xampp/bin/php</nowiki>}} | |||
<pre> | |||
# How to verify the PHP path | |||
% /Applications/xampp/bin/php --version | |||
PHP 8.1.17 (cli) (built: Apr 6 2023 05:03:43) (NTS) | |||
Copyright (c) The PHP Group | |||
Zend Engine v4.1.17, Copyright (c) Zend Technologies | |||
</pre> | |||
== Troubleshottings == | == Troubleshottings == | ||
| Line 53: | Line 71: | ||
restart the MySQL service | |||
== 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 服務 | |||
== References == | |||
<references/> | |||
[[Category:Server]] | [[Category:Server]] | ||
[[Category:Web server software]] | |||