problem starting mysql, new install
just installed mysql and the installation seem to go ok..
according to research it looks like a permission err msg but i'm not sure how to correct the problem.
do i give permission to the tmp folder or do i modify the my.cnf file to correct this issue
one of the research i ran inot said to created a folder /var/mysqldata/ to fix this problem but how do i tell it to store the mysql.sock into tis folder..
i also gave group and user mysql rights to this folder.
or am i on the wrong path to resolving this issue?
any help u can give me would be greatly appreciated.
and this is the error i received:
[root@comgen mysql]# bin/mysqld_safe --user=mysql &
[root@comgen mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/comgen.ca.pid
041007 21:41:03 mysqld ended
+ Done bin/mysqld_safe --user=mysql
warning: asked for 196608 thread stack, but got 126976
usr/local/mysql/bin/mysql: can't read dir of '/root/tmp/' errcode 13
usr/local/mysql/bin/mysql: can't create/write to file '/root/tmp/ibwnkdan
/usr/local/mysql/bin/mysql: shutdown complete