Login to Members Area

Choose the service you want to log in
     
24x7x365 Presence
1-888-289-2246
Live Chat

Hosting Blog

 

MySQL DBA permissions

Error Code: 1142 while Restoring the database

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

Naman Monday 01 July 2013 - 08:59 am | | Default

One comment

One or more comments are waiting for approval by an editor.

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.