WampServer

Hi,

I have installed wamp2c.exe but it is not working. Apcache is working but Mysql is not working. It started but after 1 min or so Mysql shutdown. I had Wamp5 installed in my H: Drive ( Window Xp in D: ) . I have uninstalled Wamp5 and deleted it's folders from H: . I have installed Wamp2 on H: but it was giving same error in log file. Then i try to install it on J: drive but still it is not working . Here's the logs of Mysql

InnoDB: a new database to be created!
080525 23:10:43 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080525 23:10:44 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080525 23:10:44 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080525 23:10:45 InnoDB: Started; log sequence number 0 0
080525 23:10:45 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080525 23:10:45 [ERROR] TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS
080525 23:10:45 [ERROR] Aborting

080525 23:10:45 InnoDB: Starting shutdown...
080525 23:10:47 InnoDB: Shutdown completed; log sequence number 0 43655
080525 23:10:47 [Note] wampmysqld: Shutdown complete

080525 23:11:42 InnoDB: Started; log sequence number 0 43655
080525 23:11:42 [Note] wampmysqld: ready for connections.
Version: '5.0.51b-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080525 23:11:42 [ERROR] TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS
080525 23:11:42 [ERROR] Aborting

080525 23:11:42 InnoDB: Starting shutdown...
080525 23:11:44 InnoDB: Shutdown completed; log sequence number 0 43655
080525 23:11:44 [Note] wampmysqld: Shutdown complete


Please help !!!

Thanks

Try this:

Left click on wamp tray icon, then MySQL, then my.ini to open this file, then:

Find:
default-storage-engine=InnoDB

Change to:
default-storage-engine=MyISAM

Save file and restart wamp to take effect

Have fun,

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

Hi,

Thanks for your reply. But it didn't work. I have made changes as you described above. However, it didn't solved my problem and it is showing the same Error messages as above.

Thanks

strange error to get... whats the name of your computer... as in,, whats your user name for windows ,,, and what version of windows?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hi,

My computer has only one administration user with the name of vivek narula. I am using WindowXP service pack 2.

I have tried to install wamp2 on my D: drive (where my windows is ) and one again on H: drive but still i am getting that same error message in my mysql error log file.


Please help me to sort this out.

Thanks

open c:/wamp/bin/mysql/mysql5.0.51b/ my.ini

find this
-----------------------------------------------


[wampmysqld]

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


-----------------------------------------------




and change it to
-----------------------------------------------


[wampmysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306
skip-networking
enable-named-pipe


-----------------------------------------------

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Thanks Steven,

This works fine now. However, now my phpmyadmin is not connecting it is giving me this error
"#2003 - Can't connect to MySQL server on 'localhost' (10061)" I had tried Googling it and in of the forums i found that we can do with adding port 3306 in window's firewall. I tried that one as well but still it is not working for me.

Sqlite is working. i have adding an record in Sqlite's default Test database's table.

Please help.

Vivek

in the file 3306 is written 3times

put this under each

skip-networking
enable-named-pipe

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Thanks Steven for you prompt reply.

I have put them under all 3 but still it is not working. it is still giving me the access denied with this same error message.

#2003 - Can't connect to MySQL server on 'localhost' (10061)


Thanks for all of your hardwork and help.

sorry about that


try just


port=3306
enable-named-pipe

in the orginal postion i told you. hopefully that will fix your error and allow phpmyadmin to work

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

No worries, it's fine.

No, it's still not working. I tried this already by putting just "enable-named-pipe" in the original position and in below to all 3 "3306".


Thanks

Anyone can solve my problem ?

do u wanna just try changing the port in the my.ini to 3307 .. change all 3

and delete the skip networking bit u added before.. is it possiible something else is on this port?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]