WAMP MySQL Service will not start
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Dream Voyager Looping
--
Chapters
00:00 Wamp Mysql Service Will Not Start
00:30 Accepted Answer Score 3
01:54 Answer 2 Score 3
02:08 Answer 3 Score 16
02:38 Answer 4 Score 3
02:57 Thank you
--
Full question
https://superuser.com/questions/321744/w...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#php #mysql #phpmyadmin #wamp
#avk47
ANSWER 1
Score 16
I tried going to: C:\wamp\bin\mysql\mysql5.6.17\data and deleted the following:
auto.cnf, xxxxxxxxx.err, xxxxxxxxx.pid, ib_logfile0 and ib_logfile1
But I left the ibdata1 alone as it references all local databases. I then restarted wamp and it worked like a charm.
ACCEPTED ANSWER
Score 3
Error No. 2003: Can't connect to MySQL server on 'localhost' (or some other host)
simply means that connection is not possible for one of the following (or similar) reasons:
There is no MySQL server running at the specified host
Connection to the MySQL server is not allowed using TCP-IP. Check the 'skip-networking' setting in the MySQL configuration file (my.ini on Windows, my.cnf on Unix/Linux). It shall be commented out like '#skip-networking'. If it is not commented out, then do it and restart the MySQL server for the change to take effect.
Some networking issue prevents connection. It could be a network malconfiguration or a firewall issue. You need to allow the service mysql on windows firewall/ after you install wamp, restart ur pc. and start wamp
windows will ask is msqlnt.exe allowed to run and accept it then its fine.
If it doesn't work then:
Try turning off the windows firewall - if that fixes the problem, then turn it back on, and allow access to TCP/3306(default port)
- When trying to connect to a MySQL server at an ISP this error message often indicates that direct connection to MySQL has been blocked. You must then use HTTP-tunneling or SSH-tunneling to connect.
ANSWER 3
Score 3
Search for mysql-bin.index file, delete it, then restart MySQL.
This worked for me ;)
ANSWER 4
Score 3
Please check the port that MySQL is using on your system. Then, change the port number of the WAMP server's MySQL service to that number by entering it in my.ini.
If you're running Windows, make sure to restart service and it immediately turns green.
I ran into a similar problem.