Re: MySQL Connector/J Documentation. Error in readme?

[Nick Roper]

donal kelly wrote:
> Hi,
>
> should the command be: (removing the apostrophe
> around the username)
> mysql> GRANT ALL PRIVILEGES ON test.* to
> tom@localhost identified by 'toms_pw';
> which creates a username "tom".
>


Yup, or

mysql> GRANT ALL PRIVILEGES ON test.* to 'tom'@'localhost' identified by 'toms_pw';

i.e. if you quote the user name and/or password then do them separately. You only need to use quotes for names that include special characters, but using them for names that don't need them is perfectly acceptable.



--
Nick Roper