PHPAdmin Error #2002

Problems with the Windows version of XAMPP, questions, comments, and anything related.

PHPAdmin Error #2002

Postby LiamS » 20. July 2011 13:19

I have been using XAMPP for a number of years now. First time i have had this problem. I'm using XAMPP 1.7.4 and Windows 7.

Initially, when I connected to http://localhost in my browser I was getting connected to IIS7. I fixed this by shutting down and disabling the windows server.

After restarting XAMPP, I was able to connect to the admin screen of XAMPP as normal using http://localhost.

The status screen indicates the following:

MySQL database DEACTIVATED
PHP ACTIVATED
HTTPS (SSL) ACTIVATED
Common Gateway Interface (CGI) ACTIVATED
Server Side Includes (SSI) ACTIVATED
SMTP Service DEACTIVATED
FTP Service DEACTIVATED
Tomcat Service DEACTIVATED


When I connect to PHPMyAdmin I get this error:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Connection for controluser as defined in your configuration failed.


And when I connect to my websites, I get this error in the browser:

Error establishing a database connection


I assume some configuration is wrong in the setting or a file etc is missing.

Any help would be appreciated.

Thanks

Liam
LiamS
 
Posts: 5
Joined: 20. July 2011 12:53

Re: PHPAdmin Error #2002

Postby Sharley » 21. July 2011 01:54

Hello Liam,

I went through many possible solutions in this topic:
viewtopic.php?f=16&t=47332

The OP eventually found that a firewall program was at fault after installing a recent security patch from Windows perhaps but he was a bit thin on detail.

See if the above topic helps you find a solution.

Best wishes and good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
XAMPP Version: 5.6.3
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: PHPAdmin Error #2002

Postby LiamS » 21. July 2011 14:21

Hi Sharley,

I followed all the instructions stated in the topic you suggested.

1. I disabled all IIS7 services and databases.
2. Tried installing a fresh version by renaming the original folder old_xampp.
3. Disabled my Bullguard Firewall.
4. Using the new control panel.

After disabling all the IIS7 services. XAMPP is now able to run on ports 80, 443 and MySQL on 3306. I no longer get the System is using port 80, in the control panel log below.

This what i get from my MySQL error log.

Code: Select all
110721 12:19:52 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 12:19:52  InnoDB: Initializing buffer pool, size = 16.0M
110721 12:19:52  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
110721 12:19:52  InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110721 12:19:52  InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110721 12:19:53  InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110721 12:19:54  InnoDB: 1.1.4 started; log sequence number 0
110721 12:19:54 [Note] Event Scheduler: Loaded 0 events
110721 12:19:54 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 12:31:10 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 12:31:10  InnoDB: Initializing buffer pool, size = 16.0M
110721 12:31:10  InnoDB: Completed initialization of buffer pool
110721 12:31:10  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 12:31:10  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 12:31:11  InnoDB: 1.1.4 started; log sequence number 1595675
110721 12:31:11 [Note] Event Scheduler: Loaded 0 events
110721 12:31:11 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 13:16:46 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 13:16:46  InnoDB: Initializing buffer pool, size = 16.0M
110721 13:16:46  InnoDB: Completed initialization of buffer pool
110721 13:16:46  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 13:16:46  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 13:16:47  InnoDB: 1.1.4 started; log sequence number 1595675
110721 13:16:47 [Note] Event Scheduler: Loaded 0 events
110721 13:16:47 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)


I have also set the username/password to login to XAMPP.

I still get the same notification that MySQL is not running or is blocked by a firewall, even when i disable the firewall.

I will do more digging and report back.

thanks

Liam
LiamS
 
Posts: 5
Joined: 20. July 2011 12:53

Re: PHPAdmin Error #2002

Postby JonB » 21. July 2011 14:33

Hi

I'm a bit unsure form your explanation --

Is it the case that not only phpMyAdmin can't talk to MySQL, but also any data driven websites you have are also impaired???

