mysql problem

[kwaslee]

hi
am new user and i have installed mysql through yast but whenever i check
the status of mysql it gives me below output and i dont know how i can enable it
kwas-kx9q4fz1:~ # rcmysql status
Checking for service MySQL: unused

[harner]

Usually when it says "unused" the service is not on. As root, type:

/etc/init.d/mysql start

[kwaslee]

hi harner when i start the sql the below output is what i get

kwas-kx9q4fz1:~ # /etc/init.d/mysql start
Creating MySQL privilege database and starting MySQL...
hostname: Host name lookup failure
Neither host '' and 'localhost' could not be looked up with
/usr/bin/resolveip
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
failed

[harner]

Did you configure your system through YaST? It looks like it doesn't like your hostname. You can edit that in Yast.

I usually edit my MySQL servers via Webmin, but phpMyAdmin works alright as well. I'm no MySQL expert, I have it loaded on almost all of my Linux servers and it works just fine. You didn't configure something right.

[kwaslee]

thanks harner now its running properly.

[harner]

Glad to hear it kwaslee! Now you can become a MySQL guru and teach the rest of us a thing or two!

[KaustubhSL]

Hey try this?
If u installed all pakages needed for mysql then follow
Yast-System-Services(Runlevel). Look for mysql service & enable it.
Save changes & exit.
Now open terminal & type as a root mysql. the promnt should change & u have done it.