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?
- go c:\wamp\bin\mysql\mysql[your-version]\data
- copy , save "ib_logfile0" , "ib_logfile1" anywhere else.
- delete "ib_logfile0" , ib_logfile1
did trick me. hope works too.
Comments
Post a Comment