stored procedure won't work on different databases with correct privileges

Asked Aug 02 '15 at 15:14

Active Feb 09 '19 at 07:54

Viewed 35 times

show grant result

  GRANT ALL PRIVILEGES ON A.* TO 'root'@'localhost'
  GRANT ALL PRIVILEGES ON B.* TO 'root'@'localhost'

I use the stored procedure to select some rows from B.tableB and try to update A.tableA but I get UPDATE command denied to user 'root'@'localhost' for table 'tableA' when I execute the procedure. if I use A and update tableA in the terminal it will work.This is similar to update command is denied for user he also doesn't know why this happens and I cannot change database in stored procedure.

edited Feb 09 '19 at 07:54

Cœur

37,241
25
195
267

asked Aug 02 '15 at 15:14

KIKIJ

Flush privileges? Select * from mysql.user (for that user and host) ? – Drew Aug 02 '15 at 15:34
my account is not a real root account, it has proper privileges for all the databases related to my website. – KIKIJ Aug 02 '15 at 16:25
it turns out that I have a typo in the database name – KIKIJ Aug 02 '15 at 19:13

stored procedure won't work on different databases with correct privileges

0 Answers0