I am trying to make a connection to a mysql database. I have a database setup on some server and I have the proper driver setup. It does work when I place the class on the server by calling this: "jdbc:mysql://localhost/db_name" But when I try to run the samething locally like this: "jdbc:mysql://ip_address/db_name" I get an error saying "Bad Handshake". From this I am assuming this must be a permissions thing on the server. Can anyone confirm that and/or tell me how I can change those permissions. Thanks, Bill
posted 16 years ago
MySQL has an option to disallow connections from outside servers. The server needs to be configured to allow what you want. I forget how to do it, but it is in the manual at http://mysql.com
Thanks Thomas, I found it. Looks like you have to change the user table. Change the host field to a wildcard or a mask to allow connections from any or certain computers. Of course I don't have access to the user table, but hopefully my hosting company will open it up for me. Bill
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads