WampServer

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

PhpMyAdmin NEVER works.

I've tried EVERYTHING on here. 10 times over.

I've modified the ini from InnoDB to MyISAM, checked the config files, all that.

I always get this message.

For the past 10 days or more. The phpmyadmin page came up ONCE in the beginning of all this, and soon after, just gave the error page. Then I uninstalled and re-installed, and it's never come up since, in 9 more tries.

I've gone through the registry and deleted wamp keys, and deleted any folders of the C drive.

I'm going to try for the last time today, if I can get some help, then that's it.

This program is turning out to be total garbage and a waste of A LOT of my time.



Edited 1 time(s). Last edit at 04/18/2008 03:37PM by Geezer D.

hi i can help u fix this. it just takes a lil time cos there is so much to check with this error.

tell me this..
what colour is your wamp icon?
what port is apache running on
what port is mysql running on?

and can you post up ur logs fromthe log folder at c:/wamp/logs httpd and mysql logs



Edited 1 time(s). Last edit at 04/18/2008 03:48PM by stevenmartin99.

The icon is all white when set to online, white with a black square in the middle when offline.

Default ports, I suppose, I didnt change anything, its a new install.
How can I find out? Why would they not be on the default?

There is NO httpd log in the c:/wamp/logs folder, and the mysql log is BLANK


This is some of the apache error log, from the bottom:

[Fri Apr 18 10:03:55 2008] [notice] Server built: Jan 18 2008 00:37:19
[Fri Apr 18 10:03:55 2008] [notice] Parent: Created child process 3032
[Fri Apr 18 10:03:59 2008] [notice] Child 3032: Child process is running
[Fri Apr 18 10:03:59 2008] [notice] Child 3032: Acquired the start mutex.
[Fri Apr 18 10:03:59 2008] [notice] Child 3032: Starting 64 worker threads.
[Fri Apr 18 10:03:59 2008] [notice] Child 3032: Starting thread to listen on port 80.
[Fri Apr 18 10:05:16 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Fri Apr 18 10:05:16 2008] [notice] Child 3032: Exit event signaled. Child process is ending.
[Fri Apr 18 10:05:17 2008] [notice] Child 3032: Released the start mutex
[Fri Apr 18 10:05:18 2008] [notice] Child 3032: All worker threads have exited.
[Fri Apr 18 10:05:18 2008] [notice] Child 3032: Child process is exiting
[Fri Apr 18 10:05:18 2008] [notice] Parent: Child process exited successfully.
[Fri Apr 18 10:05:22 2008] [notice] Apache/2.2.8 (Win32) PHP/5.2.5 configured -- resuming normal operations
[Fri Apr 18 10:05:22 2008] [notice] Server built: Jan 18 2008 00:37:19
[Fri Apr 18 10:05:22 2008] [notice] Parent: Created child process 3920
[Fri Apr 18 10:05:24 2008] [notice] Child 3920: Child process is running
[Fri Apr 18 10:05:24 2008] [notice] Child 3920: Acquired the start mutex.
[Fri Apr 18 10:05:24 2008] [notice] Child 3920: Starting 64 worker threads.
[Fri Apr 18 10:05:24 2008] [notice] Child 3920: Starting thread to listen on port 80.




This is some of the bottom of the access.log file:

