By unclematty on

I am having the same problem with networks solutions that i have had with yahoo.

Files are on the web server.

I create the mysql database.

I run the query mentionedin INSTALL.mysql.txt

I try to run the FLUSH PRIVILEGES; query and it fails.

Same error, both hosts.
"#1227 - Access denied; you need the RELOAD privilege for this operation"

Becuase of this I cant install drupal 5. When I try to connect I get...
"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' (2)."

Any suggestions? Thanks.

Comments

vm’s picture

vm commented

drupal 5 has an auto installer. upload the files and head to yoursite.com/install.php

if you manually set the settings file, upload a new one so that it is untouched and make sure its writable.

or is there a reason you aren't using the new auto installer ?

andyk’s picture

andyk commented

My solution:
Unblock with 'mysqladmin flush-hosts' in the shell.

more info here:
http://drupal.org/node/112510#comment-707824

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;
ccoletta’s picture

ccoletta commented

I sent the following help request to Network Solutions after I ran into this problem trying to install Drupal 6.5. The formal response was a very terse "We do apologize but Drupal is not supported on our servers at this time." And there you have it! We're effed! Please read the question I sent to them below, did I pose my question incorrectly??? Why is it that other people say they have been able to install Drupal on Network Solution servers?? Is it because of 6.5 is so new? Would I be able to circumvent this problem if I installed a legacy version of Drupal?? Can anyone suggest a really good web hosting service that does support Drupal?

Submitted Last Updated Number
10/24/2008 01:41 10/25/2008 13:25 1-366579361

"I need a system administrator do go to my mySQL database and perform the SQL command "FLUSH PRIVILEGES;" This is related to my installing and configuring Drupal-6.5 into our webspace. When I try to perform this SQL command using phpMyAdmin, I get the following error: "#1227 - Access denied; you need the RELOAD privilege for this operation " Here is a forum node on the Drupal website describing this problem and possible solutions, all of which involve loggin in as an administrator and flushing the privileges: http://drupal.org/node/113169 Here is the page from the Drupal handbook describing why running this command is needed: http://drupal.org/getting-started/6/install/create-database"

vm’s picture

vm commented

considering this thread was started in 2007 before Drupal 6.x was released I would'nt think its a D6 specific problem.

also note, that a host stating "they don't support drupal" isn't uncommon. They are a host, they support their hardware not the scipts that run on the hardware. Users above you had success at the command prompt, if you have shell access available.

There is a hosting support forum with information that you may be interested in if you decide to switch hosts. It sounds to me like you are looking for a mangaged environment on a VPS or dediciated server if you want them to handle phpmyadmin tasks and the like.