mysqldump error!

Hi experts,

I'm new to mysql.. I'm trying to some database backup using mysqldump command. However, I cannot solve the current problem I am facing. I'll paste to u my command and the error message. I tried both with password and without password..

Without password :

C:\mysql\bin>mysqldump --opt projet > projet.sql
mysqldump: Got error: 1044: Access denied for user: '@localhost' to database 'projet' when using LOCK TABLES

With password :

C:\mysql\bin>mysqldump --opt --user=admin --password=admin projet > projet.sql
mysqldump: Got error: 1045: Access denied for user: 'admin@127.0.0.1' (Using password: YES) when trying to connect

kheefattAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PashaModConnect With a Mentor Commented:
Closed, 125 points refunded.
PashaMod
Community Support Moderator
0
 
kheefattAuthor Commented:
I solved the problem. This is because I didnt create any user account. I create one using grant and it works!
0
 
chinna22Commented:
Kewl. You can use the mysqladmin command to debug the same
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.