?
Solved

MySQL error during setup on Fedora 6

Posted on 2006-11-18
3
Medium Priority
?
292 Views
Last Modified: 2013-12-06
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?
0
Comment
Question by:akalbfell
3 Comments
 
LVL 43

Accepted Solution

by:
ravenpl earned 1200 total points
ID: 17970818
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
 
LVL 8

Author Comment

by:akalbfell
ID: 17972111
all that info can be bs? i can use test123.com domain or something and it wont matter?
0
 
LVL 14

Assisted Solution

by:ygoutham
ygoutham earned 800 total points
ID: 18003757
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
1. Introduction As many people are interested in Linux but not as many are interested or knowledgeable (enough) to install Linux on their system, here is a safe way to try out Linux on your existing (Windows) system. The idea is that you insta…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses
Course of the Month13 days, 10 hours left to enroll

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question