Not able to access my phpmyadmin in ubuntu droplet

Question

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

Jonathan Tittle · Accepted Answer

@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).

hostmanager1yakin · Answer

@jtittle

I don’t know much about technicalities.

See I have a running site. If I change database to admirer or upgrade the phpmyadmin , will I not loose anything on my current site?

Current site is on wordpress and was setup via serverpilot…

Jonathan Tittle · Answer

@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.

Report this

Not able to access my phpmyadmin in ubuntu droplet

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today