Cant locate my.cnf with marketplace phpmyadmin install.

Posted February 27, 2021
MySQL DigitalOcean 1-Click Apps Marketplace

I have installed PHPMyAdmin using the marketplace. Everything is really but I can’t seem to find the my.cnf file to set memory usage and other settings. I looked in a few places such as etc and MySQL but just can’t seem to find the file. Any help would be great.

Mutterz

Submit an answer

You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Lalitha • February 28, 2021

Hello @Mutterz ,

The default location is /etc/my.cnf or /etc/mysql/my.cnf

Please note that /etc/mysql/my.cnf file is not really a file but a symlink. If you want to make some changes to your MySQL variables, you need to make the change in the MySQL daemon config file located at /etc/mysql/mysql.conf.d/mysqld.cnf.

https://www.digitalocean.com/community/questions/assistance-with-mysql-my-cnf-file-preventing-mysql-from-starting?answer=63542

Hope that helps!

Cheers, Lalitha

Now Available: Managed MySQL Databases