​[MicroStrategy][MySQL]Can’t connect to local MySQL server through socket /tmp/mysql.sock

 Issue:

The error "Can’t connect to local MySQL server through socket /tmp/mysql.sock" arises during the configuration of MicroStrategy Intelligence Server Universal 9.4.x on Red Hat Enterprise Linux when accessing a locally installed MySQL instance. This occurs when using the MicroStrategy Configuration Wizard to configure metadata access, resulting in a connection failure.

Root Cause: The issue stems from a misconfiguration in MySQL. As the MySQL instance resides on the same machine as the MicroStrategy Intelligence Server, the server uses a socket connector rather than a TCP/IP connector to access the database. The error is triggered because the socket file is configured to be written in a directory where the MySQL server lacks write permissions.

Fix: To resolve the problem, contact the systems administrator to grant the necessary permissions for MySQL to write to the specified directory. This action ensures that the MicroStrategy Intelligence Server can establish a successful connection to the local MySQL server.

Note: This Knowledge Base article is applicable to MicroStrategy Intelligence Server Universal 9.4.x and serves as a guide for addressing the specific connection issue. Always consult MicroStrategy's documentation for the most up-to-date information and solutions.

LINK:

https://community.microstrategy.com/s/article/KB211246-The-error-Can-t-connect-to-local-MySQL-server-through-socket-tmp-mysql-sock-occurs-when-configuring-MicroStrategy-Intelligence-Server-Universal-9-4-x-instal?language=en_US