At 13:36 +0100 5/12/02, Phil Dobbin wrote: >I'm still trying to get MySQL running on Mac OS X and previously >after installation when MySQL was running, I was getting 1045/6 >errors and now, after a re-boot, MySQL is not running (I didn't add >the start-up script because of the constant permissions errors I was >getting). > >When I try to enter mysql I get: > >[localhost:~] phil% mysql -p >Enter password: >ERROR 2002: Can't connect to local MySQL server through socket >'/tmp/mysql.sock' (2) > >Also when I try to start up (using ./bin/safe_mysqld --user=mysql & ) I get: > >20512 00:13:18 mysqld restarted >rm: /usr/local/mysql/data/localhost.pid: Permission denied >../bin/safe_mysqld: permission denied: >/usr/local/mysql/data/localhost.err [235] >tee: /usr/local/mysql/data/localhost.err: Permission denied > >ad infinitum (I eventually have to "sudo kill -9 PID" to stop it). > >I've added a ~/.my.cnf file (per instructions in the MySQL manaul) >but that makes no difference. Could someone advise me on which file >I have to edit to enable start up and use of MySQL (huge_cnf?)? > >Also, I'm using Marc Liyange's Entropy installation. Has anybody >used his uninstall script and, if so, how safe was it (it looks like >I may have to uninstall and start again)?
Doesn't look like a configuration file problem, looks like a file ownership problem. The server needs to be able to access its files. Try (as root): # cd /usr/local # chown -R mysql mysql My guess is that the mysql hierarchy is owned by root, and that when you specify --user=mysql to run the server, it can't write to root-owned directories. > >Regards, > >Phil. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php