en MySQL

Mysqldump: Access denied error when exporting MySQL table or database

When I was trying to export a MySQL table in MySQL Workbench I got an error “1045: Access denied for user ‘****’ (using password: NO) when trying to connect.

mysqldump_error

I noticed that user hadn’t “Lock Tables” privilege. In advanced options screen, you can disable lock tables for reading operations. Isn’t the most recommendable option, but is not a big perfomance penalty when you’re going to export small tables. If you have grant permissions privilege, you should grant “Lock tables” to the user.

mysqldump_error2

After disabling “lock-tables” option, you should be able to export tables.

mysqldump_error3

Share

Escribe un comentario

Comentario

Este sitio usa Akismet para reducir el spam. Aprende cómo se procesan los datos de tus comentarios.