‘cannot Connect To The Database Because: ‘ . Mysql_error()); (help)?
RSS

‘cannot Connect To The Database Because: ‘ . Mysql_error()); (help)?

Category: FAQ   Time: 2009-07-01   Tags: , , , , ,

Hello,
I am new to all of this configuring things but I am slowly trying to learn. But I am going through the process of installing Drupal and right now I am trying to set up the Database Configuration. Now, when I go into my cpanel on here and click on MySql, then as follow(Ill use a sample name);
New Database: EliteGirl (then clicked on create database)
Current users: Jane (username) fakepw (password) ((then clicked on create user))
Everything adds fine. Now when I get to the Add Users to your Databases section, I have ALL Privileges checked, then I click on add users to database, then this is what is displayed;
Current Databases:
elite08_EliteGirl
Users in EliteGirl
elite08_jane (Privileges: ALL PRIVILEGES)
Connection Strings
Perl $dbh = DBI->connect(”DBI:mysql:elite66_EliteGir…
“elite08_jane”,”");
PHP $dbh=mysql_connect (”localhost”, “elite08_jane”,
“”) or die(’Cannot connect to the database because: ‘ . mysql_error());
mysql_select_db (”elite08_EliteGirl”);
So, I enter the Database name, username and password in Drupal as I entered on Lunarpages and I get this error;
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: Incorrect database name ‘elite66_EliteVASupport ‘.
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?
What am I doing wrong? At the bottom of the screen I see it has a link to access phpMyAdmin, am I suppose to configure anything in there? When I go in there, under create new database, I see it has No Privileges in red. What is wrong there?

Next: Help Starting My Website?
Previous: Bluehost.com & Hostmonster.com’s Live Chat Support Gone?
"‘cannot Connect To The Database Because: ‘ . Mysql_error()); (help)?" was posted on Wednesday, July 1st, 2009 at 10:09 pm.

One Response to “‘cannot Connect To The Database Because: ‘ . Mysql_error()); (help)?”
  1. just "JR"(2009-07-02):

    The only thing I can see is that your connection misses its PASSWORD! (that you said you set to “fakepw”):
    in Php only:
    -> $link = mysql_connect(”localhost”, “elite08_jane”, “fakepw”) or die (”Error: “.mysql_error());
    mysql_select_db(”elite08_EliteGirl”) or die(”Could not select database: “.mysql_error());
    The error you receive refers to an incorrect link in PERL: it is trying to access elite66! (and not elite_08).
    DON’T put BOTH codes! Or you call using Php, OR you call using Perl, not BOTH!
    Try Php as above only.
    Just one more word: I hope the users/pwd you gave are REALLY fake. If not, destroy the DB, recreate a new one and put new users and password…

Leave a Reply

 
Recent Posts
Random Posts