Issue : While restoring the MySQL database using a third party tool like SQLyog, sometimes we get an error like this :
Error occured at:2013-07-01 15:00:44
Line no.:XX
Error Code: 1142 – CREATE command denied to user ‘Database_User’
Solution : The most probable solution for this issue is to grant DBA permission to the database user. Actually the reason for this issue is that the database user “Database_User” is not given the DBA permission. To know how to grant a DB user permissions, please follow this link :
http://www.jodohost.com/hsphere/html/mysql_support.html
]]>