mysql_install_db giving error

vidyadhar picture vidyadhar · Mar 30, 2013 · Viewed 14.6k times · Source

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

Answer

alikhantara picture alikhantara · Dec 12, 2017

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

Just add string in /etc/hosts