MySQL Bugs: #61907: mysql and mysqladmin not working due to missing directory /etc/mysql/conf.d

Bug #61907	mysql and mysqladmin not working due to missing directory /etc/mysql/conf.d
Submitted:	19 Jul 2011 12:28	Modified:	9 Aug 2011 19:38
Reporter:	Rotem Fogel	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: General	Severity:	S3 (Non-critical)
Version:	5.5.14	OS:	Windows (x64)
Assigned to:		CPU Architecture:	Any
Tags:	conf.d, MySQL, mysqladmin

Description:
clients are not working, reporting missing directories on windows x64.
Both with downloaded version and built version.

an error appears:
mysql: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted

How to repeat:
1. download 5.5.14 for windows x64
2. unzip
3. start the server
4. try to connect

an error appears:
mysql: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted

Suggested fix:
a workaround is to create the missing directories:
mkdir \etc\mysql\conf.d

Thank you for the bug report. Could you please attach the my.ini file which server is using. I couldn't repeat on Vista 64-bit. Thanks.

Thank you for the feedback. Ho I said I can't repeat:

C:\mysql-5.5.14-winx64>bin\mysqladmin -uroot version
bin\mysqladmin  Ver 8.42 Distrib 5.5.14, for Win64 on x86
Copyright (c) 2000, 2010, 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.

Server version          5.5.14
Protocol version        10
Connection              localhost via TCP/IP
TCP port                3306
Uptime:                 36 sec

Threads: 1  Questions: 1  Slow queries: 0  Opens: 33  Flush tables: 1  Open tables: 26  Queries per second avg: 0.27

C:\mysql-5.5.14-winx64>

Rotem, have you tried this:

mysql.exe --no-defaults -uroot -h127.0.0.1 -p

works fine.

C:\>mysql.exe --no-defaults -uroot
mysql.exe: Unknown OS character set 'cp862'.
mysql.exe: Switching to the default character set 'latin1'.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.14 MySQL Community Server (GPL)

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

so it just means you have a rogue my.ini or my.cnf on your system contain linux paths ... Find it like:

c:
cd\
dir /s /a my.cnf
dir /s /a my.ini

Please check what Shane is asked for. This is actually not a bug.