WordPress.org

Ready to get started?Download WordPress

Forums

WordPress database installation error on Yahoo (7 posts)

  1. dakiar
    Member
    Posted 7 years ago #

    Hello,

    I have a feeling I'm missing something simple but when I try to install the database for the initial WordPress installation, I get the following message:

    ----------

    WordPress database error: [Access denied for user 'metrobumpkin'@'localhost' to database 'mysql']
    CREATE TABLE entries_categories ( cat_ID bigint(20) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default '', category_nicename varchar(200) NOT NULL default '', category_description longtext NOT NULL, category_parent bigint(20) NOT NULL default '0', category_count bigint(20) NOT NULL default '0', link_count bigint(20) NOT NULL default '0', posts_private tinyint(1) NOT NULL default '0', links_private tinyint(1) NOT NULL default '0', PRIMARY KEY (cat_ID), KEY category_nicename (category_nicename) )

    ----

    I am running my site through Yahoo! and the username and password are working. I've checked through the forums and can't find the exact fix (which I hope is just a simple line change).

    Thanks!

  2. scaturan
    Member
    Posted 7 years ago #

    what version of PHP, mySQL are they using? did you create an empty database for this particular installation? are you upgrading an existing WordPress installtion... if not what version of WordPress are you attemping to install?

  3. MichaelH
    Member
    Posted 7 years ago #

    I've found that at Yahoo, if you are going to install WordPress on your own (not use their Blog activation tool) you have to know the Database Administrator (this will be your DB_USER in wp-config.php) and password (DB_PASSWORD).

    Then I've had to install the Database Admin Tool, which is [phpMyAdmin]]. Note that I've had to use IE when using phpMyAdmin after it is installed.

    Then using phpMyAdmin I've had to access the 'mysql' database and the 'user' table, and edit the Database Administrator user so that it is given ALL the rights/privileges. That meant saying Y to each privilege field (I believe those ended in _priv so DROP_priv would be an example.)

    Then I would use phpMyAdmin to create the database for WordPress (this would be your DB_NAME). Your DB_HOST will be 'mysql'.

  4. skeezicks
    Member
    Posted 6 years ago #

    I'm having problems with Yahoo as well. I used their blog activation tools and managed to get something up, but am running around in circles trying to edit or delete the two posts I wrote and published.

    When I call Yahoo support I am told that since my blog can be accessed, they cannot offer any more help with WordPress, and I haven't yet found an answer to my problem on the WordPress forum. Catch 22!

  5. johngugie
    Member
    Posted 6 years ago #

    I don't see the privilege options on the yahoo myphpadmin. The db is called blog but the host is mysql. I see blog, mysql, and myphpadmin showing as databases but only blog has tables. What do I edit?

  6. MichaelH
    Member
    Posted 6 years ago #

    johngugie, please see your thread here:
    http://wordpress.org/support/topic/136419?replies=3

  7. headlessspider
    Member
    Posted 6 years ago #

    its the mysql database. the tables are db and user inside the mysql database. but be very, very careful editing the mysql database. lots of stuff can go wrong in other places in your site.

    i wrote about it when i upgraded to wp 2.2.2 from the stock 2.0.2 that yahoo uses with screenshots and all. it should work for 2.3.

    disclaimer: it worked with me and i am not sure if it will work for you.

Topic Closed

This topic has been closed to new replies.

About this Topic