Unable to connect Mysql Server during HCnix installation

Question: Trying to install HCnix but it is not connecting the Mysql server ?
Answer:

This errors occurs if the MySQL root user does not have sufficient privileges to make connection using Server IP address. To resolve the issue follow these steps

Access Linux machine and connect mySQL server using following command:
         # mysql –u root –p

Once you get connected to MySQL then execute following command:
grant all privileges on *.* to root@Server-IP identified by "root-password" with grant option;

Flush Privileges;

Note:
Root-password = MySQL root user password
Server IP = Linux Server IP address

For Debian & Ubuntu Users:
In Debian/Ubuntu by default MySQL can not listen remotely on local host therefore set 'bind-address' as machine IP in my.cnf file at this path /etc/mysql/my.cnf of  Linux Server.

Add Feedback