-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
raffi@stripped wrote:
> Unfortunetly, creating the dwarves database first doesnt change the
> outcome. Also, the problem is deeper. If you do what the code says just
> using the mysql client, you get the same problem. Its not just a java
> thing.
>
> In other words... install a fresh mysql 4 and do this....
> mysql -u root
> mysql> create database dwarves;
> mysql> grant all privileges on *.* to doc identified by 'doc' with grant
> option;
> mysql> grant all privileges on *.* to doc@localhost identified by 'doc'
> with grant option;
> mysql> exit
>
> mysql -u doc -pdoc mysql
> mysql> grant all privileges on dwarves.* to dopey identified by 'dopey';
> Access denied for user: 'doc@stripped' to database 'dwarves'
>
>
>
> Here is what the mysql.user and mysql.db tables look like after the code
> is run...
Have you tried 4.0.8? It doesn't seem to have this issue:
- -----------------------------------------
C:\Documents and Settings\mmatthew>c:\mysql-4.0.8\bin\mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16 to server version: 4.0.8-gamma-max-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database dwarves;
Query OK, 1 row affected (0.25 sec)
mysql> grant all privileges on *.* to doc identified by 'doc' with grant
option;
Query OK, 0 rows affected (0.69 sec)
mysql> grant all privileges on *.* to doc@localhost identified by 'doc'
with gra
nt option;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
C:\Documents and Settings\mmatthew>c:\mysql-4.0.8\bin\mysql -u doc -pdoc
mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17 to server version: 4.0.8-gamma-max-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all privileges on dwarves.* to dopey identified by 'dopey';
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Bye
- -----------------------------------------
-Mark
- --
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <mark@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+HGYytvXNTca6JD8RAvXbAKCrZ2mOOKWX7cbg7db89ZL9FLTDRgCaAo8p
J2WwTdTFptlMMmF0NV2T8Dk=
=+Gq6
-----END PGP SIGNATURE-----
