Run Non-root stored procedures in MySQL 8.0.13

0

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.

    
asked by Leonardo Back 15.11.2018 в 19:21
source

0 answers