WordPress.org

Ready to get started?Download WordPress

Forums

Can’t select database (14 posts)

  1. curleyco
    Member
    Posted 7 years ago #

    I see there are a number of people who have written with this error.

    I'm sure the database exists...and that the wp-config file is correct.

    I'm also sure the database location for this hosting service is localhost.

    I'm recreated this same error on 2 different servers...and a friend who knonws databases better than I do is also stumped.

    I really want to use WordPress...but it seems the only answer to this is "It must be some error you've made in the database creation or the wp-config file".

    This post is a last ditch effort to see if there might be ANY other explanation bfore ditching the whole idea of using WordPress.

    Any thoughts at all?

  2. moshu
    Member
    Posted 7 years ago #

    No, there is no other explanation, sorry.

    99.99% is human error: typo in wp-config file, typing in the wrong spot in the config file, DB user not added to the database, DB user not having privileges.

    You may want to give a chance to:
    http://install4free.wordpress.net/

  3. curleyco
    Member
    Posted 7 years ago #

    It's a commercial site. I'll find another blogging software.

    Too bad.

  4. whooami
    Member
    Posted 7 years ago #

    I'm sure the database exists...and that the wp-config file is correct.

    I'm also sure the database location for this hosting service is localhost.

    These same words have been written more times than any other single statements on these forums -- and they are invariably incorrect.

    G'luck.

  5. moshu
    Member
    Posted 7 years ago #

    These same words have been written more times than any other single statements on these forums -- and they are invariably incorrect.

    I wish I had as many thousand dollars as many times this was posted (wrongly)... and I could comfortably retire ;)

  6. gilliancs
    Member
    Posted 6 years ago #

    I wish I had as many thousand dollars as many times this was posted (wrongly)... and I could comfortably retire ;)

    This reply is not very much help to the hundreds or thousands (if you are to retire in comfort!) of people who have this problem.

    Why not give us a few clues? Like:

    These are some of the things that can go wrong:

    1) you made a typing error. Check very carefully that the title of the database matches what you typed into the config file and there are no spaces between the name and the single qote marks.

    It should look like this:

    // ** MySQL settings ** //
    define('DB_NAME', 'testsite');    // The name of the database
    define('DB_USER', 'johndoe');     // Your MySQL username
    define('DB_PASSWORD', 'yourpassword'); // ...and password
    define('DB_HOST', 'localhost');    // 99% chance you won't need to change this value

    2) you didn't install a Mysql database before running the wordpress install script (if you are using phpMyAdmin you should find it in the list of databases on the left of the home screen. Double check it is there.)

    2) you didn't give the database your username. Here's how to do it. (????)

    3) the user doesn't have the right privileges. Heres' how to check.(????)

    4) you didn't save the file "wp-config-sample.php" as "wp-config.php"

    It would be great if moshu or whooami could fill in some of the blanks. . .

  7. MichaelH
    Member
    Posted 6 years ago #

    Also note that Step 2 of Installing_WordPress covers the database and database user creation.

  8. gilliancs
    Member
    Posted 6 years ago #

    Thanks Michael

  9. gilliancs
    Member
    Posted 6 years ago #

    http://codex.wordpress.org/User:harkey/Database_Errors

    Herre's some more information: it's not finished yet, but could help

  10. shadow
    Member
    Posted 6 years ago #

    If you would like to email me, I can take a look for you.

    shadow12 gmail

  11. gilliancs
    Member
    Posted 6 years ago #

    OK, I solved my problem. Thank you to the moderators for their quick offers of help.

    I had copied a running blog on a remote server to my local machine in order to be able to check if 2.3 will run OK with my theme.

    I backed up the mysql data from the remote server using the backup plugin. I opened phpmyadmin, created a new database and imported the data from the backup. So far so good.

    However, I had not set the permissions for this new database. I was already a user with password but I had to make this user/password combination work with the new database I had created.

    For others who may have the same problem, here's how:

    In phpMyAdmin, from the Home page, I clicked on 'privileges'.
    I found my username in the list of users and clicked on the pencil icon to edit the privileges.

    In the first block of possible privileges-global privileges- I selected all then deselected 'GRANT' and clicked 'GO'

    Then in the section below-database specific privileges-I selected the database I wanted access to from the dropdown menu and clicked 'GO'.

    And it worked!

    So, yes, this is an example of one of the 99.9% human-errors and moshu's post did give me the clue to what might be the problem--but not how to solve it.

    To work this out I used Brandon Booth's installation instructions (www.lucidgreen.net) and Chapter 2 'Creating a local test environment for your blog' in the book Blog Design Solutions published by Friends of ED.

  12. eebee
    Member
    Posted 6 years ago #

    I am unable to solve this I am sure it is al installed ok because i did it via my webhost using fantastico.I have several other blogs all installed in this way and all OK except this latest one. Any idea what can go wrong when installing via a host?

  13. Ivovic
    Member
    Posted 6 years ago #

    if you're doing it via fantastico, then why not just junk it and do it again?

    really though, you might be better off "manually" (not so manually) creating the DB in cPanel, and just uploading the version 2.3 files yourself.

  14. eebee
    Member
    Posted 6 years ago #

    I have junked it 3 times but always get the same result ie no result!

    Yes I will try by doing that way. Didn't know you could. Thanks

    When so many people are having a problem it seems very bossy and rude for others to say there is "invariably" a fault in the database set up.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.