Re: phpMyAdmin - error 2002 - Server not responding

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

IIRC MySQL connects on port 3306.  Is there a MySQL listener running?  
(netstat to find out).  If not it sounds like the deamon is not running 
correctly.

If it is try the /pathtoyourinstance/MySQLadmin -u root password 
'new-password'  to reset the root password.

You might want to try to use:  /pathtoyourserverinstance/MySQLd_safe &  
to start the MySQL deamon in safe mode

(all commands issued inside QSH)

I think the time to update to the DBi is a good idea anyway since is is 
the version that will get support if you have a contract with Zend/IBM.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 9/27/2012 12:13 PM, Jack Kingsley wrote:
> jeff, if you pan through this site your error is described in here:
>
> http://www.itjungle.com/fhg/fhg022008-story01.html
>
>
>
> On Thu, Sep 27, 2012 at 12:16 PM, Jeffrey Day<Jeff.Day@xxxxxxxx>  wrote:
>
> > >  Hi Folks,
> > >
> > >  Our MySQL server was installed on our IBM i a short while ago, and
> > >  everything appeared to be working.  I was working on importing a database
> > >  from a different MySQL server implementation when I began getting the
> > >  following error message when I tried to login into phpMyAdmin.  "#2002 -
> > >  The server is not responding (or the local MySQL server's socket is not
> > >  correctly configured)".  This does not seem to be true though, because the
> > >  socket, mysql.default_socket, is set to /tmp/mysql.sock.
> > >
> > >  At this point, MySQL is unuseable as I cannot login to it, but PHP is
> > >  working fine.
> > >
> > >  Other symptoms I am seeing are when I try to start the MySQL daemon, it
> > >  starts and ends right away.  It gens 2 spoolfiles.  One that just has this
> > >  text in it "-n Starting MySQL ...". The second, a joblog, which says it ran
> > >  "CALL PGM(QP2SHELL) PARM('/QOpenSys/usr/bin/sh/usr/local/MySQL/bin/mysql.sh
> > >  start')" and completed with endcode 0.
> > >
> > >  Does anyone know a solution for this problem?  Is my only option to
> > >  reinstall?  I have found Mike Pavlak's instructions for how to remove MySQL
> > >  and I have downloaded the DBi savefile from Zend, but I'd like to here if
> > >  there is a better way before I proceed with the re-install.
> > >
> > >  Thanks,
> > >  Jeff