Solved

MySQL error during setup on Fedora 6

Posted on 2006-11-18
3
286 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 300 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 200 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Centos 6 User Can't Assign Password 2 43
linux(debian) mouse poor performance 4 42
ifconfig 4 47
000webhost.com default error log 1 28
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…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

832 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