How to change MySQL configuration

How to change MySQL configuration

This tutorial will show you how to make changes to MySQL configuration.

Go to AMPPS Control Panel

  • Open AMPPS Control Panel
MySQL-confchange-1

Open Configuration File

  • Click on Settings button on right side of MySQL
MySQL-confchange-2
  • Click on Configuration button which appears after you click on the Settings button
MySQL-confchange-3
  • Click on MySQL.conf and the configuration file will open in a text editor 
MySQL-confchange-4

Make Changes to Configuration File

  • You can make changes in configuration file for example myisam_sort_buffer_size changed from 6M to 8M and save the file
MySQL-confchange-6
  • After saving configuration file you will see the message "MySQL Configuration Changed" in the AMPPS control center

Restart MySQL

Note :  Do not forget to restart MySQL for the changes to take effect.
If you face issues please open a support ticket.
    Was this page helpful?