127.0.0.1 - - [18/Apr/2008:09:11:11 -0400] "GET /index.php?img=pngFolderGo HTTP/1.1" 200 694
127.0.0.1 - - [18/Apr/2008:09:11:12 -0400] "GET /phpmyadmin/print.css HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:11:12 -0400] "GET /phpmyadmin/themes/original/img/b_help.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:11:12 -0400] "GET /phpmyadmin/themes/original/img/s_error.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:11:12 -0400] "GET /phpmyadmin/themes/original/img/window-new.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:25:41 -0400] "GET / HTTP/1.1" 200 4066
127.0.0.1 - - [18/Apr/2008:09:25:41 -0400] "GET /index.php?img=gifLogo HTTP/1.1" 200 5172
127.0.0.1 - - [18/Apr/2008:09:25:41 -0400] "GET /index.php?img=pngPlugin HTTP/1.1" 200 548
127.0.0.1 - - [18/Apr/2008:09:25:41 -0400] "GET /index.php?img=pngWrench HTTP/1.1" 200 741
127.0.0.1 - - [18/Apr/2008:09:25:41 -0400] "GET /index.php?img=pngFolderGo HTTP/1.1" 200 694
127.0.0.1 - - [18/Apr/2008:09:25:43 -0400] "GET /phpmyadmin/print.css HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:25:43 -0400] "GET /phpmyadmin/themes/original/img/b_help.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:25:43 -0400] "GET /phpmyadmin/themes/original/img/s_error.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:25:43 -0400] "GET /phpmyadmin/themes/original/img/window-new.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:55:17 -0400] "GET / HTTP/1.1" 200 4066
127.0.0.1 - - [18/Apr/2008:09:55:18 -0400] "GET /index.php?img=gifLogo HTTP/1.1" 200 5172
127.0.0.1 - - [18/Apr/2008:09:55:18 -0400] "GET /index.php?img=pngPlugin HTTP/1.1" 200 548
127.0.0.1 - - [18/Apr/2008:09:55:18 -0400] "GET /index.php?img=pngWrench HTTP/1.1" 200 741
127.0.0.1 - - [18/Apr/2008:09:55:18 -0400] "GET /index.php?img=pngFolderGo HTTP/1.1" 200 694
127.0.0.1 - - [18/Apr/2008:09:55:20 -0400] "GET /phpmyadmin/print.css HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:55:20 -0400] "GET /phpmyadmin/themes/original/img/b_help.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:55:20 -0400] "GET /phpmyadmin/themes/original/img/s_error.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:55:20 -0400] "GET /phpmyadmin/themes/original/img/window-new.png HTTP/1.1" 304 -
127.0.0.1 - - [18/Apr/2008:09:57:04 -0400] "GET /apps/phpmyadmin2.11.5 HTTP/1.1" 404 219
127.0.0.1 - - [18/Apr/2008:09:57:05 -0400] "GET /apps/phpmyadmin2.11.5 HTTP/1.1" 404 219
127.0.0.1 - - [18/Apr/2008:09:58:57 -0400] "GET /sqlitemanager/ HTTP/1.1" 200 554
127.0.0.1 - - [18/Apr/2008:09:58:58 -0400] "GET /sqlitemanager/left.php? HTTP/1.1" 200 1226
127.0.0.1 - - [18/Apr/2008:09:58:58 -0400] "GET /sqlitemanager/theme/green/left.css HTTP/1.1" 200 2422
127.0.0.1 - - [18/Apr/2008:09:58:58 -0400] "GET /sqlitemanager/theme/green/pics/sqlitemanager.png HTTP/1.1" 200 2941
127.0.0.1 - - [18/Apr/2008:09:58:58 -0400] "GET /sqlitemanager/main.php? HTTP/1.1" 200 5359
127.0.0.1 - - [18/Apr/2008:09:58:58 -0400] "GET /sqlitemanager/theme/green/pics/bg_title.png HTTP/1.1" 200 148
127.0.0.1 - - [18/Apr/2008:09:58:58 -0400] "GET /sqlitemanager/theme/green/pics/database2.png HTTP/1.1" 200 858
127.0.0.1 - - [18/Apr/2008:09:58:58 -0400] "GET /sqlitemanager/theme/green/menu/theme.css HTTP/1.1" 200 5863
127.0.0.1 - - [18/Apr/2008:09:58:59 -0400] "GET /sqlitemanager/theme/green/main.css HTTP/1.1" 200 8584
127.0.0.1 - - [18/Apr/2008:09:58:59 -0400] "GET /sqlitemanager/include/function.js HTTP/1.1" 200 3632
127.0.0.1 - - [18/Apr/2008:09:58:59 -0400] "GET /sqlitemanager/include/JSCookMenu.js HTTP/1.1" 200 22972
127.0.0.1 - - [18/Apr/2008:09:58:59 -0400] "GET /sqlitemanager/theme/green/menu/theme.js HTTP/1.1" 200 1774
127.0.0.1 - - [18/Apr/2008:09:58:59 -0400] "GET /sqlitemanager/jscalendar/calendar-win2k-1.css HTTP/1.1" 200 5986
127.0.0.1 - - [18/Apr/2008:09:58:59 -0400] "GET /sqlitemanager/jscalendar/calendar.js HTTP/1.1" 200 49237
127.0.0.1 - - [18/Apr/2008:09:58:59 -0400] "GET /sqlitemanager/jscalendar/lang/calendar-en.js HTTP/1.1" 200 3602
127.0.0.1 - - [18/Apr/2008:09:59:00 -0400] "GET /sqlitemanager/jscalendar/calendar-setup.js HTTP/1.1" 200 8852
127.0.0.1 - - [18/Apr/2008:09:59:00 -0400] "GET /sqlitemanager/theme/green/pics/bg.png HTTP/1.1" 200 188
127.0.0.1 - - [18/Apr/2008:09:59:00 -0400] "GET /sqlitemanager/theme/green/pics/bg_th.png HTTP/1.1" 200 370
127.0.0.1 - - [18/Apr/2008:09:59:00 -0400] "GET /sqlitemanager/theme/green/pics/input.png HTTP/1.1" 200 94

