WordPress.org

1. geraldthomas
   Member
   Posted 2 years ago #

   I am new to wordpress, I am trying to connect to the database in the installation, but keep getting the error below.

   I have checked the database details a hundred times over and they are correct, the database is there and i can phpadmin to connect to it. but wordpress cant seem to select it. Any help appreciated

   Many Thanks
   Gerald

   **********ERROR RECEIVED********
   Can’t select database
   We were able to connect to the database server (which means your username and password is okay) but not able to select the K06gree_hhyfc database.

   •Are you sure it exists?
   •Does the user k06gree_admin have permission to use the K06gree_hhyfc database?
   •On some systems the name of your database is prefixed with your username, so it would be like username_K06gree_hhyfc. Could that be the problem?

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 2 years ago #

   When you use phpMyAdmin you're connecting as your admin account, not the database account, most likely. If you're using cPanel, make sure the k06gree_admin ID has access to the database (and check the case sensitivity. k06gree_admin != K06gree_admin after all).

3. geraldthomas
   Member
   Posted 2 years ago #

   The sdmin id has access to the database with all priviledges, as shown below, but it still will not access the database?

   Gerald

   *******************************88
   Current Databases:
   k06gree_hhyfc
   Users in hhyfc
   k06gree_admin (Privileges: ALL PRIVILEGES)

   Connection Strings
   Perl $dbh = DBI->connect("DBI:mysql:k06gree_hhyfc:localhost",
   "k06gree_admin","<PASSWORD HERE>");
   PHP $dbh=mysql_connect ("localhost", "k06gree_admin",
   "<PASSWORD HERE>") or die('Cannot connect to the database because: ' . mysql_error());
   mysql_select_db ("k06gree_hhyfc");

4. songdogtech
   Member
   Posted 2 years ago #

   So are you not using wp-config.php to install? Or have you already installed WordPress and you're trying to conect to the DB with other code?

5. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 2 years ago #

   Perhaps it's case sensitivity still. Wherever it has K06gree_hhyfc change that to k06gree_hhyfc (lower case K).

   (I think he made a database and is trying to get WP to talk to it)

6. geraldthomas
   Member
   Posted 2 years ago #

   I have filled in the wp-install correctly, it happens after that when it trys to run the install,it says that it can connect to the database but can not select it.

   See below, this is wahat I get after filling out the wp-install
   *******************
   All right sparky! You've made it through this part of the installation. WordPress can now communicate with your database. If you are ready, time now to…

   Run the install
   *********************************

   As you can see from the logs above, the database is set up with the correct user privledges, and I have used that info to fill out the wp-install.

   Could it be anything else?

7. songdogtech
   Member
   Posted 2 years ago #

   It's still permissions. What flavor unix? Localhost Mac or Win with MAMP or XAMMP, your own server or a web host?

8. geraldthomas
   Member
   Posted 2 years ago #

   Hi Songdogtech,

   It is on a web host the details are listed below;
   **************************
   Server Name:
   FVS: fvs2.host-ns.co.uk
   Apache Version: 1.3.41 (Unix)
   Perl Version: 5.8.8 (view modules)
   PHP Version: 4.4.9
   MySQL Version: 4.1.22-standard
   *****************************

   cheers
   Gerald

9. songdogtech
   Member
   Posted 2 years ago #

   Ask your webhost; it's their job to straighten out the database permissions. Do they state that they support WordPress?

Topic Closed

This topic has been closed to new replies.