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/win32?unsub=gcdmw-win32@m.gmane.org

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]=20
Sent: 17. august 2006 21:17
To: win32@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=20
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?




--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Djhn@rtx.dk


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: Trying to use command line interface

When you give the password on the command line, the password must start
immediately after the "p"

Mysql -u root -prootpassword

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:jj@zolx.com]=20
Sent: Friday, 18 August 2006 4:47 AM
To: win32@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?





--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Trying to use command line interface

--------------enig5AD91CFF7B0B02161CB78FF9
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

> I'm running MySQL 5.0.24 as a service on Windows XP Pro. I'm trying o
> 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 -u root -p
Enter password:

Do not type the password yet after the -p switch


--------------enig5AD91CFF7B0B02161CB78FF9
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBROUIPLXBHi2y3jwfAQojHgf6Atk7wRkLuBsneLZNjEcAODX85uCT JJBO
IrTqBuJy/Ot6EzaIYsQDUOB5nZoBjp//3yvk+6TH0ZkjecxLeEc/KJONmUw0 fn+x
AbP13B6BXTZzUDldjjb/yvXi/rMFog1Zh7qrqN06ZIogZLF1Zoj6pIF0L1JU Xnb7
c+lw+aHtIguP4+A5SpdoSVcruN9QEpTY/h5NsFZIVcPMZU+WQN3djzaPUAki 2Hkv
lusXu8Lx4FQQDJJFdiJhQnu8zuc+XyIsUvBUAEMVVyhRw6YpxUbORCSUNUKq glHs
O7P86muPk+FgRHsGypOjtWq6e97X/DOoyf+ziW/4JEODKyuxCQ43uA==
=jmPQ
-----END PGP SIGNATURE-----

--------------enig5AD91CFF7B0B02161CB78FF9--

Re: Trying to use command line interface

I would not enter the password on the first command because then it's
displayed in clear text.

Just type
mysql -u root -p

and then you'll be prompted for the password.

HTH
Joelle

James Eaton wrote:
> 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/win32?unsub=gcdmw-win32@m.gmane.org

Re: Trying to use command line interface

Thanks, all. That was indeed what was happening.


----- Original Message -----
From: "Jesper Hørup"
To:
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: win32@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?




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=jhn@rtx.dk


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=jj@zolx.com




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Trying to use command line interface

On Thu, 17 Aug 2006 13:16:36 -0600, wrote:
> 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

the proper syntax is

>mysql -u root --password=rootpassword


--
Reply-To email is ignored.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org