I'm trying to make a connection via ODBC with MySQL Database to access data in Excel, however after performing all the necessary settings the following error window is shown to me:
SoIconfiguredtheconnector:
If you have any idea what might be causing such an error, or what would need to be changed in the configuration
Access the Server as root
mysql -u root -p -h localhost
And grant the privilege to the user
GRANT ALL PRIVILEGES ON *.* TO 'reports'@'localhost' IDENTIFIED BY 'sua senha';
FLUSH PRIVILEGES;
Do not grant ALL privileges on all banks, root already has this function. Specify what this user can have access to. Example:
GRANT INSERT, SELECT, UPDATE ON <seu_banco>.* TO 'reports'@'localhost' IDENTIFIED BY 'sua_senha';