MySQL error during setup on Fedora 6

during the install process, when i run the mysql_install_db command i get a message saying

Neither host 'localhost.localdomain' nor 'localhost' could be looked up with /usr/local/mysql/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

What does this error mean and how do i correct it?
LVL 8
akalbfellAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
ravenplCommented:
what /etc/sysconfig/network file shows as HOSTNAME
Should have valid hostname with full domain eg.
my_host.mydomain.tld

It does not have to be real, just make sure, that /etc/hosts file contains entry
1.2.3.4 my_host my_host.mydomain.tld
127.0.0.1 localhost localhost.localdomain
where 1.2.3.4 is the IP You gave to Your machine

After You made the changes issue: /etc/init.d/networking restart

Or simply force mysql to intall initial db: mysql_install_db --force
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
akalbfellAuthor Commented:
all that info can be bs? i can use test123.com domain or something and it wont matter?
0
 
ygouthamCommented:
as said in the post above, you just need a entry for localhost.localdomain and localhost

what you put in the /etc/hosts file is only a "dummy" entry. it need not be a fully qualified domain name (an ISP registered domain like google.com or something).  you can have any domain name. test123 is just fine.

mysql when it installs the initial db, it creates a file with localhost and ipaddress 127.0.0.1 by default.  when it does not find a corresponding ip address for loclahost, you get the error.

in short, edit /etc/hosts
*************
127.0.0.1      localhost.localdomain     localhost
1.2.3.4          mydomain.com   mydomain
**************

that should finish the errors off...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.