mysql command line

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql command line

Postby virtual » 11. May 2006 11:50

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.
virtual
 
Posts: 6
Joined: 11. May 2006 10:56

Postby taustin » 11. May 2006 18:48

Are you, perhaps, using a user name that does not have access to all databases?
taustin
 
Posts: 150
Joined: 24. September 2004 00:23
Location: Huntington Beach CA

Postby virtual » 18. May 2006 10:45

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.
virtual
 
Posts: 6
Joined: 11. May 2006 10:56

Postby WorldDrknss » 18. May 2006 20:50

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;
http://wdguides.org - XAMPP Tutorials & MORE!!!!
User avatar
WorldDrknss
 
Posts: 292
Joined: 17. September 2005 13:40


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 119 guests