I should have mentioned that I did a 'find / -name my.cnf' and there is only one such file--/etc/my.cnf
Perhaps I should try creating a local version of my.cnf, but I really want to know why it's getting the wrong .sock file in the first place. Brad Gerald Clark wrote: > check for a .my.cnf file in the user's home directory. It may have > conflicting entries. > > Brad Emerson wrote: > >> >> When I am logged in to my Linux system as root mysqladmin works >> correctly. i.e. finds mysql.sock in the correct location. >> >> When I am logged in as a normal user I get this error: >> >> Can't connect to local MySQL server through socket >> /var/lib/mysql/mysql.sock. blah blah... (This is *not* the correct >> mysql.sock) >> >> >> The issue is that my.cnf indicates /var/tmp/mysql.sock for both >> client and mysqld. And... it works fine when I am logged in as >> root. As a user it's trying to use the wrong mysql.sock file. Any >> idea how to fix this? How I achieved the screwed up state? >> >> BTW, if I use --socket=/var/tmp/mysql.sock it works. I hesitate to >> consider it a longtem solution. >> >> Brad Emerson >> >> >> >> >> --------------------------------------------------------------------- >> 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 >> >> > > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
