Control Web Panel

WebPanel => MySQL => Topic started by: dorkfiles on August 08, 2019, 04:17:11 PM

Title: CWPpro No Database listed shows -1
Post by: dorkfiles on August 08, 2019, 04:17:11 PM
Hi there,

Just noticed on my CWP panel there is no access to mysql on the front end

Here are some screenshots to show what i mean

From the main panel you can note the database count is -1 this is not true as there are at least 30
https://prnt.sc/oq4zoc

If I click the -1 database which brings me to mysql manager this is what i see
http://prntscr.com/oq50pq

Now on the tuner its telling me this

Quote
>>  MySQLTuner 1.7.9 - Major Hayden
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[!!] Attempted to use login credentials, but they were invalid.

I'm not sure what happened, i know that yum updated mariadb and thats all i know.

Any help or suggestions would be really great.

P.S phpmyadmin works fine.
Title: Re: CWPpro No Database listed shows -1
Post by: dorkfiles on August 10, 2019, 01:49:59 AM
Not sure why it didnt display but i ended up changing the root password and went through a undesired hell.

In any case i did solve it check this out https://stackoverflow.com/questions/28068155/access-denied-for-user-rootlocalhost-using-password-yes-after-new-instal/35748657#35748657