Local Server Installation

Install XAMPP

Steps to Install XAMPP for Mac OS:

1. Open the XAMPP control panel to manage the localhost server.
2. Click Open Application Folder in the XAMPP control panel.
3. In the application folder, open the etc folder and locate the my.cnf file where MySQL settings are stored.
4. Right-click on the my.cnf file to open it in a Text Editor.

Configuration Changes

5. In the Text Editor:
   • Find max_allowed_packet and set it to 100M to allow a maximum data size of 100M sent to the MySQL server.
   • Find wait_timeout and extend the MySQL connection idle time to 3000.
6. Save the modified my.cnf file, then return to the XAMPP control panel and restart the server.

Install XAMPP

Steps to Install XAMPP for Windows OS:

1. Open the XAMPP Control Panel.
2. Click Config in the Apache section. This allows you to manage the Apache server.
3. In the Apache section, select PHP (php.ini).
4. In the php.ini file:
   • Find max_execution_time and increase its value to max_execution_time=3000 for extended execution time.
   • Find extension=gd. Remove the semicolon (;) at the beginning of the line to enable the GD extension, which is necessary for image processing in PHP.

Configure MySQL

5. Click Config in the MySQL section.
6. Open the my.ini file, which controls MySQL database settings.
7. In the my.ini file:
   • Find max_allowed_packet and set it to 100M to handle larger data packets.

Apply Changes

8. After making these changes in both Apache and MySQL, restart XAMPP to apply the configurations.

Install LAMP (Linux, Apache, MySQL, PHP)

Steps to Install LAMP for Ubuntu OS:

1. After installing LAMP, open the PHP configuration file in a text editor. By default, this file is located at /etc/php/8.2/fpm/php.ini.

2. In the php.ini file, find the following keys and increase their values as shown:

   • max_execution_time = 3000 (from the default of 30)
   • max_input_time = 3000 (from the default of 30)
   • memory_limit = 100M (from the default of 16M)
   • post_max_size = 100M (from the default of 2M)
   • upload_max_filesize = 100M (from the default of 2M)

3. Save the php.ini file after making these changes.

Restart Apache

4. Restart the Apache server to apply the changes by running the following command:

sudo systemctl restart apache2