467,132 Members | 1,149 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,132 developers. It's quick & easy.

error 1044 on database restore

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 */;
/*!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

Jul 19 '05 #1
  • viewed: 1906

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Carl B. Constantine | last post: by
reply views Thread by Von Bailey | last post: by
2 posts views Thread by arsisthesis | last post: by
reply views Thread by gunsbong | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.