Bug #38037 Installation of system tables failed!
Submitted: 11 Jul 2008 8:48 Modified: 11 Jul 2008 11:08
Reporter: MOHD ZAID OTHMAN Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Installing Severity:S5 (Performance)
Version:mysql-5.0.51a-linux-i686 OS:Linux (Mandriva Summer 2008)
Assigned to: CPU Architecture:Any

[11 Jul 2008 8:48] MOHD ZAID OTHMAN
Description:
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 &
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
http://www.mysql.com
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!
[root@localhost mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1004  Can't create file '/root/tmp/#sql7b7b_1_0.frm' (errno: 13)
080711 16:30:33 [ERROR] Aborting

080711 16:30:33 [Note] ./bin/mysqld: Shutdown complete

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 &
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
http://www.mysql.com
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!
[root@localhost mysql]# su root
[root@localhost mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1004  Can't create file '/root/tmp/#sql7bbd_1_0.frm' (errno: 13)
080711 16:30:59 [ERROR] Aborting

080711 16:30:59 [Note] ./bin/mysqld: Shutdown complete

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 &
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
http://www.mysql.com
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!
[root@localhost mysql]# clear
[root@localhost mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1004  Can't create file '/root/tmp/#sql7bde_1_0.frm' (errno: 13)
080711 16:31:59 [ERROR] Aborting

080711 16:31:59 [Note] ./bin/mysqld: Shutdown complete

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 &
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
http://www.mysql.com
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!
[root@localhost mysql]# clear
[root@localhost mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1004  Can't create file '/root/tmp/#sql7bf4_1_0.frm' (errno: 13)
080711 16:32:29 [ERROR] Aborting

080711 16:32:29 [Note] ./bin/mysqld: Shutdown complete

How to repeat:
who can help me..? error prompt when run
scripts/mysql_install_db --user=mysql
[11 Jul 2008 11:08] Susanne Ebrecht
Many thanks for writing a bug report.

Your user mysql has no permission to write into /root directory. You should change the rights here.

Please read documentation of your operating system how to change it.