WampServer

Hi, please would anyone advise what to do here?

On phpMyAdmin - 2.11.6
When trying to add new user via privileges I get this error message:
"Error
SQL query:
SHOW COLUMNS FROM `mysql`.`user` ;
MySQL said: Documentation
#1 - Can't create/write to file 'C: emp\#sql_9dc_0.MYI' (Errcode: 22) "

There's also :
"Warning: Invalid argument supplied for foreach() in C:\wamp\apps\phpmyadmin2.11.6\server_privileges.php on line 572"

Running on localhost / Win XP sp2.

Mysql log reads:
"090224 5:41:29 InnoDB: Error: unable to create temporary file; errno: 22
090224 5:41:29 [ERROR] Default storage engine (InnoD is not available
090224 5:41:29 [ERROR] Aborting

090224 5:41:30 [Note] wampmysqld: Shutdown complete

090224 6:01:15 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
090224 6:03:26 [Note] wampmysqld: Normal shutdown

090224 6:03:26 [Note] wampmysqld: Shutdown complete

090224 6:04:00 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
090224 6:20:01 [Note] wampmysqld: Normal shutdown

090224 6:20:01 [Note] wampmysqld: Shutdown complete

090224 6:20:03 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)"



Had following error messages & followed advice for changes to be made to my.ini file:


Q=.Error message: MySQL log report:InnoDB: Error: unable to create temporary file; errno: 9
A=Take # away from front of skip inndb
R= IT WORKED:- no InnoDB: error message

Q= When trying to create new database user:
Error message: MySQL said: #1 - Can't create/write to file 'C:\wamp\tmp\#sql_bb8_0.MYI' (Errcode: 22)
A= Add the following lines to my.ini under [wampmysqld] section:
#Path to the database temp dir
tmpdir=C:\temp
[forum.wampserver.com]
The error is because MySQL doesn't have permission to write to its default tmp file.
Make sure there is a C:\temp folder
See [bugs.mysql.com]
R = DIDN'T WORK



My.ini file reads as:


# MySQL Server Instance Configuration File
......
[client]

port=3306


# SERVER SECTION
# ----------------------------------------------------------------------
.....
[wampmysqld]

#Path to the database temp dir
tmpdir=C:\temp

# The TCP/IP Port the MySQL Server will listen on
port=3306


#Path to installation directory. All paths are usually resolved relative to this.
basedir=c:/wamp/bin/mysql/mysql5.0.51b

#log file
log-error=c:/wamp/logs/mysql.log

#Path to the database root
datadir=c:/wamp/bin/mysql/mysql5.0.51b/data

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1

# The default storage engine that will be used when create new tables when
default-storage-engine=MyISAM

# The maximum amount of concurrent sessions the MySQL server will
# allow. .....allow the administrator to login even if the
# connection limit has been reached.
max_connections=255

# Query cache is used to cache SELECT results and later return them
# without actual executing the same query once again. Having the query
# cache enabled may result in ......
query_cache_size=8M

# The number of open tables for all threads. .....
table_cache=510

# Maximum size for internal (in-memory) temporary tables......
tmp_table_size=13M


# How many threads we should keep in a cache for reuse. .....
thread_cache_size=12

#*** MyISAM Specific options

# The maximum size of the temporary file MySQL is allowed to use while
# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE......
myisam_max_sort_file_size=100G

# If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here, ......
myisam_max_extra_sort_file_size=100G

# If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here, ......
myisam_sort_buffer_size=8M

# Size of the Key Buffer, used to cache index blocks for MyISAM tables.......
key_buffer_size=9M

# Size of the buffer used for doing full table scans of MyISAM tables.......
read_rnd_buffer_size=256K

# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. ......
sort_buffer_size=203K


#*** INNODB Specific options ***


# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
skip-innodb

# Additional memory pool that is used by InnoDB to store metadata
# information. ......
innodb_additional_mem_pool_size=2M

# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit,.......
innodb_flush_log_at_trx_commit=1

# The size of the buffer InnoDB uses for buffering log data. .....
innodb_log_buffer_size=1M

# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. ......
innodb_buffer_pool_size=15M

# Size of each log file in a log group. ......
innodb_log_file_size=10M

# Number of threads allowed inside the InnoDB kernel. .....
innodb_thread_concurrency=8



[mysqld]
port=3306

Quote

"Warning: Invalid argument supplied for foreach() in C:\wamp\apps\phpmyadmin2.11.6\server_privileges.php on line 572"

seems your phpmyadmin is corrupted, so you might need to reinstall it :-(

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

This is a re-install of WampServer2.0c
I removed all residual docs from un-install & ran a search for any php SQL & Apache stuff lurking on HD.
Not sure what I need to look for on regedit?? Any suggestions??
Ran ccleaner instead (specifically registry issues.)

Please advise?

run regedit to search and delete registries wampapache and wampmysql

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides