Try

`mysql -u root -pmy\\\$qlPW -N -B -e 'show databases'`

I think that's right. Escape the $ so it doesn't get processed by the
current shell, escape the slash so it doesn't get processed, falls to \$
which then re-escapes the $ for passing into mysql as part of your password.

Nick is on to something as well, this should also work:

`mysql -u root -p 'my\$qlPW' -N -B -e 'show databases'`

Wes

On Wed, Apr 21, 2010 at 4:14 AM, Siju George <sgeorge...@gmail.com> wrote:

> Hi,
>
> mysql -u root -pmy\$qlPW -N -B -e 'show databases'
>
> gives the right output but
>
> `mysql -u root -pmy\$qlPW -N -B -e 'show databases'`
>
> gives
>
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
>
> I hope it is the escaping issue with $ inside ``?
>
> How do you do that?
>
> thanks
>
> --Siju
>
>
> --
> To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact
> listmas...@lists.debian.org
> Archive:
> http://lists.debian.org/r2vb713df2c1004210114gb50d1141k46180a717d795...@mail.gmail.com
>
>


-- 
Wesley W. Garland
Director, Product Development
PageMail, Inc.
+1 613 542 2787 x 102

Reply via email to