By rojonet on

I'm not a stupid person (no, really, I'm not). I've installed a few PHP and Perl programs successfully. But I'm missing something when it comes to that line in the conf.php file.

I am running MySQL.

My database's name is: rojonet_drupal
The user name is: rojonet_rojonet

(The server appends my logon to everything I create and it's been my experience thus far that it is required. Perhaps it is not in this instance, since I cannot figure out how to get it to read the database using what I have there now.)

Here's the relevant portion of the conf.php file as it exists now:

BEGIN CODE:
$db_url = "mysql://rojonet:[password]@localhost/rojonet_drupal";
# $db_url = "pgsql://user:password@hostname/database";
# $db_url = "mssql://user:password@hostname/database";

$db_url = "mysql://drupal:rojonet_drupal@localhost/rojonet_drupal";

#
# Base URL:
#
# The URL of your website's main page. It is not allowed to have
# a trailing slash; Drupal will add it for you.
#
$base_url = "http://www.ro-jo.net/drupal";

END CODE

When I attempt to launch my page at

http://www.ro-jo.net/drupal/

or

http://www.ro-jo.net/drupal/index.php

I get this pleasant reply:

BEGIN ERROR MESSAGE

Warning: mysql_connect(): Access denied for user: 'drupal@localhost' (Using password: YES) in /home/rojonet/public_html/drupal/includes/database.mysql.inc on line 12
Access denied for user: 'drupal@localhost' (Using password: YES)

END ERROR MESSAGE

I have Drupal installed in a subdirectory for now, and there's nothing in the root except an .htaccess file which I've removed (otherwise it kept returning an Internal 500 error).

Do I have those lines in conf.php configured correctly? What should the files and folders in /drupal be CHMOD'ed to? I have them all set to 755. Should it be 777 (Yeep!)? Or 644? The documentation does not even touch on this topic.

Thanks for any help. I'm anxious to try out this program. If I can even get it off the ground!

Comments

JonBob’s picture

JonBob commented

You should have only one $db_url line uncommented. If more than one of them lacks a leading # character, only the last one will be used.

According to what you've said above, it sounds like the correct path should be:

$db_url = "mysql://rojonet_rojonet:<i>password</i>@localhost/rojonet_drupal";

where rojonet_rojonet is the database username and password is the corresponding password. It doesn't matter what user/pass you use to log on to the server and whatnot; what matters is the user/pass for this database within MySQL.

As far as permissions go, 755 should be fine for all of the Drupal install. The only exception is if you have to store files on the web server; for example, if you enable image.module.