This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
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
Thomas Paul
mister krabs
Ranch Hand
Joined: May 05, 2000
Posts: 13974
posted
0
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
0
