Installing an AMP Package

Starting and stopping servers

To start a specific server, click the Start button next to it.

By default, none of the servers such as Apache or MySQL are installed as Windows Services. This means that whenever we want to make use of these servers, we have to manually start them through the XAMPP Control Panel. When a server runs as a Windows Service, it with Windows automatically.

To run a specific server as a Windows Service

1. Open the XAMPP Control Panel as an administrator.

2. Stop the server you want to install as a Windows Service by clicking the Stop button.

3. Click X next to the server and confirm the service installation. Once the installation succeeds, a green checkmark will be displayed next to the server, indicating the server is now running as a Windows Service.

   

Integrating the PHP executable

Let's start by registering the PHP executable from XAMPP in IntelliJ IDEA. In the Settings/Preferences dialog (Ctrl+Alt+S), navigate to Languages & Frameworks | PHP.

With IntelliJ IDEA, we can have several separate PHP interpreters registered in the IDE, depending on the PHP version or PHP configuration needed for the project. All currently registered installations of PHP interpreters are displayed in the CLI Interpreter list:

To add the interpreter installed with XAMPP

1. Click to the right of the list. The CLI Interpreters dialog opens.

2. In the left-hand pane, click the button on the toolbar.

3. In the Name field, type the name to identify the current installation, for example XAMPP PHP 7.2.

4. In the PHP Executable field, specify the folder where the php (PHP executable) file is stored. Either enter the path manually or click and locate the file.

5. IntelliJ IDEA checks whether the specified folder contains a PHP executable file, detects the PHP version, and displays it in the PHP Info read-only field. IntelliJ IDEA also validates that the debugger is configured correctly.

   

We can now save these settings and select the newly added PHP interpreter for our project:

IntelliJ IDEA will now use the PHP installation that was bundled with MAMP.

Integrating the debugger

IntelliJ IDEA offers a powerful debugger in which breakpoints can be set and variables can be inspected at runtime.

Once you have installed and configured the debugger, you can validate your debugging configuration by performing the steps described in Validating the Configuration of a Debugging Engine.

Integrating the Apache server

Interaction between IntelliJ IDEA with Web, FTP, and other servers is handled by the Remote Hosts Access plugin, which is enabled by default. The IDE accesses servers using the connection settings specified in the registered server access configurations.

To create and manage server access configurations

1. In the Settings/Preferences dialog (Ctrl+Alt+S), click Deployment under Build, Execution, Deployment.

   

2. Click the on the toolbar to add a new server. In the Add Server dialog that opens, specify a name for the XAMPP server and select the deployment type. For the XAMPP Apache server, select the Local or mounted folder type.

   

3. After clicking OK, we can specify the path of the Apache's web root (C:\xampp\htdocs) and the URL of the web server, http://localhost. Note that the actual settings depend on how you have configured the XAMPP Apache server through the C:\xampp\apache\conf\httpd.conf configuration file.

   

   Don't forget to mark the server as default by clicking , so that IntelliJ IDEA uses it with browser integration instead of the built-in web server.

   By clicking Open, we can open the MAMP htdocs folder in the browser and thus verify that the provided settings are correct.

Integrating the MySQL server

IntelliJ IDEA allows to connect to the XAMPP MySQL database server using the Database Tools and SQL plugin, which is installed and enabled by default. Before you start, make sure that the MySQL server is running on the XAMPP Control Panel.

From the right-hand side of the IDE, open the Database tool window.

Here, we can create a new connection or Data Source by using the context menu or the toolbar button. We need to specify the JDBC database driver that will be used to connect to our database. For MySQL, we can use the MySQL Connector driver available in the list of drivers. IntelliJ IDEA doesn't ship these drivers but we can download the correct JDBC driver by clicking link.

Next, we need to enter the connection details. Alternatively, we can provide the connection string to the MySQL Database in the Database URL field, for example jdbc:mysql://localhost:3306/ or jdbc:mysql://localhost:3306/foodb to connect to the foodb database.

Note that it is recommended to change the default MySQL username and password after installing XAMPP, which can be done on the http://localhost/security/xamppsecurity.php page.

We can also specify the username and password for MySQL. By default, XAMPP uses root as the user name, and a blank password.

When using UTF-8 or unicode characters in the username, password or database name, two additional parameters must be added to the connection string: characterEncoding and useUnicode. An example connection string would be jdbc:mysql://localhost:8889?characterEncoding=utf8&useUnicode=true. It may also be required to select a different JDBC driver from the list, that is, com.mysql.jdbc.NonRegisteringDriver.

Having defined the data source, click the Test Connection button to verify the settings and make sure IntelliJ IDEA can connect to MySQL.

We can now create tables, run queries, update data and so on. See Databases and SQL for more information.