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: 'user@localhost' 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?
--
.''`. Carl B. Constantine
: :' : du******@duckwing.ca
`. `' GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8
`- Debian GNU/Linux -- The power of freedom
"Claiming that your operating system is the best in the world because more
people use it is like saying McDonalds makes the best food in the world."
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw