FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Can't get into myphp : error message ... (10061)





An1vad
wanting to set-up as scratch patch on localhost to mess about in Drupal before going live.
Followed install instructions & installed Wampserver 2.0c on WinXP sp2 .

Error message on http://localhost/phpmyadmin/:
phpMyAdmin 2.11.6
Error
MySQL said:
#2003 - Can't connect to MySQL server on 'localhost' (10061)

The wampserver speedometer icon is mostly yellow.

mysql log says:
Log file:
090114 7:58:44 InnoDB: Error: unable to create temporary file; errno: 22
090114 7:58:44 [ERROR] Default storage engine (InnoDB) is not available
090114 7:58:44 [ERROR] Aborting

090114 7:58:44 [Note] wampmysqld: Shutdown complete

please advise, needing help desperately?
Thanks in advance
Cheers D.
rvec
you shouldn't use innodb , your mysql instalation doesn't support it.
You can open the my.ini file (mysql config) and change this line:
Code:
default-storage-engine=INNODB

to
Code:
default-storage-engine=MyISAM
An1vad
Many thanks, that works!!
Great that you responded soo quickly!! Namaste.
So I've changed in C:\wamp\bin\mysql\mysql5.0.\my.ini file.

Waited 2 days for response from wampserver.com
In addition they advised:
Backups(Beginner)
.....default-storage-engine=<<{MIXED|INNODB:INNODB}{:MYISAM}>>
in the file (my-template) in the C:\wamp\bin\mysql\mysql5.1.30 directory.

default-storage-engine=MyISAM

This line is keypoint, so just *comment out the original line and add this line right under it Wink


*So it now reads as:
......
# The default storage engine that will be used when create new tables when
default-storage-engine=<<{MIXED|INNODB:INNODB}{:MYISAM}>>
default-storage-engine=MyISAM
.......

It is working tho.
Any comments??

Cheers & thanks again.
rvec
don't know what that line means, but looks like the second line would overrule it and make mysql just ignore the first line.
Related topics
How to stop "Script Debugger" Error Message in IE
Error message......
SUSE Linux 10 apache installation
missing template file error message
MySQL error
500 Internal Server Error!
Error I can't seem to fix.
Old hardware needs OS [SOLVED]
Registeration System (Nice Error Logging) Please feedback
Vista's removed secret error message.
Message Error: phpMyAdmin: Cannot Load mcrypt
Perl Error Message
help me in installing ns 2
Windows error message jokes
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.