cannot purge phpmyadmin and reinstall without errors

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

Moderators: egami, macek, gesf

Post Reply
pizzipie
New php-forum User
New php-forum User
Posts: 4
Joined: Sun Aug 04, 2019 4:10 pm

Sun Aug 04, 2019 4:50 pm

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

User avatar
hyper
php-forum Fan User
php-forum Fan User
Posts: 845
Joined: Mon Feb 22, 2016 5:52 pm

Mon Aug 05, 2019 9:39 am

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

pizzipie
New php-forum User
New php-forum User
Posts: 4
Joined: Sun Aug 04, 2019 4:10 pm

Mon Aug 05, 2019 5:04 pm

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
New php-forum User
New php-forum User
Posts: 4
Joined: Sun Aug 04, 2019 4:10 pm

Tue Aug 06, 2019 10:04 am

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:
https://tecadmin.net/manually-upgrade-p ... in-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 643 times
phpmyadmin_info.png
phpmyadmin_info.png (74.77 KiB) Viewed 643 times
Anyone know how to fix the errors??

R

User avatar
hyper
php-forum Fan User
php-forum Fan User
Posts: 845
Joined: Mon Feb 22, 2016 5:52 pm

Tue Aug 06, 2019 10:58 am

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
New php-forum User
New php-forum User
Posts: 4
Joined: Sun Aug 04, 2019 4:10 pm

Wed Aug 07, 2019 8:01 am

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

Post Reply