Cannot Access Database After Update 2.0.3

do

donnebanget Oct 05, 2020 #1

Hello,
After update to 2.0.3, i can’t access my database on phpmyadmin via auto login.

OS : Ubuntu 20.04

It just showing 1 database “information_schema” with user admin@localhost.

When i access via ssh with root that show all database.

How can i access phpmyadmin with other user like last before update?

Thanks…

ck

ckeeper Oct 09, 2020 #2

Same issue with ubuntu 20 using cp 2.0.3 updated from 2.0.3dev version, looks like adding skip grant tables fix this issue partially, you still can not see all the databases but just the main mysql and performance schema. Something broke from 2.0.3-dev to stable version. Thanks

kl

klasekp Oct 12, 2020 #3

This helped me (for MariaDB) How To Reset Your MySQL or MariaDB Root Password | DigitalOcean

Za

Zalcig Oct 13, 2020 #4

check here I shared how I fixed it