Posted by Jerry Stuckle on 07/24/06 17:45

GD wrote:
> Jerry Stuckle wrote:
>
>
>>Which version of the MySQL client libraries are being used by
>>Apache/PHP? If it's pre-MySQL 4.1, it will use a different password
>>hashing algorithm.
>>
>
>
>>From phpinfo():
>
> Active Persistent Links 0
> Active Links 0
> Client API version 4.1.11
> MYSQL_MODULE_TYPE external
> MYSQL_SOCKET /var/lib/mysql/mysql.sock
> MYSQL_INCLUDE -I/usr/include/mysql
> MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
>
> So this is post-MySQL 4.1?
>
> Thanks
> Dan
>

Yes, that's post 4.1. In that case I would check your server, userid
and password in the mysql_connect() statement very closely.

The fact you can connect from the linux box to the Windows box with
mysql command line utility indicates MySQL on the Windows box is set up
for networking OK, no firewalls in place, etc. The mysql_connect()
statement on the Linux box should use the same type of call.

The only other possibility I can think of is your command line MySQL on
the Linux box might be an older version and you're using pre-4.1
passwords on the Windows MySQL box. "mysql -V" would tell you the
version you're running on the Linux command line.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]