I just learned that MySql 4 comes installed on OS X server. There is this little admin app that allows you to enable it, I was not used to this, but it seemed to work, I was able to login and see the 'test' table.
I then proceeded to set up the password. /usr/local/mysql/bin/mysqladmin -u root password <password> That worked, and I can get into the database as a localhost user with no trouble at all. The second I instructed MySql to /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <password> Is where I ran into troubles. Echo `hostname` gives me something like xserve1.domain.com If I look at the IP resolving to that domain I get a certain IP, that is Host xxx.xxx.xxx.xxx.in-addr.arpa not found: 2(SERVFAIL) These are not my servers, no my IP space, I have been trying to get the owner to fix his DNS for ages now, but I am told there is nothing wrong. I pretty much know there is no reverse DNS in place, and I cant tell if it is delegated to him of or he needs to talk to pacbell to fix this. My question it, how does MySql do lookups for security for the hostname part? Am I insecure now, I have just one entry in the 'user' table for root, host is set to localhost. For now, only php needs to talk to this MySql server, so localhost as a host entry will be the safest, I think. In time, a second machine will need to talk to it, at which I will get stuch on this Reverse DNS issue again, so I just use IP? What order does MySql do these hostname lookups. What are the ramifications of not running /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <password> Thanks. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
