WampServer

Hi, I just recently started using Wamp (Great Job!). When I click on "privileges" and then "add user". I've received the following error :

-------------------------
Add a new User

Warning: Invalid argument supplied for foreach() in O:\wamp\phpmyadmin\server_privileges.php on line 562




Error
SQL query:

SHOW COLUMNS FROM `mysql`.`user` ;



MySQL said:

#1 - Can't create/write to file 'O:\wamp\mysql\data\%root%\Temp\#sql_1018_0.MYI' (Errcode: 2)

Hi!

I have the same problem. I have searched this forum and the web for the answare, but i didn't found it. Can anybody help me?

Thx.

read my manual

CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!

Please visit my latest website Clarify Loans:
clarifyloans.com

Thx, i read it. Actually i read it before my first letter too. But i didn't find the answer.

My problem is:
After clicking on Privileges/Add a new user i see this as result:

[img170.imageshack.us]

If you know the answer please let me know.

Thx, regards,
Tamicsko

If you don't have any db and data yet, suggest to uninstall and reinstall wamp. If already have some, backup before doing so.

Have fun,

[www.jlbn.net] (testing WAMPS on Vista)
[test.jlbn.net] (testing codes on Vista)

Thx for help!

During my wamp server update, the same problem occured agin.
I've searched the net again and finally i have a solution:

Add the following lines to my.ini under [wampmysqld] section:

#Path to the database temp dir
tmpdir = c:/wamp/tmp

It works . ( of course, with the right wamp path )