Products are not showed under catalog page

[Kevin]

My problem is when I add a product from catalog-product and associate it with a specific category. This product is not displayed on the category page.

For example: if I add a product and associate it with furniture section. When I click furniture page, there is no any product displayed on the furniture page. 

I can't find a bug log online. But it is working on my localhost. Just no works for my live site. 

Does anyone find the same problem before? And how can I fix it?

 

[PrestaShopDatabaseException]

Access denied for user 'XXXXXX'@'%' to database 'XXXX'

 

CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND c.nleft >= 35 AND c.nright <= 52 AND c.active = 1) STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1) STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")

Edited November 22, 2017 by Kevin
update question (see edit history)

[NemoPS]

Looks like a permission error for creating temporary tables, check with your hosting

[Kevin]

@NemoPS

no idea whats going on? I have checked with my hosting provider. They said everything good from the server. 

[NemoPS]

They might want to go selling chicken at McDonalds then No, it's not okay, the mysql user doesn't have enough permissions to create temporary tables

[Kevin]

Just for a update for my problem:

Referring to 

I have checked with my post provider:   MySQL databases provisioned on our Cloud Hosting services do not allow customers to modify their user privileges. By default all new MySQL users have the following privileges, this cannot be modified. SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, SHOW VIEW .  So, what can I do to allow database user to create temporary table?

 

Edited November 21, 2017 by Kevin
update question (see edit history)