(On mysql) puzzled when a problem Someone to do a web of machinery freebsd4.9+apache2.3.9+php4.3.4+mysql5.0. Encountered a strange problem : database users can set up passwords, otherwise the client can not connect mysql. Indicated : "Warning : mysql_connect () : Client does not support authentication protocol requested by server;" "Could not connect to the database" If the database user passwords to air, then everything will be all right. Root user as well. Another good passwords : users of the database installed in server端 myql-u username-p can be used to implement a link to the database. (On mysql) puzzled when a problem It seems that you want a stable, with only 4.9. Then you would not have to use mysql 5.0 (On mysql) puzzled when a problem PAM authentication might be : Oh. (On mysql) puzzled when a problem In fact, this is the same machine used mysql4.1.1. Also, the addition of a 4.9+myql4.1.1 machines, such a strange thing, the root user can not log nameless, other users were ok, but if the root password used empty room. Tracking found that the root passwords and other user passwords coding inconsistencies (in fact the same two passwords users). You may say that the people are the root password, but did not. I have done so because the experiment, root password emptied all OK, and then re-instated root password (such as "rootpw"), set up after good use mysql -uroot -prootpw immediately posted, ok, but when bsd system restart, -uroot -prootpw not use mysql posted. Not surprised? ? [ Closed window ]