✎ MySQL Operating system error number 13 [NoSociety.de]

You've loaded an old revision of the document! If you save it, you will create a new version with this data.

====== MySQL Operating system error number 13 ======

===== Problem =====

The start of the Mysql server fails and in the //syslog// the following error message is displayed:

<code text>
Feb 23 19:30:50 v21080422 mysqld_safe[22878]: started
Feb 23 19:30:50 v21080422 mysqld[22881]: 100223 19:30:50  InnoDB: Operating system error number 13 in a file operation.
Feb 23 19:30:50 v21080422 mysqld[22881]: InnoDB: The error means mysqld does not have the access rights to
Feb 23 19:30:50 v21080422 mysqld[22881]: InnoDB: the directory.
Feb 23 19:30:50 v21080422 mysqld[22881]: InnoDB: File name ./ibdata1
Feb 23 19:30:50 v21080422 mysqld[22881]: InnoDB: File operation call: 'open'.
Feb 23 19:30:50 v21080422 mysqld[22881]: InnoDB: Cannot continue operation.
Feb 23 19:30:50 v21080422 mysqld_safe[22888]: ended
</code>

===== Solution =====

The problem is that the files required by MySQL have the wrong rights or the wrong user (groups). The following commands set the correct user ((as an example User: mysql Group:adm / adapt accordingly to your own configuration)).

==== Commands for user/group assignment ====

<file bash setuser-mysql.txt>
chown -R mysql /var/run/mysqld
chown -R mysql /var/lib/mysql
chown -R mysql /var/log/mysql

chgrp -R root /var/run/mysqld
chgrp -R adm /var/lib/mysql
chgrp -R adm /var/log/mysql
</file>

Please solve the following equation to prove you're human. 237᠎ -10 = Please keep this field empty:

Edit summary

Note: By editing this page you agree to license your content under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International