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: | |
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
[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.