[support] Installation Issue with MySQL

Fri Nov 30 04:53:15 UTC 2007

Ok boy .... no need to get snarky and start making presumptions ...

I found out what the issue is, and it was *MY* fault ... but I hope my
ignorance will help other people not make the same mistake .... ok?

There are 3 machines involved: 
the actual machine with the database,
the actual machine with the drupal,
and the last machine which was my laptop that I was using to do the install.

I used MySQL-Administrator to make sure that the drupal_user and
password could be accessed from my laptop ... as I usually do ...
But since the Drupal was on another machine .. I had to make sure I
added the host (second machine) and permissions to the database.
Once I added that host to the mysql user ... and then set permissions on
the database .... it worked.

I sincerely hope this helps out other people .... it's all part of being
a community.

Thanks!

Tom

Earnie Boyd wrote:
> Quoting "Tom Holmes Jr." <tom at tomholmes.net>:
>
>   
>> I agree this is a setup issue ... I didn't think it would have anything
>> to do with the local hosts file.
>> The name of the database server I can ping, and I can use Squirrel or
>> MySQL Administrator to connect and authenticate to the database.
>>
>> I presumed that the install.php page got the user, password, database,
>> host, etc from the form on that page.
>> It seems like the username, password, database are all correct ....
>> but the host seems to constantly default to localhost and NOT the host
>> that I entered in on the form.
>>
>>     
>
> Let me guess, you copied the settings.php from development to 
> production.  Change the copied file with your favorite editor.
>
>   
>> I even went to install.mysql.inc file and hardcoded my database ... and
>> it still didn't work ....
>> Maybe I need to bounce Drupal after I changed that .inc file?
>>
>>     
>
> You're just asking for issues.  There is no need to modify this file!!!
>
> Earnie -- http://for-my-kids.com/
> -- http://give-me-an-offer.com/
>
>   