Solved

mysqldump error!

Posted on 2004-09-08
3
1,105 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now