Page 1 of 1

cannot purge phpmyadmin and reinstall without errors

Posted: Sun Aug 04, 2019 4:50 pm
by 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

Re: cannot purge phpmyadmin and reinstall without errors

Posted: Mon Aug 05, 2019 9:39 am
by hyper
You can try this:
sudo apt purge phpmyadmin
followed by
sudo apt autoremove

Re: cannot purge phpmyadmin and reinstall without errors

Posted: Mon Aug 05, 2019 5:04 pm
by 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

Re: cannot purge phpmyadmin and reinstall without errors

Posted: Tue Aug 06, 2019 10:04 am
by 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 1485 times
phpmyadmin_info.png
phpmyadmin_info.png (74.77 KiB) Viewed 1485 times
Anyone know how to fix the errors??

R

Re: cannot purge phpmyadmin and reinstall without errors

Posted: Tue Aug 06, 2019 10:58 am
by 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.

Re: cannot purge phpmyadmin and reinstall without errors

Posted: Wed Aug 07, 2019 8:01 am
by 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

Re: cannot purge phpmyadmin and reinstall without errors

Posted: Thu Dec 26, 2019 6:26 pm
by 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!