Hi Everyone,
Trying to install Drupal 5. I have created the db with phpmyadmin and set the privleges.

After trying to execute the last line in INSTALL.mysql.txt, I get an error:
"#1227 - Access denied; you need the RELOAD privilege for this operation "

I then go to my index page to run the Drupal install scripts and it can't connect to the db...
"Failure to connect to your MySQL database server. MySQL reports the following message: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46).
Are you sure you have the correct username and password?
Are you sure that you have typed the correct database hostname?
Are you sure that the database server is running??

I assume these two issues are realted.

I appreciate any support I can get thank you all.

Matty

Comments

exact same problem, using SSH and can't "FLUSH PRIVILEGES;"

Ive tested today my new mysqlscript and produced any login-errors.
After i noticed and changed it, same error here:
"#1227 - Access denied; you need the RELOAD privilege for this operation".

Now I tried to flush the DB through shell access or phpMyAdmin - unsuccessful.

The solution was:
Unblock the DB in the shell with
'mysqladmin flush-hosts'

It seems to be a security-feature in MySQL to prevent attacks :-)

In
http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html
you can find more infos if needed.

Edit:
Sorry, above solution is not reproduceable on another server. But, to solve this Problem (and this should work on every system):
Login to mysql as root and enter your command:

FLUSH PRIVILEGES;

it should now work without compliants...