mysql_install_db giving error
Neither host '127.0.0.1' nor 'localhost' could be looked up with ./bin/resolveip
Just add string in /etc/hosts
vidyadhar
Working as a junior database administrator for MySQL and PostGreSQL databases
Updated on July 20, 2022Comments
-
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
please any help to solve this problem is very useful ( and i have to follow the same installation process)
i am using redhat 6