Random thoughts shooting out of volatile mind
MySQL failing to start in Mandriva 2009
Well one more surprise is given to me by Mandriva 2009 after the Compaq Presario incidence. Well that incidence is because of H/W manufacturers not software problem. But this is again strange problem which I got when I tried to install Joomla for developing a website. As Joomla needs MySQL I just typed mysql in shell prompt, output showed me that MySQL(mysqld) is not running. So I used following 2 commands
#/etc/init.d/mysqld start
#service mysqld start
I know both commands are one and the same ;) both used to start the mysqld (mysql daemon). Well following error I got.
ERROR: hostname cannot be localhost, mysql_install_db is quite unstable
Well I followed the link given in error message. https://qa.mandriva.com/show_bug.cgi?id=38398 this leads to Bugzilla of Mandriva. I tried to understand what they have given there without any clue of what it actually is. One person had given error message which I've showed above. Solution was something like this

1. rpm -e mysql
2. rm -f /var/lib/mysql/mysql/*
3. /bin/hostname
4. urpmi mysql 

or do steps 1 and 2 and then install latest mysql-5.0.51a-4mdv2008.1
I followed 1st and 2nd link and finally installed the mysql which comes with Mandriva 2009 and here I go when I try starting mysqld it says can't read /var/lib/mysql/mysql  which I deleted as per steps they have given. Well I'll try again with Mandriva 2008 cd hope it works ;)
Now searching for a more stable distro for my project work ;)
Posted by: copyninja on Tuesday, 6 January 2009

blog comments powered by Disqus
Fork me on GitHub