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

[Mike Hillyer]

You didn't completely read the documentation you quoted:

> GRANT ALL PRIVILEGES ON [dbname].* to
> '[user]'@'[hostname]' identified by
> '[password]'
>
> replacing [dbname] with the name of your database, [user]
> with the user name, [hostname] with the host that MySQL
> Connector/J will be connecting from, and [password] with the
> password you want to use.

Note the quotes areound the username and the quotes around the host?

So the correct GRANT is:

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

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]

Blog: http://www.openwin.org/mike

"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine