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
Please configure the 'hostname' command to return a correct
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 fileI'm not comfortable doing that yet. especiall since I can't find any explanation in a forum search for the previous problems.
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 &
Nope, no mysql --help
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.
The latest information about MySQL is available on the web at
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 mysqlWhatever! 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'
./mysqladminAppreciate anyone who wants to explain whats going on step by step. More kudos for what to do next .