php to mysql client problem.
| From: | Michael G. Tracey | Date: | Sat, 07 Feb 2004 19:47:39 +0000 |
| Subject: | php to mysql client problem. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32838@lists.php.net to get a copy of this message | ||
This is my setup: Not really worried about security.
W2kPro w\sp4
Mysql 5.O
Mysqlcc0.9.4
Php 5.0.0.b3 [As CGI]
Apache2.0.48
I can now connect to my server from anywhere using Mysqlcc or another server... home, work, etc.
I can run Php scripts.
I can connect to the Apache Server.
Login to Mysql: Works.
==C:\>mysql -u mike -p
==Enter password: ********
==Welcome to the MySQL monitor. Commands end with ; or \g.
==Your MySQL connection id is 28 to server version: 5.0.0-alpha-max-nt
==Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
PhpInfo Shows:
==MySQL Support enabled
==Active Persistent Links 0
==Active Links 0
==Client API version 3.23.57
==Directive Local Value Master Value
==mysql.allow_persistent On On
==mysql.connect_timeout 60 60
==mysql.default_host localhost localhost
==mysql.default_password no value no value
==mysql.default_port 3306 3306
==mysql.default_socket no value no value
==mysql.default_user root root
==mysql.max_links Unlimited Unlimited
==mysql.max_persistent Unlimited Unlimited
==mysql.trace_mode Off Off
I Try to connect from PHP and I get:
==Not connected : Client does not support authentication protocol ==requested by server; consider
upgrading MySQL client
Could this be the Reason?: From the PHP info above.
=="Client API version 3.23.57"==
I'm thinking yes, but since copying the new files to the same directory overwrote all the
others, is this the client version for all servers currently?? If not how do I force it to update.
I have all the servers working. I don't really at this point want to delete anything.
Michael G. Tracey
_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!