mySQL Permissons

[josh100]

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

[thorsin]

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...

[Wiedmann]

Cool, we have a search function. And 3 threads under yours you can find:
http://community.apachefriends.org/f/viewtopic.php?t=16924