Cant locate my.cnf with marketplace phpmyadmin install.

Posted February 27, 2021 231 views
MySQLDigitalOcean 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.

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.

Submit an Answer
1 answer

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.

Hope that helps!