After upgrading to 21, phpmyadmin and mysq not working

Questions about applications and software
Forum rules
Before you post read how to get help. Topics in this forum are automatically closed 6 months after creation.
Locked
shad-99
Level 1
Level 1
Posts: 1
Joined: Sun Mar 19, 2023 10:47 am

After upgrading to 21, phpmyadmin and mysq not working

Post by shad-99 »

i tried this guide to upgrade from 20.3 to 21!
and it worked like a charm! :P.. -Glad for that! -BUT!....
My apache server, phpmyadmin not working at all?.. -I finally found how to make this apache running.. and it did.. but not the phpmyadmin and mysql?
Is there away upgrading that will make all this webserver features to run smootly after an upgrade automatically or?

I really wanna upgrade.. but i had to go back with timeshift and restore everything.. and now my webserver works like a charm again!... -With 20.3.. until you solve this problem i wont upgrade to 21 :( -Thanks!
Last edited by LockBot on Tue Sep 19, 2023 10:00 pm, edited 1 time in total.
Reason: Topic automatically closed 6 months after creation. New replies are no longer allowed.
claude_andre
Level 1
Level 1
Posts: 13
Joined: Wed Oct 23, 2019 9:16 pm
Location: Australia

Re: After upgrading to 21, phpmyadmin and mysq not working

Post by claude_andre »

I also upgraded to LINUX MINT 21.1. Since then I cannot connect to "http://localhost/phpmyadmin/" get:
------------
Not Found
The requested URL was not found on this server.
Apache/2.4.52 (Ubuntu) Server at localhost Port 80
-------
mySql works fine,

Any suggestions
Thanks Claude
User avatar
kato181
Level 9
Level 9
Posts: 2564
Joined: Fri Mar 24, 2017 12:33 am
Location: Frederickton NSW

Re: After upgrading to 21, phpmyadmin and mysq not working

Post by kato181 »

claude_andre wrote: Thu Apr 06, 2023 12:11 am I also upgraded to LINUX MINT 21.1. Since then I cannot connect to "http://localhost/phpmyadmin/" get:
------------
Not Found
The requested URL was not found on this server.
Apache/2.4.52 (Ubuntu) Server at localhost Port 80
-------
mySql works fine,

Any suggestions
Thanks Claude
Please do not cross post, if you need help then create your own topic.
User avatar
coffee412
Level 8
Level 8
Posts: 2212
Joined: Mon Nov 12, 2012 7:38 pm
Location: I dont know
Contact:

Re: After upgrading to 21, phpmyadmin and mysq not working

Post by coffee412 »

shad-99 wrote: Sun Mar 19, 2023 11:11 am i tried this guide to upgrade from 20.3 to 21!
and it worked like a charm! :P.. -Glad for that! -BUT!....
My apache server, phpmyadmin not working at all?.. -I finally found how to make this apache running.. and it did.. but not the phpmyadmin and mysql?
Is there away upgrading that will make all this webserver features to run smootly after an upgrade automatically or?

I really wanna upgrade.. but i had to go back with timeshift and restore everything.. and now my webserver works like a charm again!... -With 20.3.. until you solve this problem i wont upgrade to 21 :( -Thanks!
You need to check your logs after the upgrade to 21 in apache and phpmyadmin. I would bet that after the upgrade apache2 it probably will be a php issue of some type - just from my experience. Check your logs for apache2 and post the errors. Or start apache2 manually and post the errors:

Code: Select all

sudo systemctl restart apache2
Then if it fails follow the instructions to see the error(s) and post them.
Ryzen x1800 Asus Prime x370-Pro 32 gigs Ram RX480 graphics
Dell PE T610, Dell PE T710
- List your hardware Profile: inxi -Fxpmrz
MeshCentral * Virtualbox * Debian * InvoiceNinja * NextCloud * Linux since kernel 2.0.36
claude_andre
Level 1
Level 1
Posts: 13
Joined: Wed Oct 23, 2019 9:16 pm
Location: Australia

Re: After upgrading to 21, phpmyadmin and mysq not working

Post by claude_andre »

Hi I checked the apache2 error log - No errors.
also check /etc/phpmyadmin/phpmyadmin.service:
-------
<?xml version="1.0" standalone='no'?>
<!DOCTYPE service-group SYSTEM "avahi-service.dtd">
<service-group>
<name replace-wildcards="yes">phpMyAdmin on %h</name>
<service>
<type>_http._tcp</type>
<port>80</port>
<txt-record>path=/phpmyadmin/</txt-record>
</service>
</service-group>
----
The port is still 80.
The only thing I did was to upgrade Linux Mint 20.03 to 21.1
Thanks
User avatar
kato181
Level 9
Level 9
Posts: 2564
Joined: Fri Mar 24, 2017 12:33 am
Location: Frederickton NSW

Re: After upgrading to 21, phpmyadmin and mysq not working

Post by kato181 »

You are upgrading from LM20.3 to LM21.1 should be done in steps LM20.3-->LM21-->LM21.1. But remember the files in LM20.3 are not necessarily compatible with LM21+ as it is based on Jammy and the packages will be different. jammy uses the latest version of python, and the old version of python no longer works with Jammy as far as I know, but I maybe wrong.
I would do a fresh install of LM21.1 then check to see if the problem still exists. Save your important files first of course.
claude_andre
Level 1
Level 1
Posts: 13
Joined: Wed Oct 23, 2019 9:16 pm
Location: Australia

Re: After upgrading to 21, phpmyadmin and mysq not working

Post by claude_andre »

Thanks;,
All sorted out; I decided to reinstall phpMyadmin. I had no issues whit mySql.
Kind regards
Claude
Locked

Return to “Software & Applications”