hii friends,

i have freshly installed Fedora Core-6. with that MySql is installed bydefault. The version of mysql is 5.0.22
now whenever i try to start mysql from the terminal by typing "mysql" it shows the following error :

Error 2002 [HY000] : Cant connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

i've checked this directory /var/lib/mysql/
and there is no such file called mysql.sock

by typing the command "/etc/init.d/mysqld status" on the shell it returns -->
mysqld stopped

and by typing the command "/etc/init.d/mysqld start" on the shell the following is shown on the terminal :

Initializing MySQL database : Neither host 'root' nor 'localhost' could be looked up with /usr/bin/resolveip'. Please configure the 'hostname' command to return a correct hostname. If yoiu want to solve this at a later stage restart this script with --force option


i think the mysql service is not started bydefault when the OS starts and i have to configure the hostname etc. but i dont know how to do so. also the mysql.sock file is not getting created.

please suggest a possible solution.