CODEWITHSUNDEEP
mysqlphpmyadminjelastic
Marcos Buarque
Marcos Buarque

Reputation: 3418

Change phpmyadmin settings in Jelastic MySQL

I need to change the phpmyadmin settings in my Jelastic MySQL install. The issue is that phpmyadmin is in /var/lib/phpMyAdmin and I don't have access into that folder and thus cannot change its configuration file. When I enter the MySQL host in my Jelastic structure I can't see the base folder and navigate to them. The folders available through config feature in Jelastic or FTP are "cron", "scripts", "keys", "conf.d", "etc", "backup".

Folder "conf.d" has the file "phpMyAdmin-jel.conf" but it won't allow me to change any phpmyadmin settings.

Upvotes: 1

Views: 641

Answers (1)

Damien - Layershift
Damien - Layershift

Reputation: 1528

It's true that this part of the default Jelastic MySQL / MariaDB templates should be improved; users should be given access to modify this part of the conf in future (even better, more appropriate default configs should be set).

But in the meantime a better way to approach this would be to upload the file via SSH (scp) as described in the documentation here: http://docs.jelastic.com/ssh-access#direct-access

After adding your public SSH key in the Jelastic dashboard, you can SSH directly to any node in your environment (even without any public IP) using this format:

ssh {nodeid}-{uid}@{SSH_gateway} -p 3022

After the file transfer is complete you can just import it directly on the command line, using the mysql command.

Upvotes: 1

Related Questions