> No matter what I try, I cannot get connected to a remote mysql server.
> I always get the "dbx error: invalid username/password" error dialog.

> I finally broke down and installed the win32 version on my pc and I
> can connect to it as expected.

> If I leave the mysqld service running and change the hostname to a
> remote server and set active := false then true, it (looks like it)
> connects. BUT, it's connecting to the local server NOT the remote
> server. I can tell because if I stop the service I get an error dialog
> telling me the server has gone away.

> Also, If I stop the service, change the hostname to a remote server
> and try to reconnect, I get the invalid username/password dbx error.

> I certainly hope dbexpress was not designed to only access local win32
> mysql servers.

> What in the world is going on here?  Suggestions, tips, solutions will
> be appreciated.

> Mike

> No matter what I try, I cannot get connected to a remote mysql server.
> I always get the "dbx error: invalid username/password" error dialog.

> I finally broke down and installed the win32 version on my pc and I
> can connect to it as expected.

> If I leave the mysqld service running and change the hostname to a
> remote server and set active := false then true, it (looks like it)
> connects. BUT, it's connecting to the local server NOT the remote
> server. I can tell because if I stop the service I get an error dialog
> telling me the server has gone away.

> Also, If I stop the service, change the hostname to a remote server
> and try to reconnect, I get the invalid username/password dbx error.

> I certainly hope dbexpress was not designed to only access local win32
> mysql servers.

> What in the world is going on here?  Suggestions, tips, solutions will
> be appreciated.

> Mike

> No matter what I try, I cannot get connected to a remote mysql server.
> I always get the "dbx error: invalid username/password" error dialog.

> I finally broke down and installed the win32 version on my pc and I
> can connect to it as expected.

> If I leave the mysqld service running and change the hostname to a
> remote server and set active := false then true, it (looks like it)
> connects. BUT, it's connecting to the local server NOT the remote
> server. I can tell because if I stop the service I get an error dialog
> telling me the server has gone away.

> Also, If I stop the service, change the hostname to a remote server
> and try to reconnect, I get the invalid username/password dbx error.

> I certainly hope dbexpress was not designed to only access local win32
> mysql servers.

> What in the world is going on here?  Suggestions, tips, solutions will
> be appreciated.

> Mike

>Are you sure that your Linux MySQL is set up with correct user name and
>password from the correct host. In MySQL you will have to define from which
>host(s) you are able to connect from with a username and password.

>Reading http://www.mysql.com/doc/A/d/Adding_users.html would make a good
>starting point.

>Hope this helps,
>Anders

><Mike Leonard> wrote in message
>news:37k3utosf36ga9gvo6ifm7a9m8sqvjkosl@4ax.com...
>> Using D6.01.
>> Works with local mysql 3.23.43.
>> Does NOT work with remote linux 3.23.41 or 3.23.32.

>> No matter what I try, I cannot get connected to a remote mysql server.
>> I always get the "dbx error: invalid username/password" error dialog.

>> I finally broke down and installed the win32 version on my pc and I
>> can connect to it as expected.

>> If I leave the mysqld service running and change the hostname to a
>> remote server and set active := false then true, it (looks like it)
>> connects. BUT, it's connecting to the local server NOT the remote
>> server. I can tell because if I stop the service I get an error dialog
>> telling me the server has gone away.

>> Also, If I stop the service, change the hostname to a remote server
>> and try to reconnect, I get the invalid username/password dbx error.

>> I certainly hope dbexpress was not designed to only access local win32
>> mysql servers.

>> What in the world is going on here?  Suggestions, tips, solutions will
>> be appreciated.

>> Mike

> I know it's set up correctly because both MySQLDAC and ZEOS work.

> The sqlconnection is not even getting off of my PC. ZoneAlarm pops up
> and requests access, but tcpdump on the db server is not seeing any
> "hits" from my pc.

> If I do the same thing with either off the others, I instantaneously
> see "hits" in tcpdump.

> For example, this is what I see using MySQLDAC.

> [root@uswisuxdb7 /]# tcpdump -n -s 100 src 10.172.17.47 and not port
> 22
> Kernel filter, protocol ALL, datagram packet socket
> tcpdump: listening on all devices
> 11:18:58.603306 eth0 < 10.172.17.47.1266 > 10.172.16.38.mysql: S
> 2430237344:2430237344(0) win 64240 <mss 1460,nop,nop,sackOK> (DF)
> 11:18:58.603593 eth0 < 10.172.17.47.1266 > 10.172.16.38.mysql: .
> 2430237345:2430237345(0) ack 1666135941 win 64240 (DF)
> 11:18:58.604728 eth0 < 10.172.17.47.1266 > 10.172.16.38.mysql: P
> 0:36(36) ack 49 win 64192 (DF)
> 11:18:58.605453 eth0 < 10.172.17.47.1266 > 10.172.16.38.mysql: P
> 36:55(19) ack 58 win 64183 (DF)
> 11:18:58.741361 eth0 < 10.172.17.47.1266 > 10.172.16.38.mysql: .
> 55:55(0) ack 1518 win 64240 (DF)
> 11:18:58.952383 eth0 < 10.172.17.47.1266 > 10.172.16.38.mysql: .
> 55:55(0) ack 2125 win 63633 (DF)

> 6 packets received by filter
> [root@uswisuxdb7 /]#

> With dbexpress I get nothing.

> Something is definitely broken and I'm thinking it's not my PC or my
> mysql servers..

> P.S. Anders, sorry for the email. I clicked the wrong button.

> On Fri, 2 Nov 2001 15:08:06 +0100, in
> borland.public.delphi.database.dbexpress you wrote:

> >Hello!

> >Are you sure that your Linux MySQL is set up with correct user name and
> >password from the correct host. In MySQL you will have to define from
which
> >host(s) you are able to connect from with a username and password.

> >Reading http://www.mysql.com/doc/A/d/Adding_users.html would make a good
> >starting point.

> >Hope this helps,
> >Anders

> ><Mike Leonard> wrote in message
> >news:37k3utosf36ga9gvo6ifm7a9m8sqvjkosl@4ax.com...
> >> Using D6.01.
> >> Works with local mysql 3.23.43.
> >> Does NOT work with remote linux 3.23.41 or 3.23.32.

> >> No matter what I try, I cannot get connected to a remote mysql server.
> >> I always get the "dbx error: invalid username/password" error dialog.

> >> I finally broke down and installed the win32 version on my pc and I
> >> can connect to it as expected.

> >> If I leave the mysqld service running and change the hostname to a
> >> remote server and set active := false then true, it (looks like it)
> >> connects. BUT, it's connecting to the local server NOT the remote
> >> server. I can tell because if I stop the service I get an error dialog
> >> telling me the server has gone away.

> >> Also, If I stop the service, change the hostname to a remote server
> >> and try to reconnect, I get the invalid username/password dbx error.

> >> I certainly hope dbexpress was not designed to only access local win32
> >> mysql servers.

> >> What in the world is going on here?  Suggestions, tips, solutions will
> >> be appreciated.

> >> Mike

> I use Delphi 6 with Update Pack 1 and MySQL v3.23 on my remote database
> server under FreeBSD but only the libmysql.dll v3.22 will work. With
> the right version 3.23 I get the DBXError 'Invalid Username/Password'
> :-((

> It seems for me there is something a little bit buggy....

> Regards
> Reinhard