[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1132
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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