Hello, Despite hours plumbing the MySQL documentation and Paul DuBois' book "MySQL" (New Riders), I can't figure out what exactly creates the Unix socket for local connections. For some reason no socket was created during my setup, and I'm not sure how to go about making one.
I compiled 3.23.44 from source on Darwin 1.4.1, using these options: Bash 2.05 $ ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug I am able to run ' /usr/local/mysql/bin/safe_mysqld --with-user=mysql & ' with no problem. However, I cannot get any of the client programs to communicate with the MySQL server. I believe that my Unix socket (for local connections) is not set up properly, since mysqld runs fine. I believe that I made a mistake in not having a /usr/local/mysql/run directory set up at setup time. Instead, I created the "run" directory after running "mysql_install_db" but before running "safe_mysqld". for some reason I assumed that the socket would be created dynamically when I started the mysql daemon. Is there a script or program that I can use to create the socket? Any advice would be greatly appreciated, I'd like to avoid recompiling the whole distribution if possible. (If that is not possible, is it simply a matter of not having the /usr/local/mysql/run directory set up at compile time?) Thank you, Erik ===== -- Is this where you really wanted to go today ? -- http://www.redhat.com/about/opinions/xp.html __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com --------------------------------------------------------------------- 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
