Host name on my SUSE Linux causing failure in starting MySQL

Hello all,

I suck at Linux and I have got a problem now, which I'm sure is very simple.
I need to start MySQL on my SuSe Linux (most recent version) but it won't
start 'cause it says it can't resolve current address or localhost. Well,
when I use hostname it returns a string with contains a type of hexadecimal
address, but I'm sure that MySQL doesnt recognize that as a valid address...
By the way, resolveip "localhost" works and returns 127.0.0.1.

Is there a way to make my SuSe Linux's hostname return 127.0.0.1 or
localhost or something that would work with my MySQL installation?

Thanks for any help,


-----
Guillaume

On Mon, 9 Feb 2004, Guillaume Métayer <(E-Mail Removed)>
wrote:
>
> I suck at Linux and I have got a problem now, which I'm sure is very simple.
> I need to start MySQL on my SuSe Linux (most recent version) but it won't
> start 'cause it says it can't resolve current address or localhost. Well,
> when I use hostname it returns a string with contains a type of hexadecimal
> address, but I'm sure that MySQL doesnt recognize that as a valid address...
> By the way, resolveip "localhost" works and returns 127.0.0.1.
>
> Is there a way to make my SuSe Linux's hostname return 127.0.0.1 or
> localhost or something that would work with my MySQL installation?

Either use a local interface with static IP (eth0, etc.) or use an extra
loopback IP for your hostname (like 127.0.0.2). I did the latter long ago
when my hostname was for static ppp0, which was not always connected, and
I had no LAN. I currently point my public dynamic DNS hostname at my
static eth0 IP in /etc/hosts (and public DNS points it at my public adsl
IP). Although, I do not do MySQL, this eliminates boot delays for
sendmail or postfix.

--
David Efflandt - All spam ignored http://www.de-srv.com/