View Issue Details

IDProjectCategoryView StatusLast Update
0008010CentOS-7mariadbpublic2014-12-17 14:19
Reporterrolivastro Assigned To 
Status newResolutionopen 
Platformx86_64OSLinuxOS Version7.0.1406
Product Version7.0-1406 
Summary0008010: error to create tmp files
Descriptionwhen mariadb is going to create tmp files, used by internals process or even when we decided to create temp tables manually, an error ocurr because there is no permission in "/var/tmp" directory.

to fix it, we need to change the tmp default directory in /etc/my.cnf, including a line like:

tmpdir = /tmp

this will change the default tmp table from "/var/tmp" to "/tmp"
Steps To Reproducestart mariadb and try do see the description of any table, for example:

use mysql;
desc user;

you will se the access denied error, because the directory "/var/tmp" hasnĀ“t permission to allow this process.

changing the tmp directory to "/tmp" the problem disapear.
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2014-12-17 14:19 rolivastro New Issue