RE: Trying to use command line interface
"Bonnett, John" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
When you give the password on the command line, the password must start immediately after the "p" Mysql -u root -prootpassword <dbname> If the password is not given immediately after the "p", that signals that you want to enter the password interactively, as you have found. The password left on the command line then becomes interpretted as the database name, as you have also found. HTH John B. -----Original Message----- From: James Eaton [mailto:[email protected]] Sent: Friday, 18 August 2006 4:47 AM 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]