Permanently configure phpMyAdmin

Operating System & Version
CentOS 7.9 virtuozzo
cPanel & WHM Version
92.0.11

GoWilkes

Well-Known Member
Sep 26, 2006
692
33
178
cPanel Access Level
Root Administrator
I use mobile internet at home, but it changes my IP a few times a day. Every time it does, I have to log back in to PMA, then have to re-import settings from the browser's storage! It's very annoying.

After I do this, I see a message that says:

Your preferences will be saved for current session only. Storing them permanently requires phpMyAdmin configuration storage.

The link takes me to a page that I'm sure PMA thinks explains the process, but... no. LOL The link points to the docs on my server; I'm not sure the exact path, but it ends with:

/3rdparty/phpMyAdmin/doc/html/setup.html#linked-tables

The first thing it says is to go to ./sql, "where you should find a file called create_tables.sql". But neither the file nor the directory seem to exist on the server! :-/

Is there an easy way to just take what I've already configured and make it permanent? The changes I've made are really just cosmetic so I don't want to spend all day working on it.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
15,139
2,406
363
cPanel Access Level
Root Administrator
Hey there! The documentation it is referencing can be found in this path on your server:

Code:
/usr/local/cpanel/base/3rdparty/phpMyAdmin/doc/html/
The "create_tables.sql" can be found here:

Code:
/usr/local/cpanel/base/3rdparty/phpMyAdmin/sql
If you'd like an easier way to control that, I'd recommend submitting a feature request using the link in my signature to see if that is something we could get added to the cPanel & WHM interface.