MySQL , #2002 Error ... Any Solution ?
Posted by: Pravin93 (1.32.74.---)
Date: January 21, 2016 08:00AM

Hi RiggsFolly

I'm also facing the same problem as hatami and i have no clue what is the problem.

Error message:

"MySQL said: Documentation
#2002 - No connection could be made because the target machine actively refused it.
The server is not responding (or the local server's socket is not correctly configured)."

Wampmanager icon color is showing orange.

This is error message that i get after following your steps :
Description:
InnoDB: Attempted to open a previously opened tablespace. Previous tablespace fyp/gallery uses space ID: 9 at

filepath: .\fyp\gallery.ibd. Cannot open tablespace tech4you/admin_login which uses space ID: 9 at filepath:

.\tech4you\admin_login.ibd



Edited 1 time(s). Last edit at 01/21/2016 09:34AM by Otomatic.

Options: ReplyQuote
Re: MySQL , #2002 Error ... Any Solution ?
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: January 21, 2016 10:44AM

Hi Pravin,

This indicates that one of your INNODB Databases has been corrupted.

The simple solution is to restore the database from your last backup.

Alternatively there are instruction in the mysql error log as to other steps you can take to recover this database, I suggest you try them. This is not something we can specifically help your with other than point you to the MYSQL Manual.

Some suggested reading :-

[www.percona.com]

[dev.mysql.com]

[dev.mysql.com]

---------------------------------------------------------------------------------------------
(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.