mysql_install_db giving error

15,347

Neither host '127.0.0.1' nor 'localhost' could be looked up with ./bin/resolveip

Just add string in /etc/hosts

Share:
15,347
vidyadhar
Author by

vidyadhar

Working as a junior database administrator for MySQL and PostGreSQL databases

Updated on July 20, 2022

Comments

  • vidyadhar
    vidyadhar almost 2 years

    I have downloaded the mysql-5.1.38-linux-x86_64-glibc23.tar.gz from here

    and then i have executed it by using below command

    groupadd mysql
    
    useradd -g mysql mysql123
    
    cp mysql-5.1.38-linux-x86_64-glibc23.tar.gz /home /mysql123/
    
    su - mysql123
    
    tar -zxvf mysql-5.1.38-linux-x86_64-glibc23.tar.gz
    
    mv mysql-5.1.38-linux-x86_64-glibc23 mysql
    
    mkdir tmp
    
    cd mysql/
    
    mv suppport-files/my-medium.cnf my.cnf
    
    cp support-files/mysql.server bin/
    

    and then i have edited the my.cnf and set the basedir and datadir to /home/mysql123/mysql and /home/mysql123/mysql/data and innodb_home_dir and logfile directory to datadir

    Now edited mysql.server and set the datadir and basedir in them properly

    and then initiated mysql_install_db as

    [mysql123@localhost mysql]$ ./scripts/mysql_install_db
    ./scripts/mysql_install_db: line 244: ./bin/my_print_defaults: cannot execute binary file
    Neither host '127.0.0.1' nor 'localhost' could be looked up with
    ./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
    

    on seeing the error i thought it may be confused with basedir and executed the same as below

    [mysql123@localhost mysql]$ ./scripts/mysql_install_db -–user=mysql123 -–basedir=/home/mysql123/mysql
    ./scripts/mysql_install_db: line 244: ./bin/my_print_defaults: cannot execute binary file
    Neither host '127.0.0.1' nor 'localhost' could be looked up with
    ./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
    

    i am not gettin what is going internally and showing this kind of message

    and i am sure that i have enough diskspace ( df -h ) and i have proper ownership ( chown mysq123:mysql /home/mysql123/ -R) and proper permissions ( chmod 755 .)

    and the lines in mysql_install_db are like below enter image description here

    please any help to solve this problem is very useful ( and i have to follow the same installation process)

    i am using redhat 6