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:


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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.