mysql server is not responding
Posted by: shamoo (---.rdns.blackberry.net)
Date: November 27, 2012 12:03AM

Hey,I install wampserver 2.2 and it working properly,I wanted to set a password to phpmyadmin, so I go to c/wamp/apps/phpmyadmin 3.4.2 and I open config.inc.php and I change $cfg['Servers'][$i]['password'] = '888'; and $cfg['Servers'][$i]['AllowNoPassword'] = false;I don't know what went wrong and mysql service stop working,

Options: ReplyQuote
Re: mysql server is not responding
Posted by: robmillion (---.static.dsl.dodo.com.au)
Date: November 28, 2012 12:12AM

Did you Stop the MySQL service and then re-Start it after editing the config.inc.php file? You may also need to Stop & Start Apache after making changes to any of the config files.

Also, you may need to change:

>> $cfg['Servers'][$i]['user'] = ''; // remove username entry

Options: ReplyQuote
Re: mysql server is not responding
Posted by: RiggsFolly (---.ppp.as43234.net)
Date: November 28, 2012 10:19AM

Do you mean MySQL stopped working or that phpMyAdmin will not let you into your databases any more.


The order of event is supposed to be:
1. add a password to the root userid ( using phpMyAdmin )
2. Change the phpMyAdmin config file ( like you did ) to use the password you set up.

So change the phpMyAdmin config file back to have no password and allow NoPassword, then start again at point 1.



Read this.
[forum.wampserver.com]

Options: ReplyQuote
Re: mysql server is not responding
Posted by: shamoo (---.rdns.blackberry.net)
Date: November 28, 2012 01:14PM

Thanks for the quik respond,
Riggsfolly
I mean mysql stop working,wamps management console is still orange,and i try to go phpmyadmin and it giving me this erro ,server is not responding(or the local Mysql server's socket is not correctly configured),and I check apache is working,I stopped the apache and start it again, but it giving me same erro.

Options: ReplyQuote
Re: mysql server is not responding
Posted by: RiggsFolly (---.as13285.net)
Date: November 28, 2012 11:21PM

Well in that case what does it say in your MySQL Log file?
Also check in the Event viewer, MySQL errors are also reported in there.

Options: ReplyQuote
Re: mysql server is not responding
Posted by: shamoo (---.rdns.blackberry.net)
Date: November 29, 2012 08:32AM

There is no log file in c:/wamp/logs/mysql.log file, and I check even viewer it give the following error. Level: error.source: service control manager.even I'd: 7000.task category: none,level:error.source: mysql.event I'd:100.task category:none

Options: ReplyQuote
Re: mysql server is not responding
Posted by: shamoo (---.rdns.blackberry.net)
Date: November 29, 2012 08:40AM

It also give the following error in the even viewer,the wampmysqld service failed to start due to the following error:the system cannot find the file specified.I re install the wampserver but it still give the error.

Options: ReplyQuote
Re: mysql server is not responding
Posted by: RiggsFolly (---.as13285.net)
Date: November 29, 2012 10:19AM

Try running this:
1. wampmanager -> MySQL -> Service -> Remove Service
2. wampmanager -> MySQL -> Service -> Install Service

Does that cure the problem?

Options: ReplyQuote
Re: mysql server is not responding
Posted by: robmillion (---.static.dsl.dodo.com.au)
Date: November 29, 2012 11:24AM

when all else fails, re-install wamp ... but back up your data first!

Options: ReplyQuote
Re: mysql server is not responding
Posted by: shamoo (---.rdns.blackberry.net)
Date: November 29, 2012 07:27PM

Yah it cure the problem,thanks a lot,your are great

Options: ReplyQuote


Sorry, only registered users may post in this forum.