Erik Price wrote: > 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.
It does. Try chown mysql:mysql /usr/local/mysql/run Then restart mysqld. b. > > > 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 -- Bill Adams TriQuint Semiconductor --------------------------------------------------------------------- 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
