James Kelty wrote:
>sql,query
>
>Ok, this is a little weird.
>
>From system A I can access the Database on System B via the mysql
>command line with the -h option. I can insert into a table, create a
>table, and drop tables. But! Through the JDBC interface using the same
>user/pass, I get an access denied message.
>
>I believe that my permissions are ok. Can anyone point me in another
>direction to turn?
>
>MySQL Version 2.32.51
>
>Thanks!
>
>-James
>
>
Did you check the README that comes with the driver? It has a
troubleshooting section which covers this exact problem.
Also, if you use "-h localhost", you will not get the behavior that
tests that you have your permissions set correctly. You either need to
use the loopback (127.0.0.1) or ethernet interface of your database
server in the "-h" flag.
-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
---------------------------------------------------------------------
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
