Error in Mysql

[anoopbhaskar]

I hane just installed mandriva 2009 in my desktop, whenever I am trying to use
Mysql it shows some error like given below....

[root@localhost chaami]# service mysqld start
ls: cannot access /var/lib/mysql/mysql: No such file or directory
ERROR: hostname cannot be localhost, mysql_install_db is quite unstable
https://qa.mandriva.com/show_bug.cgi?id=38398
[root@localhost chaami]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
please help me....

[Lakshmipathi]

Have you tried to restart mysql server

/etc/init.d/mysqld restart

And then try to connect it again using

mysql

command

[neverus]

Try the following (as root):

1. rpm -e mysql
2. rm -f /var/lib/mysql/mysql/*
3. /bin/hostname 127.0.0.1
4. urpmi mysql
5. service mysqld start

Hope that helps
Terry