Re: Connecting to a remote server

2004-12-02 Thread Hardy Merrill
Michael, note here that it's been years since I used MySQL, but I think I remember MySQL authentication being host based. That's not the right term, but connecting locally with mysql user user1 is *NOT* the same as connecting remotely to the same server with mysql user user1. There is a way to

Re: Connecting to a remote server

2004-12-02 Thread David N Murray
Pardon my jumping into the middle of this thread without reading the previous, but this problem is well-documented (check google). With MySQL 4.1, you can't connect using DBI. The authentication method changed and the DBD::MySQL module hasn't caught up yet. I went through this a couple of weeks

Re: Connecting to a remote server

2004-12-02 Thread Ron Savage
On Thu, 2 Dec 2004 08:14:12 -0500 (EST), David N Murray wrote: Hi Michael  Pardon my jumping into the middle of this thread without reading  the previous, but this problem is well-documented (check google). Yep. Sounds like the OLD_PASSWORD stuff has not been done on the remote host:

Connecting to a remote server

2004-12-01 Thread Michael David
Hello, I have a script that is connecting to two different databases , one is local and the other remote. The local Informix DBI connection works a treat but I am having trouble getting the remote mysql connection to work. I keep get error: Client does not support authentication protocol