it looks like the Windows user that Apache and MySQL are running under don't have the correct rights in the MySQL data folders.
(my interpretation of the errors amounts to 'can't write to my files' (or read perhaps -- I don't fully grok the initialization protocol for MySQL)

i.e probably a problem with the NTFS rights. Perhaps inheritance has been inhibited???

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: PHPAdmin Error #2002

Postby LiamS » 21. July 2011 14:44

Hi Jon,

This problem happened at the beginning of the week. I am assuming after some windows 7 updates. I came to log into xampp and found i was directed to the IIS7 screen. After a lot of troubleshooting, I found from these forums that it was IIS7 using the ports 80, 443 etc. So, after disabling them. I was still getting the MySQL Error in PHPMyAdmin.
Code: Select all
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Connection for controluser as defined in your configuration failed.


Thanks

Liam
LiamS
 
Posts: 5
Joined: 20. July 2011 12:53

Re: PHPAdmin Error #2002

Postby JonB » 21. July 2011 16:30

Liam - I hate to say this, but you didn't answer the question -
Is it the case that not only phpMyAdmin can't talk to MySQL, but also any data driven websites you have are also impaired???


AND - are you still getting these errors?

Code: Select all
110721 12:19:52 [Note] Plugin 'FEDERATED' is disabled.
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use Windows interlocked functions
    InnoDB: Compressed tables use zlib 1.2.3
    110721 12:19:52  InnoDB: Initializing buffer pool, size = 16.0M
    110721 12:19:52  InnoDB: Completed initialization of buffer pool
    InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
    InnoDB: a new database to be created!
    110721 12:19:52  InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    110721 12:19:52  InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    110721 12:19:53  InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: 127 rollback segment(s) active.
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    110721 12:19:54  InnoDB: 1.1.4 started; log sequence number 0
    110721 12:19:54 [Note] Event Scheduler: Loaded 0 events
    110721 12:19:54 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
    Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
    110721 12:31:10 [Note] Plugin 'FEDERATED' is disabled.
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use Windows interlocked functions
    InnoDB: Compressed tables use zlib 1.2.3
    110721 12:31:10  InnoDB: Initializing buffer pool, size = 16.0M
    110721 12:31:10  InnoDB: Completed initialization of buffer pool
    110721 12:31:10  InnoDB: highest supported file format is Barracuda.
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    110721 12:31:10  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    110721 12:31:11  InnoDB: 1.1.4 started; log sequence number 1595675
    110721 12:31:11 [Note] Event Scheduler: Loaded 0 events
    110721 12:31:11 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
    Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
    110721 13:16:46 [Note] Plugin 'FEDERATED' is disabled.
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use Windows interlocked functions
    InnoDB: Compressed tables use zlib 1.2.3
    110721 13:16:46  InnoDB: Initializing buffer pool, size = 16.0M
    110721 13:16:46  InnoDB: Completed initialization of buffer pool
    110721 13:16:46  InnoDB: highest supported file format is Barracuda.
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    110721 13:16:46  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    110721 13:16:47  InnoDB: 1.1.4 started; log sequence number 1595675
    110721 13:16:47 [Note] Event Scheduler: Loaded 0 events
    110721 13:16:47 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
    Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)


Good Luck
8)





yapioyh
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: PHPAdmin Error #2002

Postby LiamS » 21. July 2011 16:38

Hi Sorry,

Been pulling my hair out here.

Yes still phpMyAmin can't talk to MySQL and also data driven websites.

the error log as follows.

