I am having problems with connecting to our mysql server both locally and from another box. According to the variables, it is running on port 3306, the skip_networking is off and I have confirmed that the mysql.sock does exist.
When I try to connect locally to confirm mysqld is running on port 3306, I receive the following error message:
\"MHost \'domain.com\' is not allowed to connect to this MySQL serverConnection closed by foreign host.\"
When I try to connect remotely I get this error \"Connection closed by foreign host.\"
I have granted all rights to the user and tried using both hostname and IP address.
I have ran flush_hosts and flush_privileges and this did not help any. I even started mysqld and manually specified port 3306 and still have the same connection refused problem.
Any help will be greatly appreciated!
Charlie