dumping

[Anon]

I am trying to dump a database from PC to Linux. I am using 'mysqldump --opt -u user -pPasswd db | mysql -u user -pPasswd --host=host-ip -C db' and I get the error 'Access denied for user :'[e-mail]' to database 'db'. I have used grant select on db.* to user identifed by 'pword'. Is there anything else I need to do?

[Anon]

well... you used Passwd first, and then pword...

are you just abstracting or is that what you did for real? if so, there is your problem.

[Anon]

I was abstracting, I am sure that the passwords are used correctly. Even when I SHOW GRANTS FOR root ON db it shows GRANT SELECT ON db TO 'root'@'%'

[Anon]

i'm not sure if it matters, but just check out your users table in the mysql database.

you will probably need % in the host for root there as well....... which is probably a bad secuirty choice, but it will help to figure out where the problem is.

[Anon]

I am very new to mysql. Here is a page listing the user table. I honestly have no idea what I am looking at. I made a page listing the users and their priviledges. Can you explain where my problem may be.

http://www.sinusdoc.com/priv.asp

Thanks