On Wed, Apr 21, 2010 at 01:44:33PM +0530, Siju George 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 ``?
>
When using single quotes ('), everything in the string is literal, so no escaping is required. You only need escaping when using double quotes (").
Attachment:
signature.asc
Description: Digital signature