topic Unable to connect to database in Operating System - Linux

Unable to connect to database

Anjana — Sat, 01 Apr 2006 10:42:25 GMT

Hi ,

I have MYSQL set up on the fedora core 4 machine. I would want to access the DB remotely from a windows machine through EMS MySqlmanager. When i try to register the host it says cannot connect to MySql server. I am otherwise able to connect to the linux box through putty. Please help

Re: Unable to connect to database

Ivan Ferreira — Sat, 01 Apr 2006 11:52:54 GMT

Ensure the database is up:

service mysqld start
service mysqld status

Ensure firewall is down:

service iptables stop

If still won't work, disable SELinux if enabled:

/etc/sysconfig/selinux
SELINUX=disabled

Then reboot.

Re: Unable to connect to database

Stuart Browne — Sat, 01 Apr 2006 17:15:47 GMT

Also make sure you have a user configured in the grants list that can access the database from your remote windows workstation.

Generally, a mysql database is set up to only allow connections from localhost. You have to specifically grant permissions to access a database from a remote host.

http://dev.mysql.com/doc/refman/4.1/en/grant.html

for details on the grant syntax.