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$
ubuntu windows tomcat apache
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`
< resource auth="Container" driverclassname="com.mysql.jdbc.Driver" maxactive="100" maxidle="30" maxwait="10000" name="jdbc/TestDB" password="testTwo" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/testDb/testTable" username="testTwo">
And in web.xml: