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
