Question

Not able to access my phpmyadmin in ubuntu droplet

Hey few months ago i created one ubuntu droplet, setup well , and all running well. I used serverpilot to install wordpress

now when i try to access my phpmyadmin, this error i get: error in processing request error code 403 error text forbidden

as well as last two lines in phpmyadmin shows this: A newer version of phpMyAdmin is available and you should consider upgrading. The newest version is 4.6.5.2, released on 2016-12-05. The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. Or alternately go to ‘Operations’ tab of any database to set it up there.

when i click on findout why, this is what it says: Configuration of pmadb… not OKDocumentation General relation features Disabled Create a database named ‘phpmyadmin’ and setup the phpMyAdmin configuration storage there.

someone can help me please


Submit an answer

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

@hostmanager1yakin

phpMyAdmin is simply a web-based interface to MySQL, as is Adminer. The difference is that Adminer is a single file whereas phpMyAdmin is hundreds of files. Neither have anything to do with WordPress, will effect your WordPress installation, or even your web server software. They are both PHP scripts used to access MySQL or other database types from a web-based interface :-). Without them, the only way to access your database would be through the Command Line Interface.

What you’d do here is download the adminer.php file from the website referenced and drop it in to a public directory, such as ./public, ./public_html or wherever your public directory is located (i.e. the one where WordPress’ index.php file resides).

You would then use your browser to navigate to http://yoursite.ext/adminer.php (for example) and then login with your database credentials to access your database.

For security purposes, renaming adminer.php to something random that only you know would be the most preferred method of usage as adminer.php is a common file name since it’s a well known script, thus bots do scan for that file and if found, will attempt to brute-force their way in (similar to how the same happens to ./wp-admin on WordPress installations unless you lock it down).

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

@hostmanager1yakin

For you to be able to access it over the web, the file will need to be public, which is why I recommend renaming it to something a little more random, such as x4Gd90.php, then simply create a bookmark to the file in your bookmark bar. This negates the need for you to type it in manually.

That said, I would really recommend only uploading the file when you really need to access your DB from the web and then delete it when you’re done.

@hostmanager1yakin

Unless you’re attached to something specific that phpMyAdmin offers, I would recommend Adminer.

Adminer is a single-file that can be dropped anywhere and accessed like any other PHP file. It works much like phpMyAdmin without all the complexities. It also saves you the hassle of having to lock down and secure another location to prevent attempted unauthorized access as you can simply delete the file when you’re done and upload it when you need it.

https://www.adminer.org

If you’re set on using phpMyAdmin, deleting the configuration file and then going through the setup process as if it were a fresh installation should fix any unresolved issues. I would, however, suggest upgrading to the latest version for security purposes.

How you go about this really depends on how you set it up. Was it installed by you or during the setup portion with ServerPilot? If by you, all you’d need to do is download the new version and upload those files over the existing ones and then run the setup again.

thats great and sweet of you @jtittle

can i now delete phpmyadmin folder inside public root.

if i do that, will i loose any database?