Apache Friends Support Forum

mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

Is the problem I am trying to solve. Suggestion is to make changes to the my.cnf file which I cannot find on my PC using search facility or navigating to specific directories.

Using Vista changed programme defaults to open .cnf files in notebook. Error message is from Dreamweaver CS4

Looked in mysql/bin/

I am a novice so would appreciate any help in as simple terms as possible to sort out missung file and more importantly to solve initial problem

Thanks

ken

You just need to edit your MySQL configuration file and remove the line that starts with "old_passwords". Usually the file is /etc/my.cnf or /etc/mysql/my.cnf.

Hi Ken -

XAMMP uses a different file name convention for the MySQL configuration file.

Its 'XAMMP\mysql\bin\my.ini'

it has the same parameters as a my.cnf file would.

Good Luck

deck2deck wrote:You just need to edit your MySQL configuration file and remove the line that starts with "old_passwords". Usually the file is /etc/my.cnf or /etc/mysql/my.cnf.

deck2deck - those file locations are true on machines that run on a *nix stack, not on Windows machines running MySQL.