WooCommerce table creation failed

  • Resolved kittellr

    (@kittellr)


    4 years, 6 months ago

    Hi WordPress Pros,
    I have an annoying problem. Per Health Site Status’ Recommended Improvements, I tried to update my SQL on my host’s site, Ionos. Ionos gave me instructions on how to do it on their end. But things didn’t go smoothly and I now have this message that pops up at the top of my screen in the WordPress Admin pages. I get it, the woocommerce table update didn’t work, but how do I remove this annoying message?

    “WooCommerce LqyxSaAMwc_reserved_stock table creation failed. Does the dbo620430396 user have CREATE privileges on the db620430396 database?”

    It’s asking me a question. So how do I say I have CREATE privileges? How do I remove this message? The SQL update wasn’t necessary. I’m ok with keeping the current version, I just want to remove the “failed” message.

    In a perfect world, is there a way I can fix the table creation and increase my site’s security with the new SQL tables? This is all foreign to me. Appreciate any help!

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

  • Hey @kittellr !

    Typically WordPress accesses your database by using a dedicated user for your MySQL database. Each user in MySQL is granted a certain amount of privileges to manage the database. One of the privileges that is needed to work with WordPress is CREATE. This allows the user to create new tables in your database.

    I did a quick search of how to manage MySQL at IONOS and was not able to find anything about managing the user privileges. I would suggest reaching out IONOS and asking them to help you verify that your database user dbo620430396 has all privileges. If not then you will need the to grant all privileges or create a new user with all privileges.

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    – Joey

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WooCommerce table creation failed’ is closed to new replies.