Author Topic: Troubleshooting: "Can't Contact Database"  (Read 7541 times)

Scot Brew

  • Hero Member
  • *****
  • Posts: 272
    • PipelineFX
Troubleshooting: "Can't Contact Database"
« on: August 24, 2009, 09:01:23 PM »
If you see this error:
"Can't Contact Database: Host 'localhost.localdomain' is not allowed to connect to this MySQL server"

This error sometimes occurs in a Red Hat installation. The Red Hat host table fully-qualifies localhost as localhost.localdomain, a host that is not in the user database that is installed with MySQL. Follow these instructions:

1.   Login (as root) to the Supervisor host:
# ssh -l root supervisor_host
2.   Access your MySQL server, you may need to enter an admin pass-word:
# mysql --user=root mysql
3.   Grant all privileges to root@localhost.localdomain:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost.localdomain WITH GRANT OPTION;  mysql> quit
4.   Restart the Supervisor:
# /sbin/service supervisor restart