WampServer

I have uninstalled and reinstalled wampserver over and over again. but i still get an error when i try going to phpmyadmin

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

ive been reading up on it and trying to figure it out...

my mysql log says this

081120 15:01:16 [ERROR] Default storage engine (InnoD is not available
081120 15:01:16 [ERROR] Aborting

081120 15:01:16 [Note] wampmysqld: Shutdown complete

081120 15:01:28 [ERROR] Default storage engine (InnoD is not available
081120 15:01:28 [ERROR] Aborting

081120 15:01:28 [Note] wampmysqld: Shutdown complete

081120 15:01:43 [ERROR] Default storage engine (InnoD is not available
081120 15:01:43 [ERROR] Aborting

081120 15:01:43 [Note] wampmysqld: Shutdown complete

the first thing ive tried was switching
default-storage-engine=INNODB
to
default-storage-engine=MyISAM

but nothing has worked? any idea how to fix this?

wat colour is the wamp icon now that you changed that?

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

it is all white

then just open phpmydmin like before. on the page with the error on the bottom right click "open in new window"

if u get an error then .. post upu the entire error from the new page

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

ok i did that...it didnt give me error it actually opened up phpmyadmin....but i know it shouldnt be doing this because i had it running before and it all worked fine...but i ran into a problem with my webpage...so when i reinstalled wampserver i changed the stmp from localhost to my ip...which is 71.121.89.98...also when i add in my files for my forum and go to localhost or even my ip it doesnt load the page?

phpmyadmin wasnt working cos it was using the history in ie to load the error page. clear the history and that wont happen again now.

i dont understand the other problem? you shouldnt really have unistalled it for such a simple problem...

try explain the other problem in more detail

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

when i try to load localhost it gives me this error
Error: Unable to connect to MySQL server. MySQL reported: Can't connect to MySQL server on '71.121.89.98' (10060).

thats because myql is set to work only on localhost by default


edit your phpmyadmin.conf file


its in C:\wamp\alias




this is what you should have,,,

<Directory "c:/wamp/apps/phpmyadmin2.10.1/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
</Directory>


---------------------------------------------------------------------
since you know the ip address that will be connecting you could change it to

<Directory "c:/wamp/apps/phpmyadmin2.10.1/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
Allow from xx.xx.x.x
</Directory>


(xx.xx.x.x being the ip address u connect from)



IMPORTANT
*****************************************************
DONT COPY MY CODE DIRECTLY AS MY VERSION
OF PHPMYADMIN MAY BE DIFFERENT TO YOURS.

JUST CHANGE THESE LINES

Order Deny,Allow
Deny from all
Allow from 127.0.0.1

to

Order Deny,Allow
Deny from all
Allow from 127.0.0.1
Allow from 71.121.89.98
*****************************************************

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

that did not fix the problem

did u even make a user in mysql using that ip etc?

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

im new to this stuff so basicly i dont know how...ive just been using the default one...root with no password

do u need to connect to mysql over the web even?? or are u just using it on ur pc?

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

Hi, i'am portuguese so sorry for my bad english.

I post were because wend i try in mozilla firefox browser "[localhost]; the same error of Shadowz0flife happends.

I have installed wamp 2.0. But i can't start my MySql service to work.

I gived permission in my firewall to all services in my pc.

In the icon tray i make left click and in the section of MySql>services when i click "start/resume service" nothing happend.

I got to "C:\wamp\logs\mysql" and this is the last entry:
081121 3:40:24 InnoDB: Error: unable to create temporary file; errno: 9
081121 3:40:24 [ERROR] Default storage engine (InnoD is not available
081121 3:40:24 [ERROR] Aborting

081121 3:40:24 [Note] wampmysqld: Shutdown complete

I tried manually, in the control panel>Administrative Tools>services i search for "wampmysqld". A error occur

"Could not start the wampmysqld service on Local Computer.
Error 1067: The process terminated unexpectedly."

in the log file:
"081121 3:43:22 InnoDB: Error: unable to create temporary file; errno: 9
081121 3:43:22 [ERROR] Default storage engine (InnoD is not available
081121 3:43:22 [ERROR] Aborting

081121 3:43:22 [Note] wampmysqld: Shutdown complete".

I use the command

C:\>sc query MySql
[SC] EnumQueryServicesStatus:OpenService FAILED 1060:

The specified service does not exist as an installed service.

I don't have the service installed? Why? Can you help me please.

open my.ini and find
default-storage-engine=INNODB
Change to:
default-storage-engine=MyISAM

Have fun,

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

Thank you!! Now a can go to sleep!! :d

THis is interesting. My question is, why does changing this setting to MyISAM fix this problem?

well there is loads of engines in mysql.. (the program used to write the tables) innodb needs certain setting in the server as well as on the pc for it to work, most of the time it does work ... the odd time it doesnt work on pcs. the problem is - mysql doesnt give much information as to why it fails.. but sometimes the mysql log will have some decent information as to why liike error writing the PID file etc or idblog being too full


if you dont know that myisam and innodb are then most likely it wont matter one bit which one you use. myisam is column locking , and innodb is row locking.. innodb is only needed when mayeb u need to search two table at the same time when using a key ,(but u can use it if you want, most websites use innodb as standard now as overall it is more reliable)

also InnoDB stores data rows physically in primary key order while MyISAM typically stores them mostly in the order in which they are added.
InnoDB offers greater availability and reliability as database sizes grow. its seek time remain the same no matter what the size of table where as Myisams seek times take linger as the table gets bigger

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



Edited 1 time(s). Last edit at 11/25/2008 11:32PM by stevenmartin99.