I have installed mysql via source code installtion, When i tried to start the service its giving error

[root@jacks tmp]# /usr/local/mysql/bin/mysqld start
111223 23:08:58 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
111223 23:08:58 [ERROR] Aborting
111223 23:08:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete


[root@jacks mysql]# ./bin/mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)


anyone plz help me at the earlist

Basically mysql is complaining you're running mysql as root user and refuse to start.
I'd suggest you create user+group mysql, change your my.cnf so mysql runs as as user+group mysql. Alternatively, most distro has their own package manager which you could use to install mysql. That should put the reuqired configs/rights/user etc. in.

What's your distro by the way?

CentOS release 5.7 (Final)
i686

Dear aazkan,
I have made all necessary owership and group
cd /usr/local/mysql
chown -R mysql
chgrp -R mysql
chown -R root .
chown -R mysql data

Hi,

If it's CentOS, a

ought to do it but you wont be getting the lastest mysql. CentOS uses slightly old stable version with backported patches.

Try

if this helps.