Ok people I did a fresh RH install now the server won't start because it is getting a hostname error, I'm hoping that someone might be able to help me with this one.
and my /etc/hosts file contains
[root@dhcp-482-2416 mcdougrs]# /etc/init.d/mysqld start
Initializing MySQL database: Sorry, the host 'dhcp-482-2416' could not be looked up.
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option
I have a feeling that I am close to getting this thing started (I hope anyway)
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
<edit>I think I have a fix, hopefully permanent. I just added the dhcp-482-2416 alias to the hosts file, and then I issued the mysqld start command and wholla it started ;D</edit>