cannot purge phpmyadmin and reinstall without errors

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: gesf, Michalio

Post Reply
pizzipie

I run ubuntu 18.04

When installing LAMP I didn't set the root PW for mariaDB. I corrected this so I can now run mysql -u root -p and enter the root PW. On installing Version information: 4.6.6deb5 I got a bunch of errors which I found out could only be corrected by updating phpmyadmin. Long story shorter I messed up a bunch of stuff.

Currently I re-installed 4.6.6 using Synaptic. I had to use 'abort' during that installation because of errors. the following is from the opening page of phpmysql.

Database server

Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 10.1.40-MariaDB-0ubuntu0.18.04.1 - Ubuntu 18.04
Protocol version: 10
User: rick@localhost
Server charset: UTF-8 Unicode (utf8)

Web server

Apache/2.4.29 (Ubuntu)
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.2.19-0ubuntu0.18.04.1

phpMyAdmin

Version information: 4.6.6deb5

=============== HERE ARE THE ERRORS SHOWN AT THE BOTTOM OF THE PAGE =================

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.
Open new phpMyAdmin window
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.
What I want to do is have a working copy of phpmyadmin 4.09. It seems the config things are hidden all over and I can't rid if them!!!

Thanks for your help in advance.

R
hyper

You can try this:
sudo apt purge phpmyadmin
followed by
sudo apt autoremove
pizzipie

Thanks for your reply,

I have done this, but upon re-installing get all the errors. There seems to be some configuration files that are still messing things up. What I'm truing to get is an installation like the original one.

R
pizzipie

define phpmyadmin=P

Well I tried the purge and auto removal of P4.6.6 and updated with P4.9.0.1 per instructions here:
tecadmin.net/manually-upgrade-phpmyadmin-ubuntu/

I also loaded the P database into mysql since it wasn't in the databases.

When I run P4.9.0.1 now, see attachments; Errors and Info'
phpmyadmin_screen.png
phpmyadmin_screen.png (225.38 KiB) Viewed 6358 times
phpmyadmin_info.png
phpmyadmin_info.png (74.77 KiB) Viewed 6358 times
Anyone know how to fix the errors??

R
hyper

It's a PHP warning, phpMyAdmin is doing something that it will not be able to in a future PHP version - I don't know which version. You might not find any problems at the moment, I don't use it so can't help any further - sorry.
pizzipie

Thanks for the reply.

Just had a thought,: Found out that phpmyadmin uses cookies. I am going to try and get rid of the cookies and see what happens.

R
rabbit93

I know this thread is a little old but i thought i would throw my two cents worth in real quick. I noticed that you said you are using a LAMP stack. LAMP Stacks are notorious for messing things up as they pretty much control the entirety of your server as an AIO solution. Because of this your phpmyadmin will be difficult to purge as your mysql, or mariadb, or mongo (which ever one you are using) will be monitored and pretty much controlled by the LAMP stack. I would suggest (i do this myself) Installing everything manually rather than using a stack. It is harder work and more time consuming but well worth it in the end and it gives you a great sense of accomplishment. Then purging phpmyadmin is as simple as deleting the directory, purging mysql, then readding the directory. *CAUTION* Purging mysql will also delete any databases and tables that you have created. Always backup your data!
Post Reply