I have a MYSQL database created (March 2018) from third party Windows software that includes a few stored procedures. This database is on a GoDaddy shared hosting account with cPanel.
I have been using SQLyog SQL Dump to backup this database since its creation.
The past couple months I started to get the error…
SQLyog Ultimate
Unable to retrieve information. Please check your privileges. For
routines (stored procedures and functions) you need SELECT privilege
to mysql.proc if you are not the owner of the routines.
If I uncheck “Stored Procs” from the Objects to be backed up it runs fine.
Can anyone help me with this?
Thanks,
Dennis