I am having trouble connecting to MySQL using Connector/J 3.0. I have set up
a root user and password with host specified as localhost, and also a super
user and password with host specified as %. I can log into both of these
accounts with no trouble using mysql.
In my program, however, when I try to connect to MySQL as root with the
Yet when I use the same url to access the database as the super user I can
connect with no problems. I have a feeling that this is connected to the
host specified for each user, but I do not see why the root user is being
rejected as the MySQL database is being hosted on the local machine.
Any help or advice would be greatly appreciated.
Using Mandrake 8.1, MySQL 4.0.12, jdk 1.4.1 02, Connector/J 3.0