Database error when upgrading

  • Resolved jam

    (@jam)


    20 years, 4 months ago

    Whenever I try to upgrade wordpress, I get following errors (I modified USER, HOST, and HIS_DB to protect personal information).

    When I installed wordpress, I made wp-config.php. After that, I have been using WordPress without any problems over 3 months. I can post, edit, etc. However, only wp-admin/upgrade.php doesn’t work fine.

    This error is not only wp2.0 but also wp1.5. I got this error when I upgrade to wp 1.5.2. I didn’t notice any actual problem, so I left it as is. This time, wp2 doesn’t work without newly added “category_count” field. I need to use upgrade.php to add that field. Is there anything that I can do to fix this problem except changing mysql system configuration (I’m not an admin)? Thanks.

    WordPress database error: [Access denied for user: ‘USER@HOST’ to database ‘HIS_DB’]
    ALTER TABLE wp_categories CHANGE COLUMN category_parent category_parent bigint(20) NOT NULL default ‘0’

    WordPress database error: [Access denied for user: ‘USER@HOST’ to database ‘HIS_DB’]
    ALTER TABLE wp_categories ADD COLUMN category_count bigint(20) NOT NULL default ‘0’

    …

Viewing 2 replies - 1 through 2 (of 2 total)
  • Mark (podz)

    (@podz)

    20 years, 4 months ago

    That problem is a priviledges one.
    When the database is created and the user linked, you set the priviledges at that point. They must be set to ‘All’ – and in this case it isn’t.

    If you are using Cpanel, the place this is set can be seen here:
    http://www.zen77857.zen.co.uk/data/cpanel/2.gif
    which is from
    http://www.tamba2.org.uk/wordpress/cpanel/

    Get the priviledge correct and there will be no errors.

    Thread Starter jam

    (@jam)

    20 years, 4 months ago

    Thanks Podz. It makes sense.

    Unfortunately, I and my provider are not using Cpanel. However, your description was good enough to understand the situation. I researched little. Now, I understood it was a mistake administrator forgot to give me grants when he made my database.

    I’m asking my ISP to give me grants now. Thank you so much.

    It was a configuration error of MySQL. No error on WordPress. However, I’m glad if the error message was little more kind like you Podz. 😉 Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database error when upgrading’ is closed to new replies.