Update the bd engine to the latest version MySQL 8.0.13
and we started with the problems. I did not lift the copy of the database "solved", now I do not execute the stored procedures any user that is not root, before in version 5 if it worked. I already tried with the following sentences.
CREATE USER 'test'@'%' IDENTIFIED BY 'pass';
GRANT ALL PRIVILEGES ON 'naturasport'.* TO 'test'@'%';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON naturasport.* TO 'test'@'%';
GRANT ALL PRIVILEGES ON naturasport.'GetLocationCity' TO 'test'@'%';
GRANT EXECUTE ON PROCEDURE naturasport.'GetLocationCity' TO 'test'@'%';
I also found sentences that included the mysql.proc
table but it does not exist in my engine.
Solution return to MySQL 5.7.24
, but at the moment I will not be another is to return to the previous version.