MySQL Connector/J Documentation. Error in readme?
Hi,
I'm reading the readme from MySQL Connector/J Documentation and it contains the following:
> 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.
so I tried the following;
mysql> GRANT ALL PRIVILEGES ON test.* to 'tom@localhost' identified by 'toms_pw';
but this command creates a username "tom@localhost", not "tom" and thus i was getting the following error message when trying to login:
SQLException: Invalid authorization specification, message from server: "Access denied for user: 'tom@localhost' (Using password: YES)"
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".
you can see the difference:
mysql> SELECT Host,User,Password FROM mysql.user;
+-----------+------------------+------------------+
| Host | User | Password |
+-----------+------------------+------------------+
| localhost | root | |
| build | root | |
| localhost | | |
| build | | |
| % | tom@localhost | 3f59413a4bbb0e0f |
| localhost | tom | 3f59413a4bbb0e0f |
+-----------+------------------+------------------+
Am I on the right track here? should the readme command be:
GRANT ALL PRIVILEGES ON [dbname].* to
[user]'@'[hostname] identified by
'[password]'
Subject
Views
Written By
Posted
MySQL Connector/J Documentation. Error in readme?
4336
August 10, 2004 02:17AM
2649
August 10, 2004 07:34AM
2879
October 18, 2004 09:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.