"michael watson (IAH-C)" <[EMAIL PROTECTED]> wrote: > > I am having problems POST-installation with MySQL. A bit about my setup: > > SUSE Linux 8.1 > MySQL 4.0.13 (installed from tar ball) > MySQL installed in /usr/local/mysql > > Everything on the installation worked fine. > I then ran mysql_install_db > I then changed ownership of everything in /usr/local/mysql to mysql > I then started the server: mysqld_safe > I then changed the root password to something nice. > > Everything is fine and I have some nice and happy mysqld processes. > > BUT when I try to connect: > > %> mysql -u root -p > > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > > OK, I even know why it can't connect using that mysql.sock - because it DOESN'T > EXIST!! However, /tmp/mysql.sock DOES exist. > > OK, so questions: > > 1) Why doesn't /var/lib/mysql/mysql.sock exist? (mysql user has all the right > priveleges to that directory) > > 2) Why is my mysql.sock in /tmp/ ???? (I don't want it there!)
as MySQL server was compiled .. > 3) How can i get mysql to put it's mysql.sock in /var/lib/mysql/ (or specify where > to put it) ? Add to the my.cnf [mysqld] socket=/var/lib/mysql/mysql.sock or you --socket option of mysqld -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
