Random thoughts shooting out of volatile mind
MySQL problem in Mandriva 2009 Solved
I had mentioned in my techfiz blog  about MySQL server failing to get started in the Mandriva 2009. When you try to start mysqld you may get this error.
ERROR: hostname cannot be localhost, mysql_install_db is quite unstable
The link in the error message leads to Mandriva forum which tells to uninstall and then re-install it with MySQL package of Mandriva 2008. But this didn't solve the problem for me. Actually solution is simple. As you can see in the error message it tells that host name can't be localhost. So I tried changin the host name and it actually worked !!. Try following commands.
[root@localhost vasudev]# hostname vasudev
This command changes hostname to my name instead of localhost. Now try starting mysqld and you will get some warning message which is shown below
[root@localhost vasudev]# /etc/init.d/mysqld start
Initializing MySQL database:
WARNING: The host 'vasudev' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
This is just because daemon is not able to find your new host name in /etc/hosts file, Just chage the localhost in /etc/hosts file to your new host name and restart the mysqld and your problem is solved. Once you change the /etc/hosts file it should look similar to this.        vasudev
I hope this will solve the problem for all of you :)
Posted by: copyninja on Saturday, 14 February 2009

blog comments powered by Disqus
Fork me on GitHub