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?

      Download AMPPS

      Subscribe to our Newsletter for any and all AMPPS related news and tutorials
      By entering your email, you agree to our Terms of Service and Privacy Policy.

      Tell your Friends about AMPPS


      Newsletter Subscription
      Subscribing you to the mailing list