mysql password help 1

[dzon]

Hi,

When I launch phpmyadmin I can see a message at the bottom of the page which says :

"Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole."

So I went into cli mode and changed the root password.(SET PASSWORD FOR root@localhost=PASSWORD('rubberchicken')

When I went into my moodle site I recieved a database error. I had made sure that I amended the config.php file to reflect the password change but to no avail. I then changed the password back to "blank" and everything works again.

I have created a test connect page to rule out my application and it does not connect:

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'rubberchicken';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'moodle';
mysql_select_db($dbname);
?>

I then change the password back to "blank" in my config file and mysql and everything works fine:

mysql> set password for root@localhost=password('');

I am really stumped. I have restarted mysql and apache each time and flushed privileges.

I would really be gratefull if somebody could explain how to correct this.

thanks in nadvance

Dzon

 

[TonyGroves]

There could be a version discrepancy between your MySQL client library and the MySQL server; the password encryption system changed in version 4.1, so you might need to use the OLD_PASSWORD() function instead. It's explained in the manual, at

http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

.

 

[dzon]

Thanks. that did the trick!

Cheers,

Dzon