6 messages in com.mysql.lists.javaRe: General error: Access denied for ...
FromSent OnAttachments
Shekar Pasumarthi23 Jun 2004 11:18 
Mark Matthews23 Jun 2004 13:04 
Shekar Pasumarthi23 Jun 2004 13:15 
Mark Matthews23 Jun 2004 13:51 
Shekar Pasumarthi28 Jun 2004 13:58 
Harsh Jain28 Jun 2004 15:21 
Subject:Re: General error: Access denied for user: '@localhost' to database 'provision'
From:Mark Matthews (ma@mysql.com)
Date:06/23/2004 01:04:52 PM
List:com.mysql.lists.java

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Shekar Pasumarthi wrote:

My database name is 'provision'. I have installed mysql-4.0.20a-win.

Went to services and started the database and have a database creation java app which used to work fine with "mysql-max-3.23.49-win" install. I did not set any password for the root user. But I still get the above error on a fresh install. The java app has the database URL as

"jdbc:mysql:///ProVision?user%3Droot%26useUnicode%3dTRUE%26characterEncoding%3dUTF8";

Any hints why I getting this error would be great.

Mysql-4.0.20a-win shipped with bad grant tables. A new release is being built.

In any case, you might consider, for security's sake, _not_ using the default 'root' user, and create an appropriate one.

-Mark

- -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com

MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFA2eJ5tvXNTca6JD8RAnnZAKCJxQgGljwfanC8dt3Vf4G5DAFPWQCfRZbh u/+2SLrsBKxh+1ESVb3c+zI= =oaF4 -----END PGP SIGNATURE-----