Not able to run phpMyAdmin on xampp

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

Not able to run phpMyAdmin on xampp

Postby presha » 26. April 2012 06:04

I have installed xampp version 1.7.7 and my xampp control panel version is 2.5....
But am not able to run phpMyAdmin on it...

The status shows mysql database as deactivated.

The security shows:
Code: Select all
   A MySQL server is not running or is blocked by a firewall!      UNKNOWN    
   A MySQL server is not running or is blocked by a firewall!
      
   PhpMyAdmin is free accessible by network      UNSECURE    
   PhpMyAdmin is accessible by network without password. The configuration 'httpd' or 'cookie' in the "config.inc.php" can help.


The security console for Mysql and Xampp directory protection shows:
Code: Select all
MYSQL SECTION: "ROOT" PASSWORD
 
MySQL SuperUser:    root
     
The MySQL server is not running or is blocked by a firewall! Please check this problem first ...


Whenever I open phpMyAdmin it gives an error:
Code: Select all
MySQL said:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)


------------Apache error.log------------------
Code: Select all
[Thu Apr 26 09:39:32 2012] [notice] Digest: generating secret for digest authentication ...
[Thu Apr 26 09:39:32 2012] [notice] Digest: done
[Thu Apr 26 09:39:33 2012] [notice] Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Thu Apr 26 09:39:33 2012] [notice] Server built: Sep 10 2011 11:34:11
[Thu Apr 26 09:39:33 2012] [notice] Parent: Created child process 788
[Thu Apr 26 09:39:34 2012] [notice] Digest: generating secret for digest authentication ...
[Thu Apr 26 09:39:34 2012] [notice] Digest: done
[Thu Apr 26 09:39:34 2012] [notice] Child 788: Child process is running
[Thu Apr 26 09:39:34 2012] [notice] Child 788: Acquired the start mutex.
[Thu Apr 26 09:39:34 2012] [notice] Child 788: Starting 150 worker threads.
[Thu Apr 26 09:39:34 2012] [notice] Child 788: Starting thread to listen on port 443.
[Thu Apr 26 09:39:34 2012] [notice] Child 788: Starting thread to listen on port 443.
[Thu Apr 26 09:39:34 2012] [notice] Child 788: Starting thread to listen on port 80.
[Thu Apr 26 09:39:34 2012] [notice] Child 788: Starting thread to listen on port 80.



--------------Mysql error.log-------------------
Code: Select all
120426  9:39:37 [Note] Plugin 'FEDERATED' is disabled.
120426  9:39:37 InnoDB: The InnoDB memory heap is disabled
120426  9:39:37 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120426  9:39:37 InnoDB: Compressed tables use zlib 1.2.3
120426  9:39:37 InnoDB: Initializing buffer pool, size = 16.0M
120426  9:39:37 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!
120426  9:39:37  InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120426  9:39:39  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...
120426  9:39:40  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
120426  9:39:42  InnoDB: Waiting for the background threads to start
120426  9:39:43 InnoDB: 1.1.8 started; log sequence number 0
120426  9:39:43 [Note] Event Scheduler: Loaded 0 events
120426  9:39:43 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3306  MySQL Community Server (GPL)
120426  9:48:08 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

120426  9:48:08 [Note] Event Scheduler: Purging the queue. 0 events
120426  9:48:08  InnoDB: Starting shutdown...
120426  9:48:08  InnoDB: Shutdown completed; log sequence number 1595675
120426  9:48:08 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

120426  9:48:10 [Note] Plugin 'FEDERATED' is disabled.
120426  9:48:10 InnoDB: The InnoDB memory heap is disabled
120426  9:48:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120426  9:48:10 InnoDB: Compressed tables use zlib 1.2.3
120426  9:48:10 InnoDB: Initializing buffer pool, size = 16.0M
120426  9:48:10 InnoDB: Completed initialization of buffer pool
120426  9:48:10 InnoDB: highest supported file format is Barracuda.
120426  9:48:11  InnoDB: Waiting for the background threads to start
120426  9:48:12 InnoDB: 1.1.8 started; log sequence number 1595675
120426  9:48:12 [Note] Event Scheduler: Loaded 0 events
120426  9:48:12 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3306  MySQL Community Server (GPL)


Could you please help me out if I have missed or messed up something......
presha
 
Posts: 1
Joined: 26. April 2012 05:47
Operating System: Windows

Re: Not able to run phpMyAdmin on xampp

Postby JonB » 27. April 2012 18:10

how exactly are you trying to access phpMyAdmin????

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

Re: Not able to run phpMyAdmin on xampp

Postby hackattack142 » 28. April 2012 00:16

You might also try opening your "/xampp/mysql/bin/my.ini" file, and finding this line:
Code: Select all
#bind-address="127.0.0.1"
, remove the "#" in front of it, save the file, and restart MySQL. When you visit the phpMyAdmin page http://localhost/phpmyadmin make sure you manually refresh the page in your browser so you do not get a cached error page.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 137 guests