wuhLinkAccessMySql::getLinks unable to create or execute statement
when I select MySQL from the Remote side of the GUI...but I can use the mysql client to log in with the same information.
Any ideas?
java version "1.4.1_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_01-99)
Java HotSpot(TM) Client VM (build 1.4.1_01-27, mixed mode)
mysql-connector-java-3.0.9-stable-bin.jar
Mac OS X v10.3.2
proc_type: powerpc
os_name: Darwin
os_release: 7.2.0
os_version: Darwin Kernel Version 7.2.0: Thu Dec 11 16:20:23 PST 2003; root:xnu/xnu-517.3.7.obj~1/RELEASE_PPC
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is a bug in release 0.2 that wouldn't allow you to open the MySQL view if there was no table or no links, which is fixed in the 0.3 release.
If you have the 0.3 release, then make sure you have CREATE, DROP, SELECT and INSERT permissions on your MySQL table. These are the only permissions currently needed for MySQL access.
Hope this helps, as don't have a Mac to test on!
Cheers,
Warren
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I get the following error:
wuhLinkAccessMySql::getLinks unable to create or execute statement
when I select MySQL from the Remote side of the GUI...but I can use the mysql client to log in with the same information.
Any ideas?
java version "1.4.1_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_01-99)
Java HotSpot(TM) Client VM (build 1.4.1_01-27, mixed mode)
mysql-connector-java-3.0.9-stable-bin.jar
Mac OS X v10.3.2
proc_type: powerpc
os_name: Darwin
os_release: 7.2.0
os_version: Darwin Kernel Version 7.2.0: Thu Dec 11 16:20:23 PST 2003; root:xnu/xnu-517.3.7.obj~1/RELEASE_PPC
There is a bug in release 0.2 that wouldn't allow you to open the MySQL view if there was no table or no links, which is fixed in the 0.3 release.
If you have the 0.3 release, then make sure you have CREATE, DROP, SELECT and INSERT permissions on your MySQL table. These are the only permissions currently needed for MySQL access.
Hope this helps, as don't have a Mac to test on!
Cheers,
Warren