Code: Select all
110721 12:19:52 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 12:19:52  InnoDB: Initializing buffer pool, size = 16.0M
110721 12:19:52  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
110721 12:19:52  InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110721 12:19:52  InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110721 12:19:53  InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110721 12:19:54  InnoDB: 1.1.4 started; log sequence number 0
110721 12:19:54 [Note] Event Scheduler: Loaded 0 events
110721 12:19:54 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 12:31:10 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 12:31:10  InnoDB: Initializing buffer pool, size = 16.0M
110721 12:31:10  InnoDB: Completed initialization of buffer pool
110721 12:31:10  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 12:31:10  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 12:31:11  InnoDB: 1.1.4 started; log sequence number 1595675
110721 12:31:11 [Note] Event Scheduler: Loaded 0 events
110721 12:31:11 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 13:16:46 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 13:16:46  InnoDB: Initializing buffer pool, size = 16.0M
110721 13:16:46  InnoDB: Completed initialization of buffer pool
110721 13:16:46  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 13:16:46  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 13:16:47  InnoDB: 1.1.4 started; log sequence number 1595675
110721 13:16:47 [Note] Event Scheduler: Loaded 0 events
110721 13:16:47 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 14:56:07 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 14:56:07  InnoDB: Initializing buffer pool, size = 16.0M
110721 14:56:07  InnoDB: Completed initialization of buffer pool
110721 14:56:07  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 14:56:07  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 14:56:08  InnoDB: 1.1.4 started; log sequence number 1595675
110721 14:56:08 [Note] Event Scheduler: Loaded 0 events
110721 14:56:08 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 15:16:23 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 15:16:23  InnoDB: Initializing buffer pool, size = 16.0M
110721 15:16:23  InnoDB: Completed initialization of buffer pool
110721 15:16:24  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 15:16:24  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 15:16:29  InnoDB: 1.1.4 started; log sequence number 1595675
110721 15:16:30 [Note] Event Scheduler: Loaded 0 events
110721 15:16:30 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 15:52:45 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 15:52:45  InnoDB: Initializing buffer pool, size = 16.0M
110721 15:52:45  InnoDB: Completed initialization of buffer pool
110721 15:52:45  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 15:52:45  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 15:52:47  InnoDB: 1.1.4 started; log sequence number 1595675
110721 15:52:47 [Note] Event Scheduler: Loaded 0 events
110721 15:52:47 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 15:55:16 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 15:55:16  InnoDB: Initializing buffer pool, size = 16.0M
110721 15:55:16  InnoDB: Completed initialization of buffer pool
110721 15:55:16  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 15:55:16  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 15:55:17  InnoDB: 1.1.4 started; log sequence number 1595675
110721 15:55:17 [Note] Event Scheduler: Loaded 0 events
110721 15:55:17 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 16:13:58 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 16:13:59  InnoDB: Initializing buffer pool, size = 16.0M
110721 16:13:59  InnoDB: Completed initialization of buffer pool
110721 16:13:59  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 16:13:59  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 16:13:59  InnoDB: 1.1.4 started; log sequence number 1595675
110721 16:13:59 [Note] Event Scheduler: Loaded 0 events
110721 16:13:59 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
110721 16:18:03 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110721 16:18:03  InnoDB: Initializing buffer pool, size = 16.0M
110721 16:18:03  InnoDB: Completed initialization of buffer pool
110721 16:18:03  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110721 16:18:03  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110721 16:18:03  InnoDB: 1.1.4 started; log sequence number 1595675
110721 16:18:03 [Note] Event Scheduler: Loaded 0 events
110721 16:18:03 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)
LiamS
 
Posts: 5
Joined: 20. July 2011 12:53

Re: PHPAdmin Error #2002

Postby LiamS » 26. July 2011 08:46

I have managed to fix the problem i was having. After main attempts at altering files, test firewall etc etc. I reverted back to 1.7.1 version of XAMPP. This seemed to fix the problem of not ben able to login to phpMyAdmin. After replacing all my backups of websites + databases, everything was back to normal.
LiamS
 
Posts: 5
Joined: 20. July 2011 12:53

Re: PHPAdmin Error #2002

Postby toggle » 26. July 2011 12:46

Xampp 1.7.4 on XP-SP3.

I have had the same problem as the OP - error 2002 after clicking phpMyAdmin link on Xampp's welcome page (http://localhost/xampp/).

However I only get error 2002 when the PC is disconnected from the network via network connections in control panel (start/control panel/network connections/connection-name/right-click/disable). With the connection enabled phpMyAdmin works just fine.

