WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] New host database error (3 posts)

  1. Saurdo
    Member
    Posted 8 years ago #

    I just changed hosts and am having this database error when I click "upgrade":

    WordPress database error: [INSERT command denied to user 'u70239109'@'anyhost' for table 'wp_options']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('new_users_can_blog', '0', '', 'yes')

    WordPress database error: [INSERT command denied to user 'u70239109'@'anyhost' for table 'wp_options']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('uploads_use_yearmonth_folders', '1', '', 'yes')

    WordPress database error: [INSERT command denied to user 'u70239109'@'anyhost' for table 'wp_options']
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('upload_path', 'wp-content/uploads', '', 'yes')

    WordPress database error: [UPDATE command denied to user 'u70239109'@'anyhost' for table 'wp_options']
    UPDATE wp_options SET autoload = 'no' WHERE option_name = 'moderation_keys'

    WordPress database error: [UPDATE command denied to user 'u70239109'@'anyhost' for table 'wp_options']
    UPDATE wp_options SET autoload = 'no' WHERE option_name = 'recently_edited'

    WordPress database error: [UPDATE command denied to user 'u70239109'@'anyhost' for table 'wp_options']
    UPDATE wp_options SET autoload = 'no' WHERE option_name = 'blacklist_keys'

    WordPress database error: [UPDATE command denied to user 'u70239109'@'anyhost' for table 'wp_options']
    UPDATE wp_options SET option_value = '3437' WHERE option_name = 'db_version'
    Step 1

    I am unsure of the cause of this and don't understand what is causing this.

    Thanks for any help.

  2. Mark (podz)
    Support Maven
    Posted 8 years ago #

    When you created the user for the database, that user was not given 'All' permissions on the database. If you change that, all will be good. This should be possible on your webhost control panel.

    Are you okay doing that?

  3. Saurdo
    Member
    Posted 8 years ago #

    Yeah, I knew how to do it on my old host but my new host has a different control panel. I asked them for assistance. Thanks for the help.

Topic Closed

This topic has been closed to new replies.

About this Topic