phpMyAdmin User Create Error

[geoff]

When trying to create a new user, it will not let me set up privilages. instead is shows a error:

Quote:Error

SQL query:

SHOW COLUMNS FROM `mysql`.`user` ;

MySQL said: Documentation
#1 - Can't create/write to file 'C:\Documents and Settings\Geoff\Desktop\Lighty2Go\Lighty2Go\MySQL\data\TMP\#sql_17b8_0.MYI' (Errcode: 2)

-Geoff
BTW - anything on php-fusion compatability?

[geoff]

geoff Wrote:When trying to create a new user, it will not let me set up privileges. instead is shows a error:

Quote:Error

SQL query:

SHOW COLUMNS FROM `mysql`.`user` ;

MySQL said: Documentation
#1 - Can't create/write to file 'C:\Documents and Settings\Geoff\Desktop\Lighty2Go\Lighty2Go\MySQL\data\TMP\#sql_17b8_0.MYI' (Errcode: 2)

-Geoff
BTW - anything on php-fusion compatability?

err. I figured it out...doesn't accept spaces in directory names

[Tom]

Still looking into the php-fusion thing --

And on a separate note i might be on to a fix for more issues related to paths with spaces.

Thanks for posting..

--Tom

[Guest]

I havent spaces in path, but still have an error, when creating/opening tables!
Wrotes:
//--------------------------------------------------------
Error

SQL query: Edit

SHOW FULL FIELDS FROM `vb2` ;

MySQL said: Documentation
#1 - Can't create/write to file 'C:\Lighty\MySQL\data\TMP\#sql_9f0_0.MYI' (Errcode: 2)
//---------------------------------------------------------
OS: WinXP PRO SP2.

[quietly]

Guest Wrote:I havent spaces in path, but still have an error, when creating/opening tables!
Wrotes:
//--------------------------------------------------------
Error

SQL query: Edit

SHOW FULL FIELDS FROM `vb2` ;

MySQL said: Documentation
#1 - Can't create/write to file 'C:\Lighty\MySQL\data\TMP\#sql_9f0_0.MYI' (Errcode: 2)
//---------------------------------------------------------
OS: WinXP PRO SP2.

i had the same problem a few minutes ago... after looking through a few config files and finding nothing amiss, i took a quick look at the folder structure and realized; of course it can't write to "\LightTPD\MySQL\data\TMP\", because... well... it simply can't write to a directory if the specified directory doesn't exist!

So, if there isn't one there already, creating a \TMP\ directory within MySQL's \data\ folder should fix the problem



-Q

[Guest]

Thanks, simply i didn't check "TMP" folder existence, but now, when i created it, all works fine!

[Tom]

great pick-up quietly!
I've gotta stop checking the posts so late at night.
I also made another minor change to the package so I will add the TMP folder to the MySQL\data directory and I will be rolling out a v1.3 in a few days.

Thanks again

--Tom

[Guest]

#1 - Can't create/write to file 'C:\xampp\tmp\#sqla48_5_0.MYI' (Errcode: 2)
is the error that occurs mhwen i click on thephpmyadmin of wamp server....even the xampp server is not installed any more on my pc..can u tell me the soloution????

---

#1 - Can't create/write to file 'C:\xampp\tmp\#sqla48_5_0.MYI' (Errcode: 2) this error is generated when i click on the mysqladmin of the wamp server..even the xampp server is not installed on my pc.

[maxcreigs]

That nearly always means you're trying to access a database that you do not have permissions to access... or not? It's really odd how you cannot seem to access the databases as 'root' though...
I remember once when I accidentally dropped the 'root' permissions in the `mysql` database; boy, that was a mess! I had to delete the mysql files, re-install MySQL and restore all the databases off a recent backup.
I really don't know about MySQL on Linux, I am still struggling with Linux at the moment so unless someone who uses Linux extensively, reads this and replies, I am also interested to know how you will eventually solve this.