I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I have /usr/local/mysql and so on as per the docs. I also installed MySQLStartupItem.
However, I don't actually appear to have a functional installation. If I do:
/usr/local/mysql/bin/mysql
or even
sudo /usr/local/mysql/bin/mysql
I get:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
although /tmp/mysql.sock does exist, which seems to indicate the server is running. But then again ps -a -x doesn't seem to show it, so maybe it isn't; if I do ps -A |fgrep "mysql" on my Linux box, where MySQL is running happily, I get a hit for mysqld_safe plus ten others for mysqld.
I tried starting the server manually as suggested in the docs:
sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server
but when I try running mysql I get error 2002 as before.
I found mention of this problem on FAQTS and in the MySQL mailing lists archive, the latter of which suggested this email address. Any clues would be most welcome! Please cc any replies to me as I am not currently subscribed to any of the MySQL lists.
Tim:
perror 61 will reveal some details about why exactly the connection on /tmp/mysql.sock cannot happen. If that does not make it obvious ( and it is a good possibility that it would not), try mysql -h 127.0.0.1 instead to bypass the Unix socket and use TCP/IP.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]