Thanks for your help, I'm using Slackware 14.2, actually my main problem was to change the data directory of MySQL Server
I copied the contents of /var/lib/mysql to home directory and edited rc.mysqld
I modified the line having --datadir=/var/lib/mysql to --datadir=/home/my-path
Now its fine...
checked all the conf files. Everything is fine
but whenever i restart /etc/rc.d/rc.mysqld
it picks /var/lib/mysql
But
After searching here and there, I found something related to mysql.server file. Then i did:
cd /usr/share/mysql
./mysql.server start
Now its picking my configuration.
what is...
Changing mysql datadirectory is getting little bit of confusing. I added the following line in /etc/my.cnf
[mysqld]
datadir=/home/user/newdir
still mysql is using /var/lib/mysql