By kelvis97 on

Drupal installation fails at Database configuration
I am using Godaddy, I bought a domain 2 days ago, and pointed it towards the space at Godaddy.

I uploaded all the files from Drupal which was 4.5 megs,

next through the Control Panel created a SQL database,

went in and opened my domain in a browser,
Drupal page appears asking what langauge?

Next page after inputting info, passwrd, database name, and address of the SQL server,
I hit the continue button and get the message below:
____________________________________________

Database configuration
The following error must be resolved before you can continue the installation process:
Failed to select your database on your MySQL database server,
which means the connection username and password are valid,
but there is a problem accessing your data.
MySQL reports the following message: Access denied for user 'deltaguitar'@'%' to database
'DeltaGuitar website database'.
Are you sure you have the correct database name?
Are you sure the database exists?
Are you sure the username has permission to access the database?
For more help, see the Installation and upgrading handbook.
If you are unsure what these terms mean you should probably contact your hosting provider.
__________________________________________________________

I thought it may be some type of a permissions problem,
I am using a G5 Mac, I did change the default.settings.php (in the Sites/Default folder)
to settings.php which from what I read needed to be changed plus changed the permissions
to 444...
Thanks

Kevin

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

default.settings.php isn't supposed to be "changed" it is supposed to be copied and renamed settings.php
this in sites/default you should have 2 files default.settings.php and settings.php

I don't believe it is a permissions issue, likely it is an issue with either the DB name or Location. Location of DB can be found and altered by expanding the advanced collapsed fieldset.

lionheart8’s picture

lionheart8 commented

Hi

MySQL reports the following message: Access denied for user 'deltaguitar'@'%' to database
'DeltaGuitar website database'.

I suggest you go and have a look at settings.php & look for the line which looks like this:

$db_url = 'mysqli://username:password@database_host/DB_name';

If you remember all the DB info when you created one via the control panel, was your Database host "%"?
Many hosts use "localhost", and you can find this out in the cpanel or phpmyadmin when you open the drupal database, somewhere at the top of the page.
May be crosschecking to see if all the entries on that line match those you used when creating the database would help.

I have never had to manually change the permission settings of settings.php ...