mySQL Permissons

Problems with the Linux version of XAMPP, questions, comments, and anything related.

mySQL Permissons

Postby josh100 » 28. March 2006 23:24

Hey, i've had great success with xampp on windows, but i'm having a bit of trouble with it on linux, I think it has something to do with permissions.

My problem is, I can't create any new tables in phpmyadmin, I just keep getting returned the error

MySQL said:
#1 - Can't create/write to file '/root/tmp/#sql_1c03_0.MYI' (Errcode: 13)

Anyone have any ideas?

It's probably something really simple

Thanks :)
josh100
 
Posts: 1
Joined: 21. March 2006 23:31

Postby thorsin » 29. March 2006 13:46

indeed, it is....
as the error tells you, check if the directory /root/tmp exists and is writable... best would be to switch to the default mysql-dir and NOT run mysql as root!!!!!! create a user called mysql and run mysql with this new user. read more about it at debianhowto.com for example...
User avatar
thorsin
 
Posts: 136
Joined: 05. March 2006 20:39

Postby Wiedmann » 29. March 2006 14:51

Cool, we have a search function. And 3 threads under yours you can find:
http://community.apachefriends.org/f/viewtopic.php?t=16924
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 32 guests