Q

Errors when running mysql_up.php

I installed everything - MySQL 4.1.9, PHP 4.3.010, (and trying on a separate PC - Windows 2000 Pro and Apache), and they all installed correctly but I am getting the following errors when I run the page mysql_up.php (shown further down the page).
Warning: mysql_connect(): Client does not support authentication protocol 
requested by server; consider upgrading MySQL client in 
c:inetpubwwwrootmysql_up.php on line 12

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using 
password: NO) in c:inetpubwwwrootmysql_up.php on line 14

Warning: mysql_query(): A link to the server could not be established in 
c:inetpubwwwrootmysql_up.php on line 14
Error 1045: Access denied for user 'ODBC'@'localhost' (using password: NO) 

You first question is a common problem with MySQL 4.1 and PHP. I have answered this so many times I now have a FAQ entry for it.

The second and third errors are caused by not specifying a username and password when connecting to MySQL, you need to specify a username and password in your mysql_connect() call.

This was last published in March 2005

Dig Deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close