• Resolved saurdo

    (@saurdo)


    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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?

    Thread Starter saurdo

    (@saurdo)

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘New host database error’ is closed to new replies.