WordPress.org

1. Iomega0318
   Member
   Posted 2 years ago #

   Ok well I just updated my Wordpress install from 2.0.1 to 2.3.. what a jump huh lol? anyways it all went smoothly and the database upgrade went ok I assume cause everything seems to be working fine.. But I have a question..
   Should I be worried about this? or is it normal..

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   ALTER TABLE wp_posts CHANGE COLUMN post_status post_status enum('publish','draft','private','static','object','attachment','inherit','future', 'pending') NOT NULL default 'publish'

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   ALTER TABLE wp_posts CHANGE COLUMN post_type post_type varchar(20) NOT NULL default 'post'

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   ALTER TABLE wp_posts ALTER COLUMN post_type SET DEFAULT 'post'

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   ALTER TABLE wp_posts ADD KEY type_status_date (post_type,post_status,post_date,ID)

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   ALTER TABLE wp_users ADD KEY user_nicename (user_nicename)

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   DROP TABLE IF EXISTS wp_linkcategories

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   DROP TABLE IF EXISTS wp_categories

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   DROP TABLE IF EXISTS wp_link2cat

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']
   DROP TABLE IF EXISTS wp_post2cat

   Upgrade Complete
   Your WordPress database has been successfully upgraded!

2. jeremyclark13
   Moderator
   Posted 2 years ago #

   WordPress database error: [Access denied for user '**username**'@'localhost' to database 'blog']

   Yes you need to worry about that. It looks like your database user doesn't have the proper privilegs for your wordpress database.

   Resource:
   http://codex.wordpress.org/Installing_WordPress#Step_2:_Create_the_Database_and_a_User

3. Iomega0318
   Member
   Posted 2 years ago #

   Well the thing is I had Yahoo! install it through their cpanel thing and it set up the user and the tables and it has worked fine.. So far with 2.3 running everything seems to be fine as well and it did say:

   Upgrade Complete
   Your WordPress database has been successfully upgraded!

   It is odd though and I wonder why it threw the errors out.. you can check out my new updated blog here.. as for the database I may log into phpMyAdmin in a second and see what all that was about.. I just figured I would ask since I didn't have the time to check on it earlier.. plus I wanted to know if I broke something or not lol..

   **EDIT**
   Hmm it looks as though I should be worried about that.. stupid Yahoo!.. I have already installed so many plugins and fixed my site up just how I want it.. would it still be safe to just backup my database and run the upgrade.php script again? After of course fixing the user or can I just change it to the same one I use on all my other software, like phpBB and SMF, ect..

4. Iomega0318
   Member
   Posted 2 years ago #

   It doesn't look like it updated a lot does someone perhaps have the query for this so I can run it and fix it.. I don't want to break anything..

5. Iomega0318
   Member
   Posted 2 years ago #

   Ok well I ran each one of the failed queries one by one and they all went fine.. As far as I know those are the only errors and they should now be fixed.. if there is anything else I need to know or if I missed something please let me know ASAP as I am about to open my website back up..

   Also I went ahead and changed the mysql user it logs in as.. will that cause any future problems or will it be ok?

Topic Closed

This topic has been closed to new replies.