mySQL location

[baragon0]

So I change the "datadir" of my my.cnf file to point to /home/user (Since all of my partitioned space is there instead of /var/) but once I try to log on to mySQL, it gives me a socket connection error, (which still points to /var/lib/mysql/mysql.sock)

I do see the folder for the database in /home/user, but can't logon.

[baragon0]

Okay, just reinstalled mySQL to make it all easier.

the my.cnf looks like this


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

How do I make the databases save to /home/user ?

When just modifiying the datadir, it reports an error saying the .sock couldn't be located

[Lorithar]

I don't know where you installed the actual code ... but ..
in /path/to/mysql/bin/
there is a file
mysql_config
which might well still be pointing the socket to /var/lib/mysql/mysql.sock

BOTH /etc/my.cnf and this file must agree .. .since the server actually uses /path/to/mysql/bin/mysql_config as its startup ....