Apologies in advance for lack of information. I have installed MySQL 5.5 x64 on a Windows XP Professional x64 development machine. Today, upon trying to connect with any tool(MySQL workbench, PHP script, PhpMyAdmin, or command-line utility), the password is accepted but the connection is immediately closed:
C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -u root -p
Enter password: ***************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.5-m8 MySQL Community Server (GPL)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> Bye
C:\Program Files\MySQL\MySQL Server 5.6\bin>
I have attempted removing all MySQL server-related files by deleting the installation directory and C:\Documents and Settings\All Users\MySQL\MySQL server 5.6
, as well as D:\InnoDB Datafiles
, where my InnoDB Tablespace lies. There is no important data, but I am unable to get MySQL server to operate properly. If any more info is needed, please do tell.
I have installed MySQL with the MSI installer and the instance config wizard. I have also tried the 5.6 development version, to no avail.
Best Answer
A) Try with
Which one works and which does not?
B) Set
Log_warnings=2
inmy.ini
and restart MySQL server and see error log entry when connection gets closed abruptly.