Re: phpMyAdmin - error 2002 - Server not responding

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.