WordPress.org

Ready to get started?Download WordPress

Forums

WordPress cannot select and install WordPress database (12 posts)

  1. geraldisaacs
    Member
    Posted 5 years ago #

    I am trying to install WP 2.7 on a flashdrive using Uniform Server. Instructions say it's a 10-minute job. I'm pushing 14 hours right now. Uniform Server is running Apache and MySql. I have put the wordpress download (the wordpress folder and its files) in directory www on the flashdrive as prescribed.

    When I go to http://localhost/wordpress, I get the WordPress message that my username (root) and password (root) are ok, but WordPress is unable to select the database (I've tried wordpress, root_wordpress, root_root_wordpress). It suggest that maybe root doesn't have permission to use the database, but I doubt that. This is an XP computer, not Vista (thankfully).

    I tried a similar thing a couple years ago, when it was a lot harder (different mySQL and Apache software and different WordPress version) but supposedly doable, but I failed. Is there any hope yet?

  2. You need to have a MySQL database running, accessible and setup before you try to install WordPress.

    You are getting that error message because you don't have MySQL running and setup correctly.

    Please see Hosting WordPress for requirements to run WordPress. If you are getting some responce from http://localhost/wordpress then the PHP requirement is probably good.

    But you also need to have setup MySQL, have it running and create the MySQL userid/password.

  3. geraldisaacs
    Member
    Posted 5 years ago #

    MySQL is running and the userid (root)and password (root) have both been validated by wordpress.

  4. MySQL is running and the userid (root)and password (root) have both been validated by wordpress.

    What's the text of the error message you are getting from WordPress in your browser? Did you setup the create the database and do the GRANT ALL PRIVILEGES part in the instructions?

  5. geraldisaacs
    Member
    Posted 5 years ago #

    When I go to http://localhost/wordpress, I get the WordPress message that my username (root) and password (root) are ok, but WordPress is unable to select the database (I've tried wordpress, root_wordpress, root_root_wordpress). It suggest that maybe root doesn't have permission to use the database, but I doubt that. I am using XP, not Vista.

    No I did not go through the GRANT ALL PRIVILEGES part in the instructions, like you have to do with a conventionsl installation.

    I have pretty much concluded that I am not going to get any meaningful help on this issue. I am now downloading xampp and will try that route instead of uniserver.

  6. When I go to http://localhost/wordpress, I get the WordPress message that my username (root) and password (root) are ok, but WordPress is unable to select the database (I've tried wordpress, root_wordpress, root_root_wordpress). It suggest that maybe root doesn't have permission to use the database, but I doubt that. I am using XP, not Vista.

    I got that already. I was looking for the text to see if I could identify more specifically what's going on. If you created the database, filled in the wp-config.php with good information from the instructions, then this should not be happening.

    I am now downloading xampp and will try that route instead of uniserver.

    Good luck.

  7. geraldisaacs
    Member
    Posted 5 years ago #

    xampp bombed too. So now I am trying to load wp into lightTPD on the laptop. Forget about the flashdrive. If I'm successful, I can then at least carry the laptop around to show the website development effort. Right now I'm stalled trying to get past the password to configure wp-config.php. I managed to get a Vista system running, but am now stymied in XP. That's quite a switch. When I click lets go and try to guess the password on the next page, I get a completely blank window - no error message at all - just the proverbial polar bear in a snowstorm. lightTPD, mySQL, and php-cgi are all running. But still a failure of the five minute install at 24 hours.

  8. But still a failure of the five minute install at 24 hours.

    Don't know what to tell you other than "Good Luck".

    If you have the minimum requirements and confirmed the versions, then you are more than half way there.

    Since you've had problems with lots of different setups, then odds are you are not following the instructions to the letter.

    If you follow the instructions and create user id/password, the database, and tables (do not skip or think that you don't have to do this step; you do.)

    And if you have Apache, PHP, MySQL, all running on localhost, with the database, tables, userid, password and wp-config.php with those values

    then the 5 minute install just works.

    If it does not work, the post the full text of the error messages not just short descriptions.

    If you get a blank screen from PHP then you need to locate that Apache web servers error_log file. Blank pages almost always means PHP died a gruesome death.

  9. geraldisaacs
    Member
    Posted 5 years ago #

    I have finally gotten to the following point where I enter:

    create database wp;
    grant all on wp.* to 'root'@'localhost' identified by 'is2660';

    Then I put my wordpress folder and contents in c:\program files\lighttpd\htdocs

    Task manager shows that lighttpd, mysql-nt, and php-cgi are all running.

    http://localhost shows the lighttpd splash screen

    http://localhost/wordpress/ shows 'error establishing a database connection'

    Is there any way to diagnose the problem?

  10. What does the database lines in your wp-config.php say?

    Also try using another userid and not root. It should not matter but as a just incase.

    In mysql run these commands

    GRANT ALL PRIVILEGES ON wp.* TO wpuser@localhost IDENTIFIED BY  'yourpassword';

    Change the wp-config.php to reflect the username change and see if that works.

  11. geraldisaacs
    Member
    Posted 5 years ago #

    When I issue the grant all........ command am I supposed to put single quotes around root and/or wpuser and/or password? It seems to barf no matter how I issue the command, but I think syntax may be a main contributor to my problems. I have been issuing the command
    grant all privileges on wp.* to 'root'@'localhost' identified by 'is2660'

    Should all these single quotes be eliminated?

  12. Try it without quotes around the userid name.

    The command I copied above was copied from my mysql history file. Except for 'yourpassword' nothing in my history file had quotes.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.