Article ID: 6391, created on Jun 1, 2009, last review on May 11, 2014

  • Applies to:
  • Pro Control Panel Linux 10.3.0

Symptoms

Sites that use MySQL does not work in Parallels Pro 10.3.0/10.3.4 and following error is returned in the browser or in MySQL log:

user warning: Can't create/write to file '/var/lib/mysql/#sql_1a6f_0.MYI' (Errcode: 13)

Cause

The problem is related to ~mysql directory permission.

'mysql' user is not able to create a temporary file in /var/lib/mysql/ directory due to permissions lack :

# ls -lda ~mysql/

drwxr-xr-x 5 root mysql 4096 Aug 31 09:56 /var/lib/mysql/

Resolution

The solution is to go to /etc/init.d/mysqld_app_init file and change

        chown root.mysql /var/lib/mysql

line to

        chown mysql.mysql /var/lib/mysql

 

Then restart mysqld service or just change owner of /var/lib/mysql directory to "mysql" instead of "root":

# chown root /var/lib/mysql

3c1bb9f3c3b8305757c406e39a7aa454 3ccb419cf98083f3bb45808fba8dbc7c 4cc899da08664637a8bc437308d3ddd7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF