mySQL noob can't see databases in db table

[TruthInSatire]

Shouldn't I be able to see all the databases in the mySql.db table?

The problems I'm having are:

1) the php my admin interface stopped working (1045 access denied for user 'pma'@ 'localhost' bla bla)

2) I can not find a pma user in the mysql.user table

3) i can only see 3 databases in mysql.db There are about 6 i think. the websites are running so i know the databases are SOMEWHERE, but i can't find them.

Any ideas?

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[guelphdad]

Log in to mysql as root. can you see them now?

please post the entire error message you get. blah, blah, blah tells us nothing. Yes the entire error message can mean different things if you have different endings to the message.

are you using xampp or something? IIRC pma is the default user they set up.

if you are using phpmyadmin is it on a shared host? if so do you have cpanel or something you can use to access the databases too?

 

[TonyGroves]

mysql.db would only contain entries for those databases for which you wanted different access restrictions from the default. To list your databases, issue the SQL command "SHOW DATABASES".

If a particular username does not match any entry in the mysql.user table, then no connection by that username would be accepted. If you want to add a user to the table, you can do it using SQL or an administration interface.

 

[TruthInSatire]

thanks, the bla bla bla was my password which i'm not showing you, that was the entire error message.

I did try the select * from db as the "root" user.

show databases did work however.

I didn't set up this system to know much about it, but yes the site is in an xampp folder.

Why would the pma user not work anymore?



We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[TruthInSatire]

so would reinstalling phpMyAdmin be the best way to go or is there an easy way to bring the pma user back to life? Thanks again for the help.

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.