michaelz:~$ ls /home/git/repositories/serverConf/ibaobao/ conf etc mysql scripts usr michaelz:~$ alias cdibbs='cd /home/git/repositories/serverConf/ibaobao/'
michaelz:~$ cdibbsmichaelz:/home/git/repositories/serverConf/ibaobao$
michaelz:~$ ls /home/git/repositories/serverConf/ibaobao/ conf etc mysql scripts usr michaelz:~$ alias cdibbs='cd /home/git/repositories/serverConf/ibaobao/'
michaelz:~$ cdibbsmichaelz:/home/git/repositories/serverConf/ibaobao$
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
mysql -u userA < schema.sql ERROR 1227 (42000) at line 65: Access denied; you need (at least one of) the SUPER privilege(s) for this operationTo fix the problem is that all the DEFINER=`userB` need to be changed to DEFINER=`userA`