Hi 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!) 3) How can i get mysql to put it's mysql.sock in /var/lib/mysql/ (or specify where to put it) ? Thanks in advance for all your help! By the way, the reason I am using the 4.0.13 tar ball is that I can't get the download SUSE rpms to work, and the version of mysql that came with my SUSE CDs doesn't work either! Oh joy! Thanks again :-D Michael Watson Head of Informatics Institute for Animal Health, Compton Laboratory, Compton, Newbury, Berkshire RG20 7NN UK Phone : +44 (0)1635 578411 ext. 2535 Mobile: +44 (0)7764 490236 E-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
