[SOLVED] How to rerun the phpmyadmin setup script?

Pedroski · 11-04-2023, 06:29 AM

I have a Ubuntu 22.04 cloud server. I want to set up phpmyadmin.

I followed the steps here at Digital Ocean but missed the Warning "hit SPACE":

Quote:

Warning: When the prompt appears, “apache2” is highlighted, but not selected. If you do not hit SPACE to select Apache, the installer will not move the necessary files during installation. Hit SPACE, TAB, and then ENTER to select Apache.

I tried to install again using:

Quote:

sudo apt reinstall phpmyadmin php-mbstring php-zip php-gd php-json php-curl

But the setup script does not start in this case.

I do not see phpmyadmin after entering

Quote:

SELECT user,authentication_string,plugin,host FROM mysql.user;

on the mysql command line

Quote:

mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
| user | authentication_string | plugin | host |
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
| debian-sys-maint | $A$005$[IJp1p:#5w{a^"Sm`2;3p6GG3IOsp9Hqc4U4DwyEojoszPAQqGAD56HjJD6mE8 | caching_sha2_password | localhost |
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
| mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
| mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
| pedro | $A$005$_G8L R �%�*b#W?M+8nqHA91BpNt3CPao7uro61RU92vqoXLi4QWEK15A5T8 | caching_sha2_password | localhost |
| root | | auth_socket | localhost |
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
6 rows in set (0.02 sec)

mysql>

Not sure what I should do now. Apache2 is not linked to phpmyadmin, I think.

Any tips please??

uteck · 11-05-2023, 05:27 PM

Code:

dpkg-reconfigure phpmyadmin

Pedroski · 11-07-2023, 03:55 AM

Thanks, that restarted the set up, at least partially.

But I still don't have phpmyadmin in mysql:

Quote:

pedro@ubuntu:~$ sudo mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 8.0.35-0ubuntu0.22.04.1 (Ubuntu)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
| user | authentication_string | plugin | host |
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
| debian-sys-maint | $A$005$[IJp1p:#5w{a^"Sm`2;3p6GG3IOsp9Hqc4U4DwyEojoszPAQqGAD56HjJD6mE8 | caching_sha2_password | localhost |
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
| mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
| mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
| pedro | $A$005$_G8L R �%�*b#W?M+8nqHA91BpNt3CPao7uro61RU92vqoXLi4QWEK15A5T8 | caching_sha2_password | localhost |
| root | | auth_socket | localhost |
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
6 rows in set (0.00 sec)

mysql>

Maybe I need to run dbconfig-common? That didn't start automatically after:

Quote:

dpkg-reconfigure phpmyadmin

Now where would that be??

I find:

Quote:

pedro@ubuntu:~$ dbconfig-common
dbconfig-common: command not found
pedro@ubuntu:~$ whereis dbconfig-common
dbconfig-common: /etc/dbconfig-common /usr/share/dbconfig-common
pedro@ubuntu:~$ ls -l /etc/dbconfig-common
total 8
-rw------- 1 root root 484 Nov 4 06:08 config
-rw------- 1 root root 3004 Nov 4 06:13 phpmyadmin.conf
pedro@ubuntu:~$ ls -l /usr/share/dbconfig-common
total 16
drwxr-xr-x 3 root root 4096 Nov 4 06:08 data
drwxr-xr-x 2 root root 4096 Nov 4 06:08 dpkg
drwxr-xr-x 2 root root 4096 Nov 4 06:08 internal
drwxr-xr-x 3 root root 4096 Nov 4 06:08 scripts
pedro@ubuntu:~$

uteck · 11-07-2023, 09:07 AM

Maybe this will help? https://docs.phpmyadmin.net/en/latest/setup.html

Pedroski · 11-07-2023, 11:28 AM

@uteck

Thanks for your help!

I got there in the end!

I did this:

sudo apt-get remove phpmyadmin
sudo apt-get purge phpmyadmin
sudo apt-get autoremove

Then I followed the instructions from digitalocean again, more carefully.

MySQL or phpMyAdmin, or both are a bit fussy about passwords. I had to retry and enter a more secure password.

Now I can login to my database from the browser normally. In fact, what I had already set up was still there!