Bug #93266 mysqldump error select command denied for user ''@'%'

• Submitted: 21 Nov 2018 9:16
• Modified: 21 Nov 2018 12:47
• Reporter: Christoforos Demetriou
• Status: Not a Bug
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S3 (Non-critical)
• Version: 5.7.24
• OS: Ubuntu (18.04)
• CPU Architecture: Other (64bit)

[21 Nov 2018 9:16] Christoforos Demetriou

Description:
I run this command: 

mysqldump -u root <Database> -R --triggers --single-transaction > <db_file>.sql

The error:

mysqldump: Couldn't execute 'SHOW FIELDS FROM ``': SELECT command denied to user ''@'%' for column 'column_name' in table 'table_name' (1143)

How to repeat:
Run this mysqldump -u root <Database> -R --triggers --single-transaction > <db_file>.sql  on version 5.7.24

[21 Nov 2018 11:29] MySQL Verification Team

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php

Looking at the error message i.e *SELECT command denied to user ''@'%'*, it seems that you are not passing MySQL user name to use when connecting to the server.  

Thank you for your interest in MySQL.

[21 Nov 2018 12:47] Christoforos Demetriou

Hello and thanks 
What you mean

" Looking at the error message i.e *SELECT command denied to user ''@'%'*, it seems that you are not passing MySQL user name to use when connecting to the server.   "

I run with -u root and --user=root i am on localhost

Regards