I have a around one hundred stored routines in my MySQL database with with most of them have 'root' as the definer.
I have another mysql account named 'abc', how to change the definer of all routines to 'abc'.
Is it possible to do the same if I have access to MySQL server only as 'abc' user and not as 'root'
As far as I know: You would have to get the script text of them all and drop/recreate them as abc. You would not be able to do this as abc unless abc has permission to drop/create procedures.
1.4m articles
1.4m replys
5 comments
56.9k users