從服務器上遷移數據庫到本地localhost?
執行? 函數? 時報錯,
mysql 1449 : The user specified as a definer ('usertest'@'%') does not exist
經查,是權限問題(其中usertest是服務器上數據庫的登錄名),解決辦法:
?
授權給?usertest 所有sql 權限
mysql> grant all privileges on *.* to usertest@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)