Hi, i install the mysql from source downloaded my the offical mysql website.
I'm able to start my mysql with the user as mysql in my laptop using his command but i'm not able to start up in my desktop:
Code:
/usr/local/mysql/bin/mysqld_safe user=mysql &
For desktop, therefore i use this to solve the problem:
Code:
/usr/local/mysql/bin/mysqld_safe user=root &
After checking, i realise that there maybe some file permission settings which i need to set, but i realise the settings are almost the same as my laptop which i don't understand why my laptop can works but not desktop.
When the
Code:
/usr/local/mysql/bin/mysqld_safe user=mysql &
is started up, mysql will create a mysql.sock in /tmp.
I find that the
/tmp directory permissions in my desktop are
Code:
drwxrwxrwt 4 root root 4096 2009-05-31 12:04 tmp/
I find that the
/tmp directory permissions in my laptop are
Code:
drwxrwxrwt 10 root root 4096 2009-05-31 12:06 tmp
/etc/passwd in my desktop for user :mysql
Code:
mysql:x:25:25:MySQL:/var/lib/mysql:/bin/false
/etc/passwd in my laptop for user :mysql
Code:
mysql:x:27:27:MySQL:/var/lib/mysql:/bin/false
/etc/groups in my desktop for user :mysql
/etc/groups in laptop for user : mysql
Ok here are my questions:
1) I see that the user mysql has the same permission in my laptop and desktop. Why does the user mysql can create a socket in /tmp but not able to create in my desktop?
2) i see that for the /tmp in laptop, there are 10 symbolic links and in desktop there are 4 links. Does these affect why mysql user in desktop is not able to create a socket in the /tmp?
3) Lastly, since i have 10 links to /tmp, what command can i type to see the 10 links to /tmp in my laptop?
Thanks
