Re: Trying to use command line interface

Thanks, all.  That was indeed what was happening.


----- Original Message ----- 
From: "Jesper Hørup" <[email protected]>
To: <[email protected]>
Sent: Thursday, August 17, 2006 1:35 PM
Subject: RE: Trying to use command line interface


There must not be any spaces between -p and rootpassword.

You should write like this
...5.0\bin>mysql -u root -prootpassword

Otherwise MySQL prompts you for the root password, and assumes that the 
selected database is rootpassword, hence the error.

-----Original Message-----
From: James Eaton [mailto:[email protected]]
Sent: 17. august 2006 21:17
To: [email protected]
Subject: Trying to use command line interface

I'm running MySQL 5.0.24 as a service on Windows XP Pro.  I'm trying to
get into the command line environment and not having any luck.  Using:

...5.0\bin>mysql -u root -p rootpassword

I get another prompt for a password

Enter password: _

I enter the root password again, then I get the following error:

ERROR 1049 (42000): Unknown database 'rootpassword'

What am I doing wrong here?




-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]




-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]