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]