Remote connection to MySQL server...?

[Alexander Dalloz]

Am Mi, den 20.10.2004 schrieb Christopher J. Bottaro um 17:12:

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

Be aware that this can be a security problem. The communication between
the client and the MySQL server is 'sniffable'.

> 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?

Yes, port 3306 (that is default) has to be open. Second, your MySQL user
must be explictly allowed to connect from remote. This is done within
the user management of MySQL. It is a difference for MySQL whether a
user tries to connect from localhost, a specific other host or any other
host.

http://dev.mysql.com/doc/mysql/en/User_Account_Management.html

> 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")?

It is the routine in the init script checking whether the daemon is
running and responding. Did you set a password for the MySQL root user
and deleted the anonymous user?

Alexander


-- 
Alexander Dalloz | Enger, Germany | GPG key 1024D/ED695653 1999-07-13
Fedora GNU/Linux Core 2 (Tettnang) kernel 2.6.8-1.521smp 
Serendipity 17:27:06 up 14:06, 16 users, 0.66, 0.47, 0.30 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20041020/883216ee/attachment-0001.sig>