How to change the sql script's definers before a local magento database import :

1. First, you have to open your terminal ;)

2. You have to install homebrew if it's not already done :

$ brew install grep

3. Once homebrew downloaded, just enter this command in a terminal :

$ /usr/bin/grep -nw sql/file/path/yourfile.sql -e "DEFINER"

Be carefull /usr/bin/grep if it's you're on a mac. For others user it will be /bin/grep/ (not sure)

It will show you what are the current definers, like that :

DEFINER=`foo`@`XX.X.XX.%`

4. To finish, use this command line to change currents definers :

$ sed -i -- 's/DEFINER=`foo`@`XX.X.XX.%`/DEFINER=`root`@`localhost`/g' ./sql/file/path/yourfile.sql

You can do the command to show definers again to check if it was updated.

You can also do it in sql if you're already import your bdd :

GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root'; FLUSH PRIVILEGES;

or grant all on *.* to 'root'@'%' identified by 'password' with grant option;

Replace "root" by your definer identifior that you can find when you try to change row on sequelpro.