Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1131
  • Last Modified:

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

0
kheefatt
Asked:
kheefatt
1 Solution
 
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
 
PashaModCommented:
Closed, 125 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now