Title: Database error when upgrading
Last modified: August 18, 2016

---

# Database error when upgrading

 *  Resolved [jam](https://wordpress.org/support/users/jam/)
 * (@jam)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/database-error-when-upgrading/)
 * 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)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/database-error-when-upgrading/#post-313635)
 * 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](http://www.zen77857.zen.co.uk/data/cpanel/2.gif)
   which is from [http://www.tamba2.org.uk/wordpress/cpanel/](http://www.tamba2.org.uk/wordpress/cpanel/)
 * Get the priviledge correct and there will be no errors.
 *  Thread Starter [jam](https://wordpress.org/support/users/jam/)
 * (@jam)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/database-error-when-upgrading/#post-313672)
 * 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.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 2 replies
 * 2 participants
 * Last reply from: [jam](https://wordpress.org/support/users/jam/)
 * Last activity: [20 years, 4 months ago](https://wordpress.org/support/topic/database-error-when-upgrading/#post-313672)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics