Apache Friends Support Forum

I am running xampp on windows 7, it was installed about 1-1/2 years ago and has worked like a charm until a week ago when I could not get past the phpMyAdmin login.

When I try to login, I get 2 messages:
At the top: #2002 Cannot log in to the MySQL server
At the bottom: Connection for controluser as defined in your configuration failed
Also, when I look in the xampp control panel, Apache is running, but MySql is not - when I click on start it indicates it started, then flips back to not running.

I have read many of the items on the web addressing the 2002 error, and have tried the fix most offered:

open phpmyadmin/config.inc.php and change:
$cfg['Servers'][$i]['host'] = 'localhost';
to:
$cfg['Servers'][$i]['host'] = '127.0.0.1';

Which does not seem to make a difference.

I renamed the xampp folder as a backup, and installed the new version into a new folder xampp - and copied the htdocs folder from the backup which has the MySql databases that I need..but it still does not see them. Is there a way to have MySql recognize them? I looked at importing, but I think that requires a backup formatted file to import.

Is there another file in the backup (the original) xampp folder that I need to copy over to have it recognize the databases?

mysql_error.log?

Altrea wrote:mysql_error.log?

I found it - here is the stuff from this afternoon:

mysql\bin\mysqld.exe: File '.\mysql\plugin.MYD' not found (Errcode: 2)
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
130923 20:22:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
130923 20:22:19 InnoDB: Initializing buffer pool, size = 16.0M
130923 20:22:19 InnoDB: Completed initialization of buffer pool
130923 20:22:19 InnoDB: highest supported file format is Barracuda.
130923 20:22:19 InnoDB: 1.1.4 started; log sequence number 1972833
130923 20:22:19 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
130923 20:22:24 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: File '.\mysql\plugin.MYD' not found (Errcode: 2)
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
130923 20:22:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
130923 20:22:24 InnoDB: Initializing buffer pool, size = 16.0M
130923 20:22:24 InnoDB: Completed initialization of buffer pool
130923 20:22:24 InnoDB: highest supported file format is Barracuda.
130923 20:22:24 InnoDB: 1.1.4 started; log sequence number 1972833
130923 20:22:24 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
130923 20:42:22 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: File '.\mysql\plugin.MYD' not found (Errcode: 2)
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
130923 20:42:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
130923 20:42:22 InnoDB: Initializing buffer pool, size = 16.0M
130923 20:42:22 InnoDB: Completed initialization of buffer pool
130923 20:42:22 InnoDB: highest supported file format is Barracuda.
130923 20:42:23 InnoDB: 1.1.4 started; log sequence number 1972833
130923 20:42:23 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
130923 21:13:51 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: File '.\mysql\plugin.MYD' not found (Errcode: 2)
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
130923 21:13:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
130923 21:13:51 InnoDB: Initializing buffer pool, size = 16.0M
130923 21:13:51 InnoDB: Completed initialization of buffer pool
130923 21:13:51 InnoDB: highest supported file format is Barracuda.
130923 21:13:51 InnoDB: 1.1.4 started; log sequence number 1972833
130923 21:13:51 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
130923 21:25:45 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: File '.\mysql\plugin.MYD' not found (Errcode: 2)
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
130923 21:25:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
130923 21:25:45 InnoDB: Initializing buffer pool, size = 16.0M
130923 21:25:45 InnoDB: Completed initialization of buffer pool
130923 21:25:45 InnoDB: highest supported file format is Barracuda.
130923 21:25:45 InnoDB: 1.1.4 started; log sequence number 1972833
130923 21:25:45 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)


Some of it is probably repetitions.

Hello,

It is an issue with your MySQL data files, not phpMyAdmin.

mysql\bin\mysqld.exe: File '.\mysql\plugin.MYD' not found (Errcode: 2)
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
130923 21:25:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130923 21:25:45 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)

OK, I ran searches for the files indicated as missing - in both the current xampp and the copy of the original installation - and could not find the files anywhere.

After some additional attempts I restored a backup-ed version of the once working folder to the xampp folder. This almost ran, but there were some conflicts that prevented it.

Then I found the original 1.7.4 install zip, installed that - and it ran just fine...

So, the "solution" turned out to be a simple reload of the original form...

But I think I did learn a bit more by running all the initial steps to fix this.

Thanks all for the help and guidance...you were a lot more helpful than most of the other forums