This is a tricky one, I have the following output:
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
When attempting to export my database with mysqldump
on Windows XP. The username is root, the password is correct and contains only alphanumeric characters. I have tried different cases, with/without quotes, specifying using -u
and -p
, specifying using --user=
and --password=
and other methods of specifying user/passwords etc, specifying the host (it's all local) and even specifying the database using --databases
instead of just blank. The error is always the same when using a password and always the same except the "NO" message when without. I have tried many fixes found through searches with no success. One fix suggested inspecting mysql.conf, but the Windows build doesn't seem to have one. The credentials (and indeed commandline parameters) work perfectly with mysql.exe - this problem only seems to be affecting mysqldump.exe.
Many thanks for your help.
I had the same error for last 2 days. Tried bunch of things. Nothing worked.
But this did work:
Create another user. Grant it everything.
mysqldump -u new_user db_name > db_name.sql
//no errorI just ran into this after a fresh install of MySQL 5.6.16.
Oddly, it works without the password specified or flagged:
mysqldump -u root myschema mytable > dump.sql
I had to remove the single ticks after the password flag:
and NOT
Access dined problem solved when I run command prompt in
Administrator
mode.Go to
Start-> All Programs -> Accessories
right click onCommand Prompt
clickc onRun as..
SelectThe Following User
selectadministrator username
from select option enter password if any clickOK
button.Example 1: For entire database backup in mysql using command prompt.
In Windows 7 and 8
In Windows xp
It asks password for credentials enter password and click on Enter button.
Example 2: For specific table backup / dump in mysql using command prompt.
In Windows 7 and 8
In Windows xp
Dumpt file will be created under folder
In windows xp
In windows 7 and 8
C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin
Note: Check MySQL installation folder in Windows 7, 8 while run in command prompt. If
MySQLWorkbench
is 32 bit version it is installed inProgram Files (x86)
folder other wiseProgram Files
folder.mysqldump -u (user) -p(passwd) -h (host_or_IP) database_to_backup > backup_file.sql
example:
mysqldump -u god -pheaven -h 10.0.10.10 accounting > accounting_20141209.sql
this would create sql backup file for the accounting database on server 10.0.10.10. Sometimes your error is seen when localhost is not in config. Designating ip of server may help.
Put The
GRANT
privileges: