Table 'mysql.proc' doesn't exist with new install

I have installed a brand new nopCommerce 4.3 store and it is hosted in Azure. I also created a new "MySQL server for Azure" service as my database.  Everything works fine and the main page of store loads. However, when I go to navigate to categories or product it complains about it is not able to execute stored procedures. Has anyone faced similar issue?

I have tried with MySQL version 5.7 and 8.0. Still the same issue?

Store url - https://nancyhomestore-dev.azurewebsites.net/

It will be nice if someone can help.

kunaljain90 wrote:

I got same error as you got before. How can you solve this?

I am getting "504 Gateway Time-out" error. can you post whole error log that looked at log list page at admin site.

Hi Folks.

Azure Database for MySQL – Single Server service, we have a gateway which runs v5.6 which may be cause this error.

You can change the port in the connection string to 3309 (default would be 3306), which will connect you to v8.0 client in the gateway. More details here - Supported versions - Azure Database for MySQL | Microsoft Docs

Hope it helps!
Rafael
https://www.linkedin.com/in/rafaeldfontana