Alexander Dalloz wrote: > 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'. Thanks for the heads up. >> 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 Port 3306 is open and /etc/my.cnf has a line "port = 3306" in the [mysqld] section. Yes, I've read the mysql manual and I *think* I've setup my user to be able to connect from the remote host. Here is the relevant portion of my mysql.user table: +-------------+---------+------------------+ | Host | User | Password | +-------------+---------+------------------+ | aa.bb.cc.dd | pymymud | (hashed passwd) | +-------------+---------+------------------+ Then from aa.bb.cc.dd, I try to connect: mysql -u pymymud -p -h <ipaddr of mysql server> -P 3306 pymymud ERROR 1130: Host 'aa.bb.cc.dd' is not allowed to connect to this MySQL server >> 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? Yes, I changed the password of the root MySQL user. I didn't delete the anonymous users, but I did change the passwords for them. Here is (part of) my mysql.user table: +-------------+---------+------------------+ | Host | User | Password | +-------------+---------+------------------+ | localhost | root | (hashed passwd) | | semaphore | root | (hashed passwd) | | localhost | | (hashed passwd) | | semaphore | | (hashed passwd) | | localhost | pymymud | (hashed passwd) | | aa.bb.cc.dd | pymymud | (hashed passwd) | +-------------+---------+------------------+ Thank you for the help.
