mysql - #2002 - No connection could be made because the target machine actively refused it -


i realise seen duplicate have looked @ other responses , didn't fix problem me.

i have installed zend studio , zend server mysql plugin on windows 7.

i not qualified server administrator neither incompetent; have dedicated day trying local development 'server' cut down on upload/download times.

when server/machine mean home computer

i have come grinding halt trying mysql work zend server.

the error keep receiving (or verbose):

#2002 cannot log in mysql server or (if change 'config' authentication type) #2002 - no connection made because target machine actively refused it.  server not responding (or local server's socket not correctly configured). 

i have tried:

  • change $cfg['servers'][$i]['host'] 'localhost' '127.0.0.1'
  • add/remove $cfg['servers'][$i]['socket'] = '';
  • change cookie config auth type
  • reinstall server , mysql
  • disable firewalls
  • restarting machine

zend's approach 'configure phpmyadmin setup screen'... done don't know how many times.

can on here lend hand, or point me in direction haven't tried yet?

  1. go c:\wamp\bin\mysql\mysql[your-version]\data
  2. copy , save "ib_logfile0" , "ib_logfile1" anywhere else.
  3. delete "ib_logfile0" , ib_logfile1

did trick me. hope works too.


Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -