Hi, It looks you haven't updated the mysql client configuration. Adding this lines to your my.cnf file should solve the problem.
[client] port=3306 socket=/raidarrary2/data/mysql/mysql.sock HTH Dobromir Velev [EMAIL PROTECTED] ----- Original Message ----- From: "Michael Pelley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 18, 2003 16:26 Subject: RedHat 8, mysql-server-3.23.54a-4 and relocating the data directory Hi All! I'm new to the list, but I've been using MySQL under Red Hat for a couple of years now. I'm in the process of setting up a new Red Hat 8 box and I want to change the data directory to a different location (/raidarray2/data/mysql). I've edited the /etc/my.cnf as: [mysqld] datadir=/raidarray2/data/mysql socket=/raidarrary2/data/mysql/mysql.sock [mysql.server] user=mysql basedir=/raidarry2/data I've also checked RedHat's /etc/rc.d/init.d/mysqld file and changed the line datadir="/raidarry2/data/mysql" and restarted the server. Still, I keep getting the error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) On the command line, I get the same error with bash_$ mysql -u root -p mysql unless I modify it as bash_$ mysql -u root -p -S /raidarry2/data/mysql/mysql.sock mysql How can I fix this? Is there some other my.cnf file that is being used in RedHat 8? Note that I'm running the version that came with RedHat 8 and has been patched with the up2date command. Thanks! Cheers, Mike ------------------------------------------ Mike Pelley "Non illegitimati carborundum" Owner & "Misc. Rambler" of Pelleys.com [EMAIL PROTECTED] - www.pelleys.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 --------------------------------------------------------------------- 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