Tuesday, July 30, 2013

MySQL, InnoDB: Operating system error number 13 in a file operation

Yeahh, it took me about an hour to two to figure it out.
I am using LAMPP 1.7 (old yes but i just personally decided
to use it) in Fedora14 64bit.
 
The steps were:
1. Check the error in your /opt/lampp/var/mysql/.err
    ** it is assumed that you copy the extracted xampp-linux-xxx.tar.gz in
         your /opt
2. What got from #1

130730 13:12:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130730 13:12:59  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 /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

3. And then i just chmod 777 -Rf /opt/lampp/var/mysql
4. Problem solved and hopefully not to add a new one :)

Hope it helps.

1 comment:

Nine Stars said...

PT. Nine Stars Futures merupakan sebuah perusahaan Pialang Berjangka yang menyediakan berbagai macam fasilitas, mulai dari trading Forex & Gold, Index Saham Asia, dan Komoditi.