ok well it doesnt sound good that its empty... mysql log should have something in it... but its strnage because its running if the icon is white...
try a change of ports on mysql to see if u can get some info in the mysql log...


open c:wamp/bin/mysql/ my.ini and change 3306 to 3307 it is in the file 3 times


----------------
[client]

port=3306

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

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

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

[mysqld]
port=3306

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

No, that didn't work. Still just the error message.
I DO see"Welcome to phpMyAdmin 2.11.5" at the top of the page, so I'm on the page, it's just MySQL isnt being allowed, right? The problem is the MySql part of this?
Is this actually MySQL, or some screwed up variant of it?


Thanks for helping me, btw



Edited 1 time(s). Last edit at 04/18/2008 04:42PM by Geezer D.

Did you ever had any db server or any other wamp package before?

Have fun,

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

no if uv installed it properly and not messed it up with reinstalls then its a proper copy.. if ur wamp icon is white then that is good. try click "open new window" on that page with the error ...



else we will have to look up whats on what port

I previously had PHP, MySQL and Apache installed seperately, but the video tutorial I have is using WAMpserver, so I uninstalled them, as well as ColdFusion, just in case, and am trying to install WAMPserver, so I can do the tutorial.

I uninstalled all Windows .NET from Add Remove programs, too.

I tried opening on new page, nothing.

Also, the mysqld-nt.exe part of this NEVER stops regularly, I have to kill it through Task Manager every time.

Quote

I previously had PHP, MySQL and Apache installed seperately

That's the problem :-(
Most people had this problem because they've already had Apache and/or DB before using this wamp, and there is nothing wrong w/ this wamp if you've never had any other wamp package. Anyway, you need to clean all of their registries as well before reinstall this wamp

Have fun,

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

I did that every time.

How do you clean the registry?

I just searched for "Apache" "MySQl" and PHP and deleted everything

Is there some other thing I'm missing?

yes wamp use wampapache and wampmysqld-nt

search for wamp

And make sure to search and delete in registry, not just in windows only

Have fun,

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

Just went through the registry and deleted everything with wamp, apache, and mysql

Downloaded wampserver exe again

Installed it

Same error message with phpmyadmin

11th try, now

I really don't even know why I'm doing this, what is this program even for?

I had Apache, MySQL and PHP5 on here, and MySQL GUI Tools, why would I even need this (obviously poorly written) program?

I think I'm going to toss this tutorial that uses it, I can't imagine the tutorial being worth watching if it uses this garbage program.

this is a web server?

its not stupid. it works perftectly . everytime for me. never had a problem installing it.


u messed up ur pc with other stupid programs that dont uninstall themselves properly.


what tuturial? any server shud run it

NO, it's just for testing, not a server.

I had MySQL, MySQL GUI Tools, Apache and PHP5 on here, all worked great. I wanted to follow along on a tutorial which was using this, so I wanted to try it.

"Other stupid programs" cause this one to not function? And no one knows what programs?
Why does everything else on my pc work like a charm, then?

And I havent installed anything on the pc since I started messing with this crap, I havent had the time, it's all I've been working on for the past 4 or 5 days.

this is a server... it will work for more thenjust testing.. i run websites on it...


its not hard to set up....

Quote

I had MySQL, MySQL GUI Tools, Apache and PHP5 on here, all worked great

So you never uninstalled and delete their registries before installing this wamp???

Anyway, I've installed wampserver on a lot of different computer/laptops from brands names to no- name, and already installed wamp2a on more than 50 machines, and never had any problem, or might be just some minor problems which were resolved w/i minutes

BTW, if you've already had Apache, MySQL and PHP, not sure why you like to have another webserver on same machine??? Everything should work the same, except Menu Tray icon

Have fun,

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