UPDATE command denied to user

  • When I try to save a story I’ve just written, I get the error message below. I’m using wordpress 1.5 and have had no problems until tonight. I called my provider and the database is okay. I’ve had no problems with my ftp either. So I’m guessing this is a problem with the files called “wp_posts” and “wp_option” which I don’t even have as far as I can tell. Can anyone help with this? error message below…

    WordPress database error: [INSERT command denied to user ‘username’@’server’ for table ‘wp_posts’]
    INSERT INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, post_modified, post_modified_gmt, post_parent, menu_order) VALUES (‘460’, ‘1’, ‘2006-10-05 18:30:49’, ‘2006-10-05 23:30:49’, ‘test’, ‘test’, ”, ‘draft’, ‘open’, ‘open’, ”, ‘test’, ”, ‘2006-10-05 18:30:49’, ‘2006-10-05 23:30:49’, ‘0’, ‘0’)

    Warning: Cannot modify header information – headers already sent by (output started at /home/cust1/username/html/wordpress/wp-includes/wp-db.php:98) in /home/cust1/user1122847/html/wordpress/wp-admin/post.php on line 153
    WordPress database error: [INSERT command denied to user ‘username’@’servername’ for table ‘wp_post2cat’]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (460, 9)

    WordPress database error: [UPDATE command denied to user ‘username’@’servername’ for table ‘wp_posts’]
    UPDATE wp_posts SET guid = ‘https://www.finktank3000.com/wordpress/?p=’ WHERE ID = ‘460’

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

  • Check the rights (privileges) for the database user defined in your wp-config.php file. You usually access this (changing rights) through your host’s control panel. Weird that the rights would change, but maybe it happened.

    If you find your rights are correct, then see if you can use phpMyAdmin to access your database. In there is the wp_posts table. Maybe try optimizing that table.

    Thread Starter finkfinktank3000com

    (@finkfinktank3000com)

    Thanks MichaelH. Is there anything in particular I should be looking for in the wp-config.php file? I’m still at a loss about what has changed recently.

    Also, I succesfully set up phpMyAdmin as a plug-in but it won’t do anything because I can’t connect to my database.

    Thanks again for your help. And to the wordpress message board gods, sorry this post appeared in the “Installation” section. I thought I had selected the correct section.

    -dan

    Has any of the following changed in your wp-config file since you installed WP? Have you recently changed your username and password for your host account?

    define(‘DB_NAME’, ‘YOUR DATABASE NAME’);
    define(‘DB_USER’, ‘YOUR DATABASE USER NAME’);
    define(‘DB_PASSWORD’, ‘YOUR DATABSE PASSWORD’);
    define(‘DB_HOST’, ‘localhost’);

    Thread Starter finkfinktank3000com

    (@finkfinktank3000com)

    I haven’t changed anything. I will say however that, in the error prompt on my dashboard, it says I’m usernameblablabla @ at an IP address I don’t recognize and definitely isn’t my host IP.

    Where does that information come from? That is, where does the info in the database error (in my first post above) originate from? Is there a file I could go into and change to my host’s IP?

    Slowly puzzling this out. Thanks for your help.

    dan

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘UPDATE command denied to user’ is closed to new replies.