RE: Client Does Not Support Authentication Protocol - a common problem w/ php and mysql
in all the research i've done at mysql.com, php.net, httpd.apache.org, apachelounge.com, and in the phpmyadmin documentation, among other random google hits, i've been unable to pin down what is the real source of this error, or why i can't solve it on this particular setup.
i've tried every suggested fix i could find, and multiple variations and combinations thereof, and still i'm w/out a working MySQL db server.
this obstacle is preventing the completion of my development server on a new HDD w/ fresh XP Pro (all updates and service packs). the server has undergone many changes as i've tried to overcome this mysql problem, including...
installed Apache 2.2.2
installed php 4.1.x binary (to emulate the version of my hosting provider)
obtained and installed 'patched' phpXapache2.dll from apachelounge, enabling apache2.2.2 compatibility for both php5 and php4
failed installation with mysql binaries, mysql msi installers, win essentials, complete packages, mysql 4, mysql 5, etc-- all of which have ultimately resulted in the same error as shown at first URL above
successfully created databases and tables via mysql commandline client on various aforementioned mysql installations
removed apache 2.2.2, and installed apache 2.0.54 - again tried different mysql installations w/out success
obviously, i'm no expert on these technologies-- pardon me if i'm wrecking the vocabulary, but i should remark upon some amount of success. in all of these mysql trials, i was able to use the command line to create users and assign privileges, and create db's and tables (both via c:\mysql\bin\ mysqladmin -u root -p, and via start>programs>mysql>commandline client.. c:\mysql> ... ), but when trying to use PHP scripting, as in
$dblink = mysql_connect("localhost", "user", "pass");
mysql_select_db("dbname", $dblink);
i receive an error that an ODBC connection could not be established (or, could not connect using 'odbc'@'localhost' ... i didn't record the exact errors)
currently i've got Apache 2.0.54 and php 5.1.4 working together just fine.
do you have any suggestions (aside from getting rid of XP for Linux) for what i might do to get the mysql end of my dev. server up and running? can you think of anything i might have overlooked?
thanks!
