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

Subscribe
Share

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

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

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

@jtittle @jsamuelsp I installed adminer-myword.php with my domain, and all worked… now question is, just putting this file directly in my public folder is unsafe?

any better way to place file somewhere else to make it safer?

and shall i delete phpmyadmin folder from my root /public which i used earlier?

@jtittle i am afraid, as if i put admirer.php in working, can i delete the phpmyadim-myspecialword folder entirelly… do i not loose any database inside it? Can you privately help on it, on skype?

@jtittle so I need to first delete all the phpmyadmin files and then upload admirer.php file?

And upload database again in admirer?

Or is there any way just to solve the phpmyadmin problem I stated above because I need to back up the database mysql first

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