The problem was resolved as soon as I put a "bind-address=127.0.0.1" configuration parameter in the [mysqld] section of the "my.ini" configuration file (<xampp-install-folder>\mysql\bin\my.ini) and restarted MySQL on the Xampp control panel. Now phpMyAdmin works whether the PC is connected to its local network or not.

Some useful resources I found while investigating this were:

Microsoft TCP/IP Fundamentals for Microsoft Windows

Vista, XP, Server 2003, 2008 as a PDF, 4MB download
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=8781

online technet pages
http://technet.microsoft.com/en-us/library/hh182191.aspx

Chapter 7 - Host Name Resolution http://technet.microsoft.com/en-us/library/bb727005.aspx
Chapter 16 – Troubleshooting TCP/IP http://technet.microsoft.com/en-us/library/bb727023.aspx

Diagnosing error codes given by MySQL clients when they fail to connect to MySQL server

Windows Sockets Error Codes http://msdn.microsoft.com/en-us/library/ms740668%28v=vs.85%29.aspx
(for me, phpMyAdmin failed with WSAECONNREFUSED 10061 - Connection refused)

MySQL 5.5 Reference Manual

C.5.2.2. Can't connect to [local] MySQL server http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
7.11.5.2. How MySQL Uses DNS http://dev.mysql.com/doc/refman/5.5/en/dns.html
5.1.2. Server Command Options http://dev.mysql.com/doc/refman/5.5/en/server-options.html
5.1.2. bind-address= http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_bind-address

Couple of Techniques to see error codes generated by failure to connect

1) start a command prompt (start/run/cmd.exe)
ensure MySQL has been started (xampp control panel)
cd <xampp-install-folder>\mysql\bin
mysql

If the command-line mysql client can connect to the MySQL server you'll get a "mysql >" prompt
mysql> status
mysql> exit

If the command-line mysql client fails to connect to the MySQL server you'll get an error message.

I was getting:

"ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)"

2) copy <xampp-install-folder>\htdocs\xampp\mysql.php <xampp-install-folder>\htdocs\xampp\mysqldbg.php
edit <xampp-install-folder>\htdocs\xampp\mysqldbg.php
remove the '@' from in front of the 'mysql_connect'
save your change

ensure MySQL and Apache are started via the Xampp control panel
in your browser open the url "http://localhost/xampp/mysqldbg.php"

You'll get a page with just "OK" on it if there's a connection to MySQL
You'll get the full error message and "NOK" if no connection can be made.

(The "@" suppresses warnings and errors on the PHP function call, removing the "@" lets you see them if they occur)

I was getting:

"Warning: mysql_connect() [function.mysql-connect]: [2002] No connection could be made because the target machine
actively (trying to connect via tcp://localhost:3306) in <xampp-install-folder>\htdocs\xampp\mysqldbg.php on line 2

Warning: mysql_connect() [function.mysql-connect]: No connection could be made because the target machine actively
refused it. in <xampp-install-folder>\htdocs\xampp\mysqldbg.php on line 2
NOK"
toggle
 
Posts: 1
Joined: 26. July 2011 10:12

Re: PHPAdmin Error #2002

Postby MRRaja » 27. December 2012 19:48

just run C:\xampp\mysql\bin\mysql_upgrade.exe and enjoy
MRRaja
 
Posts: 2
Joined: 27. December 2012 19:45
XAMPP Version: 5.6.3
Operating System: OS7

Re: PHPAdmin Error #2002

Postby Altrea » 30. December 2012 18:26

Hi MRRaja,

I don't think that mysql_upgrade.bat is a possible solution for MySQL Error #2002 issues.
I can't find any ressource on the internet which is saying that it would help in some way.
Can you please explain why you think it would solve that issue :?:

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6764
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: PHPAdmin Error #2002

Postby plymplan » 09. February 2013 21:53

Running the mysql script per suggestion of MRRaja worked for me

I have Win Vista, XAMPP 1.81
plymplan
 
Posts: 1
Joined: 09. February 2013 21:51
XAMPP Version: 5.6.3
Operating System: veesta


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests