Re: phpMyAdmin - error 2002 - Server not responding

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

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
>
>
> If the reader of this email is not the intended recipient(s), please be
> advised that any dissemination, distribution or copying of this information
> is strictly prohibited. Johnson Matthey PLC has its main place of business
> at 5th Floor, 25 Farringdon Street, London (020 7269 8400).
>
> Johnson Matthey Public Limited Company
> Registered Office: 5th Floor, 25 Farringdon Street, London EC4A 4AB
> Registered in England No 33774
>
> Whilst Johnson Matthey aims to keep its network free from viruses you
> should note that we are unable to scan certain emails, particularly if any
> part is encrypted or password-protected, and accordingly you are strongly
> advised to check this email and any attachments for viruses. The company
> shall NOT ACCEPT any liability with regard to computer viruses transferred
> by way of email.
>
> Please note that your communication may be monitored in accordance with
> Johnson Matthey internal policy documentation.
>
> This message has been scanned for viruses by MailControl -
> www.mailcontrol.com
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.