Wanna help a newbie with install? Here r the errors...

[xtiansimon]

I'm newbie with a PHP/MySQL project. I'm using the sitepoint book by Yank. I already had MySQL installed and running from the Fedora 11 DVD install. I installed Apache from the book, its still workin. Then tried to install PHP and everything was in the wrong place. When I located the mysql_config it would not work for PHP install ./configure file.

OK. so I went through yum'n out mysql. I'm going to redo it from scratch as per the book (gee, I hope Apache 'll be ok with that).

Right now, mysql is not processing the install script on page 35=
[root@xtian mysql]# scripts/mysql_install_db --user=mysql

scripts/mysql_install_db: line 205: ./bin/my_print_defaults: cannot execute binary file
Neither host 'xtian' 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

Naturally this didn't bother me cuz there is no host yet. I'm using local host and Apache is fine with that right now. I try it with the --force option
[root@xtian mysql]# scripts/mysql_install_db --force --user=mysql

scripts/mysql_install_db: line 205: ./bin/my_print_defaults: cannot execute binary file
Installing MySQL system tables...
scripts/mysql_install_db: line 351: ./bin/mysqld: cannot execute binary file
Installation of system tables failed!

Examine the logs in ./data for more information.
You can try to start the mysqld daemon with:
./bin/mysqld --skip-grant &

I'm not comfortable doing that yet. especiall since I can't find any explanation in a forum search for the previous problems.

and use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:
shell> ./bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.

Nope, no mysql --help

The latest information about MySQL is available on the web at
newbiecantposturls
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!

So I tried the manual pages for mysql. According to my install there is a man directory in the mysql directory. It just doesn't work...
[root@xtian mysql]# man mysql

No manual entry for mysql

Whatever! So maybe it really started and this is all just trying to get on my nerves! No and Yes (^_^)......
[root@xtian /]# /usr/local/mysql/bin/mysqladmin -u root status

bash: mysqladmin: command not found

[root@xtian /usr/local/mysql/bin]# find ./ -name 'mysqladmin'

./mysqladmin

Appreciate anyone who wants to explain whats going on step by step. More kudos for what to do next .

Xtian

[xtiansimon]

In a feat of daring intended to astound you,
I will solve my own problems, here, for your entertainment...

[root@xtian mysql]# scripts/mysql_install_db --user=mysql

scripts/mysql_install_db: line 205: ./bin/my_print_defaults: cannot execute binary file
Neither host 'xtian' 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

THINKING_TO_HIMSELF-- Apache doesn't require a host name. Maybe MySQL does. First i will look at this resolveip file and see if it is editable. Since I'm accessing the internet from my public library I will now have to do an internet search on this file and what it does. Oh wait. I have to be at my just-over-minimum-wage-part-time job in two hours. I will see what I can do --/THINKING_TO_HIMSELF

[xtiansimon]

Bugs related to this in v4.

wwwDOTgoogleDOTcom/url?sa=t&source=web&ct=res&cd=1&ved=0CAoQFjAA&url=http%3A%2F%2Fbugs.mysql.com%2Fbug.php%3Fid%3D4215&rct=j&q=%2Fbin%2Fresolveip&ei=tBLWSolj0oaUB_Hi8ZwJ&usg=AFQjCNHCSmWtLrzrLSukT-xEckr8SZE5JA

Anything to do with a 64-bit install? I really don't know how to tell if I have a 64-bit computer. What--he asks himself--would be the error for installing a 64-bit mySQL package on a 32 bit machine?

The best next step given that I have to log off the library's computer in the next ten minutes cuz I only get 1 hour per day internet time, is to go home and try to install the other 32bit version.

... Good Luck Dude!

[xtiansimon]

Ok.
1. Updated glibc with YUM
2. Switched to new install: i686-glibc... install from the 64 bit version. For my use its a better choice since i686 will run even on a 64bit-whatever..
3. CHOWNed the files, then CHOWNed em again as per the MySQL REFMAN instead of the Yank book.
4. Running the commands to test if the server is running, there was a strange output to the command line. checked the error file in mysql and found this:
A mysqld process already exists at Thu Oct 15 15:56:08 EDT 2009

Working on what this means since there's nothing after "at". Some straggler from the previous install not removed by YUM? Now I just have to find where that would be. Why didn't the new install overwrite it?

Xtian

[xtiansimon]

mysql is not listed in PS before running the mysqld_safe command
Here is the output from this command

# bin/mysqld_safe --user=mysql
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /usr/local/mysql/data


Then the prompt hangs there.

I did a search on the nohup and found this more advanced problem. I can't imagine the two are related:
http://www.sitepoint.com/forums/show...ighlight=nohup

I don't know what else to do. It is running according to PS. The original issue was PHP would not install because it couldn't find some part of MySQL. now that I've moved the MySQL to this new directory, maybe that problem will go away. HAHAHA!

I'LL BE BACK...