I am using mySQL 3.23.36 for RH Linux (came with the 7.1 install). I am using mm.mysql-2.0.7-bin.jar JDBC driver.
When I attempt to connect, I am getting a Server Configuration denies access... error. When I have gotten this error in the past, it's been because the user wasn't set up with the correct Host. I can get in using mysql -uXXXXX -p from the command line, but I cannot get the same user to work from our code! I have set users up for access from their machines, and that is working (both client boxes are Windows 2K servers). But access from localhost, or the box itself, to mySQL throws this error every time. I have created a user with every possible Host name -- the IP Address, the hostname of the machine, localhost, etc., and I still get this error. I am using mm.mysql-2.0.7-bin.jar successfully on other servers, and I've looked at their configurations -- and this setup apparently mimics those, but I don't seem to be able to get this working. On this server, the only thing I have done differently is that I installed the IBMJava2-13 jdk rpm, and attempted to use that instead of the Sun jdk1.3.1_01 (which is what I've used in the past). I've since uninstalled the IBM jdk and have installed the Sun jdk (1.3.1_01). I've included what I am receiving as the error in my log files below. Does anyone have any suggestions what may be causing this error? Exception getting connection : java.sql.SQLException: Server configuration denies access to data source at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:203) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:276) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java:167) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:177) Thanks for any suggestions, Kim --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php