Solved

mysqldump error!

Posted on 2004-09-08
3
1,109 Views
Last Modified: 2008-02-01
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
Comment
Question by:kheefatt
3 Comments
 

Author Comment

by:kheefatt
ID: 12013482
I solved the problem. This is because I didnt create any user account. I create one using grant and it works!
0
 

Expert Comment

by:chinna22
ID: 12032679
Kewl. You can use the mysqladmin command to debug the same
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 12042504
Closed, 125 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MYSQL simple update statement 3 53
UPDATE query not working in mysqli php 8 50
Create a MySQL table as easily as possible 6 37
two ways encryption with php 3 27
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question