[Solved] chown + symlink + mysql

[Big-E]

So basically, I took the mysql directory located in /var/mysql and moved it to /usr/mysql due to the var directory running out of space (install process recommended that i create a separate partition for /var).

So basically, it's now symlinked from mysql --> /usr/mysql with both having the correct permissions for both user/group for the SL and the original dir. Which, if you didn't know how to change permissions on a symlink is done as follows.

Code: Select all

 
chown -h user directory 
chgrp -h group directory

Note: for some reason chown -h user:group directory did not work ??


Now, my question being - Will this affect the mysql install?

It seems to be as if mysql cannot find the databases when I try "SHOW databases;"


Solution:

I was silly and forgot to check the permissions on the original directory, they are not set correctly and after restarting the daemon and other daemons touching the file, it now works correctly.

[bad_brain]

hm, of course it don't work when the linking didn't work properly....hm, what about using the "normal" ln -s and chown/chgrp?