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
