Bug #4041 Installation Problems
Submitted: 7 Jun 2004 16:27 Modified: 7 Jun 2004 23:56
Reporter: Peter Dennis Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:mysql-standard-4.0.20-pc-linux-i686 OS:Linux (RedHat 9.0)
Assigned to: Dean Ellis CPU Architecture:Any

[7 Jun 2004 16:27] Peter Dennis
Description:
[root@localhost mysql]# scripts/mysql_install_db
Installing all prepared tables
040607 23:18:17  Warning: Asked for 196608 thread stack, but got 126976
040607 23:18:17  ./bin/mysqld: Shutdown Complete
 
 
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
 
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
See the manual for more instructions.
 
NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
 
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
 
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
 
Please report any problems with the ./bin/mysqlbug script!
 
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
------------------------------------------------------------------------

Following the instructions I then did:
[root@localhost mysql]# cd . ; ./bin/mysqld_safe &
[1] 16735
[root@localhost mysql]# Starting mysqld daemon with databases from /var/lib/mysql
040607 23:20:46  mysqld ended
 
 
[1]+  Done                    ./bin/mysqld_safe

-------------------------------------------------------------------------
Looking in the log file:

040607 23:20:44  mysqld started
040607 23:20:44  Warning: Asked for 196608 thread stack, but got 126976
040607 23:20:44  InnoDB: Started
040607 23:20:44  /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
040607 23:20:44  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040607 23:20:44  Aborting
 
040607 23:20:44  InnoDB: Starting shutdown...
040607 23:20:46  InnoDB: Shutdown completed
040607 23:20:46  /usr/local/mysql/bin/mysqld: Shutdown Complete
 
040607 23:20:46  mysqld ended
-------------------------------------------------------------------------

Can someone tell me what is wrong?

Many thanks,

Peter.

How to repeat:
Download mysql-standard-4.0.20-pc-linux-i686.tar.gz
Follow the binary installation instructions.
[7 Jun 2004 23:56] Dean Ellis
Sorry, but the bug system is not the appropriate forum for asking
support questions. Your problem is not the result of a bug.
For a list of more appropriate places to ask for help using MySQL
products, please visit http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

Correct the path for the first error; correct your file ownership/permission issues for the second.  The INSTALL-BINARY file and the post-installation notes in the manual describe this in more detail.