Mysql Error
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: January 02, 2008 09:16PM

Welcome to phpMyAdmin 2.10.1

Error
MySQL said:

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



i have set up wamp 2.0 and when i go to use phpmyadmin it doesnt work. then i realised mysql isnt working. tried earlier versions of mysql too but same problem.

[localhost] does open up the wampserverpage and even sqlite opens

in my phpinfo() file my sql looks like this


mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.45

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off





looked up my ports and 3306 is listening so i presume mysql is running? or could something else be using this port? there is a service running called wampservermysqldnt i think its called..
iv tried to run mysql command box and it failes to connect also with the same error-

Can't connect to MySQL server on 'localhost' (10013)

anyone have any idea?


if anyone wants to see this isa section of the mysql logfile

InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080102 20:24:13 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
080102 20:24:14 InnoDB: Started; log sequence number 0 0
080102 20:24:14 [Note] wampmysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080102 20:27:48 [Note] wampmysqld: Normal shutdown

080102 20:27:48 InnoDB: Starting shutdown...
080102 20:27:50 InnoDB: Shutdown completed; log sequence number 0 43655
080102 20:27:50 [Note] wampmysqld: Shutdown complete



Edited 1 time(s). Last edit at 01/02/2008 09:30PM by stevenmartin99.

Options: ReplyQuote
Re: Mysql Error
Posted by: student101 (---.saix.net)
Date: January 04, 2008 08:18AM

Not an actual guru at this wamp stuff,
you could try backing up your data like sites, databases and so on...
Then remove any mysql, php, wamp related and reload it again from scratch - but don't play like loading a different version of PHP or MySQL and so on afterwards.

Not sure give it a try.
Cheers

Options: ReplyQuote


Sorry, only registered users may post in this forum.