Unable to connect to database

[Anjana]

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

[Ivan Ferreira]

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.

[Stuart Browne]

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.