Re: Trying to use command line interface - James Eaton - com.mysql.lists.win32

7 messages in com.mysql.lists.win32Re: Trying to use command line interface

From	Sent On	Attachments
James Eaton	17 Aug 2006 12:16
Jesper Hørup	17 Aug 2006 12:34
Bonnett, John	17 Aug 2006 16:07
Michael Louie Loria	17 Aug 2006 17:21
Joelle Tegwen	18 Aug 2006 13:57
James Eaton	18 Aug 2006 14:01
GP lisper	19 Aug 2006 06:39

Subject:	Re: Trying to use command line interface
From:	James Eaton (jj...@zolx.com)
Date:	08/18/2006 02:01:42 PM
List:	com.mysql.lists.win32

Thanks, all. That was indeed what was happening.

----- Original Message ----- From: "Jesper Hørup" <JH...@rtx.dk> To: <win...@lists.mysql.com> 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:jj...@zolx.com] Sent: 17. august 2006 21:17 To: win...@lists.mysql.com 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?