Remote connection to MySQL server...?

Christopher J. Bottaro cjbottaro at alumni.cs.utexas.edu
Wed Oct 20 15:12:44 UTC 2004


Hello,
I'm having a few issues with MySQL using the FC2 distro.

First off, I can't remotely connect to the database.  I did:

GRANT ALTER,CREATE,DELETE,DROP,INSERT,SELECT
ON mydb.*
FOR 'cjb'@'*'

That added a corresponding entry into mysql.user, but when I try to connect
by a remote machine via tora, it says it can't open a connection. 
Connecting via tora on the localhost works fine.  Do I need a specific port
open on my firewall?

My second problem is really more a nuisance than a real problem.  When I
execute "service mysqld start", it sits there for a while then finally says
about timing out then [failed].  Well, it didn't fail cuz I can connect and
use the database just fine...so whats up with the failure message (and semi
long wait for the "timeout")?

Thanks for the help.




More information about the fedora-list mailing list