October 17th, 2003, 04:57 AM
Connecting to remote MySQL database
I hope that someone can help me with this. I am trying to connect to a MySQL database on a Linux (RH 8) machine from Delphi 6 (running on my WinNT laptop). I installed the MySQL version that comes standard with RH8, so there is nothing special about that.
I have tried just about all the methods (myODBC, mysql.pas, TMysqlComponents, etc.) and just cannot connect to the database. As soon as I try to connect I get the following error message: Lost connection to MySQL server during query.
I'm really getting desperate and would appreciate any and all help.
October 17th, 2003, 12:25 PM
Seems not to be a delphi issue really. This problem occurs with a lot of languages and is actually a mysql config issue. See
http://www.mysql.com/doc/en/Gone_away.html for solutions.
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
October 20th, 2003, 03:51 AM
Thanx for the help and the link. I managed to sort things out. In the end I just had to add my laptop's IP to my /etc/hosts file. Thanx again for the help!
November 22nd, 2004, 08:17 AM
How to connect from java(in win NT) to remote MYSQL Database Server on LINUX
iam getting this kind of exception
java.sql.SQLException: Invalid authorization specification, message from server
: "Access denied for user: 'email@example.com' (Using password: YES)"
my cilent is java Application in windows 2000 server.But iam connecting to MYSql server database iam getting that kind of exception.
please help me.
November 24th, 2004, 05:05 AM
Your post is soooo of topic - This is a Delphi forum not a Java forum or a MySQL forum!!
Your username/password is invalid or the remote MySQL server is set up not to accept connections from your machine.
1) Verify that you are using the correct username/password
2) If you still cannot connect, contact your DBA to allow your user to connect from your hostname/ip.