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
Attachment:
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil
