Bug #15241 Can't start the MySQL server
Submitted: 25 Nov 2005 4:19 Modified: 29 Jan 2006 11:56
Reporter: Claudia Liu Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:mysql-standard-5.0.15-linux-i686.tar.gz OS:Linux (RedHat Enterprise Linux 4)
Assigned to: CPU Architecture:Any

[25 Nov 2005 4:19] Claudia Liu
Description:
When I type "./bin/mysqld_safe &" this command to start the MySQL server ,system    shows an error message. I can't understand this error message. Please help me. Thank you.

The basic commands which I execute to install and use a MySQL
binary distribution are:

     shell> groupadd mysql
     shell> useradd -g mysql mysql
     shell> cd /usr/local
     shell> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
     shell> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
     shell> cd mysql
     shell> scripts/mysql_install_db 
     shell> chown -R root  .
     shell> chown -R mysql data
     shell> chgrp -R mysql .
     shell> ./bin/mysqld_safe &

How to repeat:
[root@localhost mysql]# ./bin/mysqld_safe &
[2] 5528
[1]   Exit 127                bin/mysqld_sqfe --user=mysql
[root@localhost mysql]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
051125 12:01:39  mysqld ended
[25 Nov 2005 8:37] Valeriy Kravchuk
Thank you for a problem report. Please, send the exact sequence of actions you perfromed (fc -l will show you), not qoute from the manual. 

What is really needed is the error log (*.err file in the data directory) content. There should be the explanation for the problem in the error log. Please, send it.

Do you have other MySQL versions already running?
[28 Nov 2005 0:43] Claudia Liu
The exact sequence of actions I perfromed:

[root@localhost ~]# userdel -r mysql
[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -g mysql mysql
[root@localhost ~]# cd /usr/local
[root@localhost local]# ln -s /usr/local/mysql-standard-5.0.15-linux-i686 mysql
[root@localhost local]# cd mysql
[root@localhost mysql]# scripts/mysql_install_db
Installing all prepared tables
Fill help tables

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
[root@localhost mysql]# chown -R root .
[root@localhost mysql]# chown -R mysql data
[root@localhost mysql]# chgrp -R mysql .
[root@localhost mysql]# ./bin/mysqld_safe &
[1] 3618
[root@localhost mysql]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
051128 00:07:11  mysqld ended

[1]+  Done                    ./bin/mysqld_safe
[root@localhost mysql]# find / -type d |grep mysql$
/var/lib/mysql
/var/lib/mysql/mysql
/home/mysql
/usr/local/mysql-standard-5.0.15-linux-i686/share/mysql
/usr/local/mysql-standard-5.0.15-linux-i686/data/mysql
[root@localhost mysql]# pwd
/usr/local/mysql
[root@localhost mysql]# cd data
[root@localhost data]# ls
mysql  test                                --------> I don't have *.err file
[28 Nov 2005 9:22] Claudia Liu
/var/lib/mysql/localhost.localdomain.err

051127 23:43:18  mysqld started
051127 23:43:18  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051127 23:43:18  mysqld ended

051127 23:43:33  mysqld started
051127 23:43:33  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051127 23:43:33  mysqld ended

051127 23:49:59  mysqld started
051127 23:49:59 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'usr=mysql'

051127 23:49:59  mysqld ended

051128 00:07:11  mysqld started
051128  0:07:11  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051128 00:07:11  mysqld ended

051128 07:53:45  mysqld started
051128  7:53:48  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051128 07:53:48  mysqld ended

051128 07:59:41  mysqld started
051128  7:59:41  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051128 07:59:41  mysqld ended

051128 08:34:01  mysqld started
051128  8:34:01  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051128 08:34:01  mysqld ended

051128 16:38:58  mysqld started
051128 16:39:00  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051128 16:39:00  mysqld ended

051128 16:59:40  mysqld started
051128 16:59:40  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051128 16:59:40  mysqld ended

051128 17:00:09  mysqld started
051128 17:00:10  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051128 17:00:10  mysqld ended
[28 Nov 2005 17:09] Valeriy Kravchuk
Please, send the content of your /etc/my.cnf and/or any other my.cnf you will find in /var or /usr or /home subdirectories. 

Looks like the directory for InnoDB tables (set by innodb_data_home_dir and/or innodb_data_file_path parameters) is not accessible to mysql user. Read the manual about that also (http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html).
[22 Dec 2005 20:34] Colin Faber
I'm having this same problem on a self-compiled version of mysql-5.0.15 on FreeBSD 6.0-STABLE.

I was upgrading from mysql 4.0.15.

All permissions are set correctly and all entries within the my.cnf file appear to be in order.
[29 Dec 2005 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[29 Dec 2005 11:56] Valeriy Kravchuk
All reporters:

Please, try to download and install 5.0.17 now available at http://dev.mysql.com/downloads/mysql/5.0.html. Inform about the results.
[30 Jan 2006 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[16 Sep 2007 15:52] Emerson Takahashi
If you start the mysqld as root user, the message 

070913 09:25:44  mysqld started
nohup: ignoring input
070913  9:25:44  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
070913 09:25:44  mysqld ended

appears. There is a "Security"section in the manual that shows how to run MySQL as root.