PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
$db = mysql_connect("localhost","root","my password here") or die("Problem connecting");
mysql_select_db("kp") or die("Problem selecting database");
I get the following error, which I have never seen before with previous version of mysql.
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\Websites\KPCOM\user_registration2.php on line 262
Any ideas?
Last edited by mhouldridge on Wed Nov 23, 2005 2:27 pm, edited 1 time in total.
Care to read that link I posted, which is the first link found if you google the error message, hence if you pushed the "I'm feeling lucky" button instead, would take you straight to it?
I will bet dollars to donuts you didn't upgrade the Mysql Client from 3.xx to the same version as the new Server software. I have found that too many people who have this problem only upgrade the server software for Mysql because they think that is all that is needed. Basically you have to upgrade everything.
You can usually enter the following line from the CLI on the server.
If the client version (4.1.10 in the example) doesn't match the server version (4.1.10) then you will get the message Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
mhouldridge wrote:One more thing which you might be able to help me with.
MY data folder for the new database, "KP" is not showing any myd / myi files, just users.frm, homes.frm and db.opt
Is this right?
If you are using INNODB instead of MYISAM database types then you will only have frm files in the database directories. INNODB stores database data in ibdata files in the mysql main directory.
The table type is whatever you told Mysql to use. The default is normally MYISAM. Some people use INNODB because it can be more reliable. MYISAM tables usually need to be optimised on a regular bases to recover lost space, clear overhead and speed them up. Thought INNODB tables tend to use more memory as a trade off for being more reliable.
And if you have the ability I would change to PHPMyAdmin as it is free and definately looks better than the commercial product NAvicat. The online manual for NAvicat is almost completely useless as it is limited, very hard to find anything and when you do there isn't much information. (shudder)
Mysql will allow you to change any table from MYISAM to INNODB and back again. So look for that option in NAVicat as PHPMyAdmin allows you to do it so NAVicat should have it.
Oh, and I just remembered this...
Your server will need to have Mysql MAX installed to be able to access INNODB Mysql databases.