Can't get past phpMyAdmin

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

Can't get past phpMyAdmin

Postby OrcaSoul » 24. September 2013 05:44

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?
OrcaSoul
 
Posts: 57
Joined: 24. August 2009 23:51

Re: Can't get past phpMyAdmin

Postby Altrea » 24. September 2013 05:48

mysql_error.log?
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Can't get past phpMyAdmin

Postby OrcaSoul » 24. September 2013 07:07

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.
OrcaSoul
 
Posts: 57
Joined: 24. August 2009 23:51

Re: Can't get past phpMyAdmin

Postby hackattack142 » 25. September 2013 04:12

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)
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

Re: Can't get past phpMyAdmin

Postby OrcaSoul » 25. September 2013 05:39

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... :roll:

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
OrcaSoul
 
Posts: 57
Joined: 24. August 2009 23:51


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 146 guests