We can't find products matching the selection.

[Dacaesva]

Hello,

I added a product in a freshly installed Magento 2.1.6 I've tried many ways to solve the problem making sure the product Visibility, Status, Qty, Manage stock, stock availability and categories also I flush the cache and reindex but is still not working

Please advise

Thanks  

[Sunil Patel]

have you checked website?

[Theis Corfixen]

Check if you have data in the following tables:

catalog_product_index_price

catalog_category_product_index

And 

catalogsearch_fulltext_scope*store_id*

The last one is only if you are not using an external search service, for example in Magento EE you can use Solr or Elastic Search.

Otherwise make sure your MySQL user can create temporary tables but I think you would get another error if this wasn't the case.