MySQL Bugs: #78002: No configured login info, yet mysql cannot connect

Bug #78002	No configured login info, yet mysql cannot connect
Submitted:	10 Aug 2015 4:13	Modified:	11 Aug 2015 15:15
Reporter:	Stephen Isienyi	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.6.26	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	error 2003

Description:
Pressing enter at the password prompt produces: ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10060). The service is up and running on my PC. I do not have any login information configured. Yet I continue to get this error. I am beginning to lose my mind here. I have followed the installation instructions verbatim, yet this error persists. Nothing seems to work! The error message is not helpful. My online research suggested numerous far-fetched causes and befitting far-fetched solutions; none of which worked. What kind of a thing is this?

Please take a quick look. I ran the command below and pasted the info below just in case that could help as well.

Thanks

C:\mysql-5.6.26\bin>mysqld --standalone --console
2015-08-09 23:23:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2015-08-09 23:23:45 0 [Note] mysqld (mysqld 5.6.26) starting as process 8276 ...

2015-08-09 23:23:46 8276 [Note] Plugin 'FEDERATED' is disabled.
2015-08-09 23:23:46 8276 [Note] InnoDB: Using atomics to ref count buffer pool p
ages
2015-08-09 23:23:46 8276 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-09 23:23:46 8276 [Note] InnoDB: Mutexes and rw_locks use Windows interlo
cked functions
2015-08-09 23:23:46 8276 [Note] InnoDB: Memory barrier is not used
2015-08-09 23:23:46 8276 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-09 23:23:46 8276 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-09 23:23:46 8276 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-09 23:23:46 8276 [Note] InnoDB: Completed initialization of buffer pool
2015-08-09 23:23:47 8276 [Note] InnoDB: Highest supported file format is Barracu
da.
2015-08-09 23:23:53 8276 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-09 23:23:53 8276 [Note] InnoDB: Waiting for purge to start
2015-08-09 23:23:53 8276 [Note] InnoDB: 5.6.26 started; log sequence number 1625
987
2015-08-09 23:23:54 8276 [Note] Server hostname (bind-address): '*'; port: 3306
2015-08-09 23:23:54 8276 [Note] IPv6 is available.
2015-08-09 23:23:54 8276 [Note]   - '::' resolves to '::';
2015-08-09 23:23:54 8276 [Note] Server socket created on IP: '::'.
2015-08-09 23:24:04 8276 [Note] Event Scheduler: Loaded 0 events
2015-08-09 23:24:04 8276 [Note] mysqld: ready for connections.
Version: '5.6.26'  socket: ''  port: 3306  MySQL Community Server (GPL)

How to repeat:
C:\Windows\System32>cd C:\mysql-5.6.26\bin

C:\mysql-5.6.26\bin>mysqld --install
Service successfully installed.

<<Started the MySQL service up and running>>

C:\mysql-5.6.26\bin>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10060)

C:\mysql-5.6.26\bin>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10060)

Hello Stephen Isienyi,

Thank you for the bug report.
I could not reproduce this issue at my end using MySQL installation.
Could you please list out exact steps you tried out at your end, this would help us to reproduce the issue at our end.

MySQL installation manual:
https://dev.mysql.com/doc/refman/5.6/en/windows-install-archive.html

Thanks,
Chiranjeevi.

Results:

1. Run your cmd as administrator.

2.What you will see is like this
c:\windows\system32>

3.Go to your bin location like D:\MySQL\5.6.26\bin (in my case)

D:\MySQL\5.6.26\bin>mysqld --install
Service successfully installed.

D:\MySQL\5.6.26\bin>net start MySql
The MySQL service is starting.
The MySQL service was started successfully.

D:\MySQL\5.6.26\bin>mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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>

Hi Chiranjeevi Battula,
Please take a look below at the retrial steps running as admininstrator.
Thanks,
Stephen

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Windows\system32>cd C:\mysql-5.6.26\bin

C:\mysql-5.6.26\bin>mysqld --install
The service already exists!
The current server installed: C:\mysql-5.6.26\bin\mysqld MySQL

C:\mysql-5.6.26\bin>net start MySql
The requested service has already been started.

More help is available by typing NET HELPMSG 2182.

C:\mysql-5.6.26\bin>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10060)

C:\mysql-5.6.26\bin>

I uninstalled the service and the service, and used the installer instead. Now I am getting this error:

configuration of mysql 5.6.26 is taking longer than expected.
Do you want to continue waiting or cancel the configuration?
If you keep waiting you may get this message again.

Is there a way to correct this? What could be the consequences if I choose to cancel the configuration process?

Thanks

Hello Stephen Isienyi,

Thank you for your feedback.
This is duplicate of Bug #76476, please see Bug #76476

Thanks,
Chiranjeevi.

None of those suggestions on those threads fixed the issue. One of them (see link below) is so off-beaten that if I am the maker of this software, I would be forced to either revamp this software in its totality or scrap it. 

http://stackoverflow.com/questions/26970454/mysql-configuration-stops-at-starting-server/2...