Access Denied - phpMyAdmin
Posted by: anilo (---.hsd1.ca.comcast.net)
Date: July 10, 2009 09:58PM

Just today the phpMyAdmin page suddenly stopped working and it gave the following error.

>>>>>>>>>>>>>>.

Welcome to phpMyAdmin

Error

MySQL said: Documentation
#2003 - Can't connect to MySQL server on 'localhost' (10061)

>>>>>>>>>>>>>>>>

Not sure what changed in my system. It's running on a Vista machine. Windows updates are always installing updates.

I've disabled the Windows Firewall, it didn't help.

[localhost] - works
Indicator at the bottom: Stuck on Yellow.



Last few lines from mysql.log
090710 12:36:00 InnoDB: Started; log sequence number 0 46409
wampmysqld: File '.\mysql-bin.000010' not found (Errcode: 2)
090710 12:36:00 [ERROR] Failed to open log (file '.\mysql-bin.000010', errno 2)
090710 12:36:00 [ERROR] Could not open log file
090710 12:36:00 [ERROR] Can't init tc log
090710 12:36:00 [ERROR] Aborting

090710 12:36:00 InnoDB: Starting shutdown...
090710 12:36:02 InnoDB: Shutdown completed; log sequence number 0 46409
090710 12:36:02 [Warning] Forcing shutdown of 1 plugins
090710 12:36:02 [Note] wampmysqld: Shutdown complete


Note: I have several files in the folder: C:\wamp\bin\mysql\mysql5.1.33\data
mysql-bin.000001 -- 1KB
..
..
mysql-bin.000009 --- Large file
mysql-bin.index
mysql-bin(from mymachinename).000010 -- Large file.





Last few lines from apache_error.log
[Fri Jul 10 12:30:15 2009] [notice] Child 3412: Child process is exiting
[Fri Jul 10 12:30:15 2009] [notice] Parent: Child process exited successfully.
[Fri Jul 10 12:36:00 2009] [notice] Apache/2.2.11 (Win32) PHP/5.2.9-2 configured -- resuming normal operations
[Fri Jul 10 12:36:00 2009] [notice] Server built: Dec 10 2008 00:10:06
[Fri Jul 10 12:36:00 2009] [notice] Parent: Created child process 3800
[Fri Jul 10 12:36:00 2009] [notice] Child 3800: Child process is running
[Fri Jul 10 12:36:00 2009] [notice] Child 3800: Acquired the start mutex.
[Fri Jul 10 12:36:00 2009] [notice] Child 3800: Starting 64 worker threads.
[Fri Jul 10 12:36:00 2009] [notice] Child 3800: Starting thread to listen on port 80.





Last few lines from access.log
127.0.0.1 - - [10/Jul/2009:12:36:56 -0700] "GET / HTTP/1.1" 200 4149
127.0.0.1 - - [10/Jul/2009:12:36:56 -0700] "GET /index.php?img=gifLogo HTTP/1.1" 200 5172
127.0.0.1 - - [10/Jul/2009:12:36:56 -0700] "GET /index.php?img=pngFolderGo HTTP/1.1" 200 694
127.0.0.1 - - [10/Jul/2009:12:36:57 -0700] "GET /index.php?img=pngPlugin HTTP/1.1" 200 548
127.0.0.1 - - [10/Jul/2009:12:36:57 -0700] "GET /index.php?img=pngFolder HTTP/1.1" 200 850
127.0.0.1 - - [10/Jul/2009:12:36:57 -0700] "GET /index.php?img=pngWrench HTTP/1.1" 200 741
127.0.0.1 - - [10/Jul/2009:12:37:04 -0700] "GET /drupal2 HTTP/1.1" 301 233
127.0.0.1 - - [10/Jul/2009:12:37:04 -0700] "GET /drupal2/ HTTP/1.1" 503 2706
127.0.0.1 - - [10/Jul/2009:12:37:10 -0700] "GET /drupal HTTP/1.1" 301 232
127.0.0.1 - - [10/Jul/2009:12:37:10 -0700] "GET /drupal/ HTTP/1.1" 302 -
127.0.0.1 - - [10/Jul/2009:12:37:10 -0700] "GET /drupal/install.php HTTP/1.1" 302 -
127.0.0.1 - - [10/Jul/2009:12:37:12 -0700] "GET /drupal/install.php?profile=default HTTP/1.1" 200 2675
127.0.0.1 - - [10/Jul/2009:12:37:14 -0700] "GET /drupal/install.php?profile=default&locale=en HTTP/1.1" 200 3223
127.0.0.1 - - [10/Jul/2009:12:37:19 -0700] "GET /drupal/misc/watchdog-ok.png HTTP/1.1" 200 3217
127.0.0.1 - - [10/Jul/2009:12:41:59 -0700] "GET /phpmyadmin/ HTTP/1.1" 200 2834
127.0.0.1 - - [10/Jul/2009:12:46:28 -0700] "GET /sqlitemanager/ HTTP/1.1" 200 554
127.0.0.1 - - [10/Jul/2009:12:46:28 -0700] "GET /sqlitemanager/left.php? HTTP/1.1" 200 1234
127.0.0.1 - - [10/Jul/2009:12:46:29 -0700] "GET /sqlitemanager/main.php? HTTP/1.1" 200 5377
127.0.0.1 - - [10/Jul/2009:12:46:47 -0700] "POST /sqlitemanager/main.php HTTP/1.1" 200 4246
127.0.0.1 - - [10/Jul/2009:12:46:47 -0700] "GET /sqlitemanager/main.php?dbsel= HTTP/1.1" 200 5377
127.0.0.1 - - [10/Jul/2009:12:46:48 -0700] "GET /sqlitemanager/left.php?dbsel= HTTP/1.1" 200 1234

Options: ReplyQuote
Re: Access Denied - phpMyAdmin
Posted by: c2dan (---.15-1.cable.virginmedia.com)
Date: July 10, 2009 10:03PM

Make sure the MySQL Service is running. Left WAMP tray icon > MySQL > Service. If the Start/Resume Service option is not disabled then MYSQL is not running. Left click this option to start the MySQL Service.

Options: ReplyQuote


Sorry, only registered users may post in this forum.