Access denied to database

  • Resolved richyhoolahan

    (@richyhoolahan)


    6 years, 9 months ago

    Hi There.

    I’m trying to bulk edit a product category but I’m having issues with access denied to database. See the below error message.

    __________________________
    WordPress database error: [Access denied for user ‘dbname’@’%’ to database ‘dbname’]
    CREATE TEMPORARY TABLE pwbe_variations (post_id INT, parent_post_id INT)

    WordPress database error: [Table ‘dbname.pwbe_variations’ doesn’t exist]
    INSERT INTO pwbe_variations SELECT DISTINCT post.ID AS post_id, parent.ID AS parent_post_id FROM wp_posts AS post JOIN wp_posts AS parent ON (parent.ID = post.post_parent) LEFT JOIN wp_postmeta AS meta__sku ON (meta__sku.post_id = post.ID AND meta__sku.meta_key = ‘_sku’) LEFT JOIN wp_postmeta AS meta__regular_price ON (meta__regular_price.post_id = post.ID AND meta__regular_price.meta_key = ‘_regular_price’) LEFT JOIN wp_postmeta AS meta__sale_price ON (meta__sale_price.post_id = post.ID AND meta__sale_price.meta_key = ‘_sale_price’) WHERE post.post_type = ‘product_variation’ AND ((parent.post_title LIKE ‘%jordane%’) )

    WordPress database error: [Access denied for user ‘dbname’@’%’ to database ‘dbname’]
    CREATE TEMPORARY TABLE pwbe_products (post_id INT)

    WordPress database error: [Table ‘dbname.pwbe_products’ doesn’t exist]
    INSERT INTO pwbe_products SELECT DISTINCT post.ID AS post_id FROM wp_posts AS post JOIN wp_posts AS parent ON (parent.ID = post.ID) LEFT JOIN wp_postmeta AS meta__sku ON (meta__sku.post_id = post.ID AND meta__sku.meta_key = ‘_sku’) LEFT JOIN wp_postmeta AS meta__regular_price ON (meta__regular_price.post_id = post.ID AND meta__regular_price.meta_key = ‘_regular_price’) LEFT JOIN wp_postmeta AS meta__sale_price ON (meta__sale_price.post_id = post.ID AND meta__sale_price.meta_key = ‘_sale_price’) WHERE post.post_type = ‘product’ AND ( ((parent.post_title LIKE ‘%jordane%’) ) OR post.ID IN (SELECT parent_post_id FROM pwbe_variations) )

    There was an error while filtering. Please send an email to [email protected] with the following information:
    MySQL Error: Table ‘dbname.pwbe_products’ doesn’t exist

    __________________

    I have transferred the database to a different host. Could this be the issue? I can’t find any access errors?

    Any help is much appreciated.

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author pimwick

    (@pimwick)

    This occurs if the logged in database user does not have permission to create temporary tables in the WordPress database.

    The bulk editor relies on temporary tables to handle some of the processing. You will need to contact your hosting provider to allow your WordPress database user to create temporary tables.

    The privilege they need to grant you is “CREATE TEMPORARY TABLES”. See here for details: https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html

    Let me know if you have any other questions!

    Thread Starter richyhoolahan

    (@richyhoolahan)

    Thanks for you swift reply. The site is hosted on Plesk. Do I change the privileges within Plesk or PHP MyAdmin?

    Thanks

    Richard.

    Plugin Author pimwick

    (@pimwick)

    Should be done via PHP MyAdmin. It may require elevated privileges that would need to come from your hosting provider.

    Thread Starter richyhoolahan

    (@richyhoolahan)

    That’s great thanks. I had to go into plesk and update a few settings.

    Thanks for your help.

    Plugin Author pimwick

    (@pimwick)

    Great, glad to hear you were able to get it sorted out!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Access denied to database’ is closed to new replies.