MySQL 1045 Authentication error

[samalphins]

I have very strange error

mysqldump: Got error: 1045: Access denied for user '[root]'@'localhost' (using p
assword: YES) when trying to connect

I have installed mysql freshly with blank password for user "root" when I am trying perform backup with mysqldump I am getting the strange error

I am trying with the folowing command

d:\xampp\mysql\bin\mysqldump -u [root] -p []

mysqldump: Got error: 1045: Access denied for user '[root]'@'localhost' (using p
assword: YES) when trying to connect

Any one please help me

[code green]

Try with host

-u [root] -h host -p []

mysqldump is problematic and fairly buggy I have noticed.
I also use the full path to the backup file as well as mysqldump.exe.
If you do use a password there should be no space between -p and the password.
I also suffix with 2>&1 but I can't remember why

[samalphins]

Dear green thanks for the reply

I tried with host but I am getting new error as below.

D:\>xampp\mysql\bin\mysqldump -u [root] -h 192.168.0.251 -p []
Enter password: *********
mysqldump: Got error: 2003: Can't connect to MySQL server on '192.168.0.251' (10060) when trying to connect

Any other please.

[samalphins]

Dear green thanks for the reply

I tried with host but I am getting new error as below.

D:\>xampp\mysql\bin\mysqldump -u [root] -h 192.168.0.251 -p []
Enter password: *********
mysqldump: Got error: 2003: Can't connect to MySQL server on '192.168.0.251' (10060) when trying to connect

I uninstalled Norton internet security and disabled windows firewall even then i am facing the same issue

Any other suggestion please.

[code green]

Can you actually connect to this database outside of mysqldump?
It looks like a permissions problem.

I think user of mysqldump needs all permissions granted to work.
Read alone is not enough

[mwasif]

samalphins,

In the first post you said that root does not have any password but in the command you are providing the password.

Are you connecting to MySQL remotely? In order to do so, you must give the permissions to root to connect remotely. If you are on the same system where you have installed MySQL then do not use host parameter, try the following command

D:\>xampp\mysql\bin\mysqldump -uroot -p db_name > dump.sql

[samalphins]

Dear M W Asif,

It worked for me great help I got from you. Thanks for the support and reply.

[mwasif]

You are welcome samalphins.

I am just M Wasif not M W Asif -:)