#2002 Cannot log in to the MySQL server - Urgent Help ?
Posted by: boosters (1.22.208.---)
Date: March 26, 2014 07:52AM

Last night everything was working, but today when I run the Wamp, i have the orange light, i thought the apache port not working but when i check apache it is was working fine. The issue was happening whenever i am trying to login phpmyadmin, i receive this message - #2002 Cannot log in to the MySQL server.

Here is the log which I collected from MySQL Log

2014-03-26 11:58:57 1848 [Note] Plugin 'FEDERATED' is disabled.
wampmysqld: Table 'mysql.plugin' doesn't exist
2014-03-26 11:58:57 1848 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2014-03-26 11:58:58 1848 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-26 11:58:58 1848 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-26 11:58:58 1848 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-26 11:58:58 1848 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-26 11:58:58 1848 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-26 11:58:58 1848 [Note] InnoDB: Completed initialization of buffer pool
2014-03-26 11:58:58 1848 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-26 11:59:00 1848 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-26 11:59:00 1848 [Note] InnoDB: Waiting for purge to start
2014-03-26 11:59:00 1848 [Note] InnoDB: 5.6.12 started; log sequence number 1767118
2014-03-26 11:59:00 1848 [Note] Server hostname (bind-address): '*'; port: 3306
2014-03-26 11:59:00 1848 [Note] IPv6 is available.
2014-03-26 11:59:00 1848 [Note] - '::' resolves to '::';
2014-03-26 11:59:00 1848 [Note] Server socket created on IP: '::'.
2014-03-26 11:59:00 1848 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Options: ReplyQuote
Re: #2002 Cannot log in to the MySQL server - Urgent Help ?
Posted by: RiggsFolly (---.as13285.net)
Date: March 26, 2014 10:01AM

It looks like you have somehow deleted some or all of the database that MySQL uses to look after itself.

Do you have a backup?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.