For Intelligence Server on Linux which is configured with MySQL Metadata, when the Intelligence Server gets restart, below error appears.
Connection failed.
Error type: odbc error. odbc operation attempted: SQLDriverConnect. [HU000:1045: on SQLHANDLE] [MySQL] [ODBC 5.3 (w) Driver] Access denied for user 'root' @ 'xxxx computer_name' (using password:YES) [IM006:0: on SQLHANDLE] [DataDirect] [ODBC lib] Driver's SQLSetConnectAttr failed [01000:364: on SQLHANDLE] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80
CAUSE:Error "Access denied for user "root"" here means the MySQL database user "root", not the Linux root user. The issue is caused by this Database user "root" cannot recognize the IP address of the localhost (Database Server).
If "Localhost" or "computer name" is used, the connection is fine.
ACTION:Check the user "root" info from MySQL Database using below command:
use mysql;
select User, Host, Password from user where user='root';
Find the Host information for this user only with "Localhost" and "computer name", that's why the issue occurs. Issue can be fixed if the IP address is added as the Host of this user or just using "Localhost" and "computer name" when connecting. KB39328 KB439328
