"Carl B. Constantine" <[EMAIL PROTECTED]> wrote: > I'm trying to move a database from one machine to another. I dumped the > database and successfully loaded it on one machine, but I can't do it on > another machine. > > I have the database set up. I created the user to access the database, > and gave all privs with grant option for that database. But when I go to > run the command to restore the database, I get the following error: > > $ mysql -u user -p database < database.sql > Enter password: > ERROR 1044 at line 26: Access denied for user: '[EMAIL PROTECTED]' to > database 'database' > > I don't understand. Looking at the sql file, the line is: > > /*!40000 ALTER TABLE accidents DISABLE KEYS */; > LOCK TABLES accidents WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE accidents ENABLE KEYS */; > > Why can I do this on one machine but get an error on the other? The > users are set up the same. Actually, using mysqlcc, I can't even get the > user to have the lock tables priv, even though I'm root granting the > priv, it just refuses to take. Yet, the machine it worked on seems to be > set up the same way and I didn't have a problem. > > Can someone point me in the right direction to a solution? >
It means that user doesn't have ALTER privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
