Apache Friends Support Forum

I can't seem to get all of my databases to be recognised from the command line. I am a novice with the CL interface but I want to learn

I do: mysql>show databases;

but it all come back with is:

Code: Select all

+---------+
|Databases|
+---------+
|test     |
+---------+

when there are really about 6-7 databases

Anyone have any idea?
Thank you.

Are you, perhaps, using a user name that does not have access to all databases?

Hmm, that is probably the answer. Whenever I try:

Code: Select all

\u <my_table>

I get the message:

Code: Select all

Error 1044 (42000): Access denied for user ''&'%' to database '<my_table>'

Whenever I open up mysql.exe it automatically logs me in, not sure how to relogin :\

Thanks.

go to start run type cmd hit enter

navigate to xampp\mysql\bin

If root doesnt have a password type:
mysql -u root and hit enter

if root has password type:
mysql -u root -p hit enter
enter password

then type:
SHOW DATABASES;