mysql客户端“.my.cnf"在什么位置?在 Windows 的 XAMPP 中?

2021-11-20 00:00:00 windows xampp mysql

Windows下使用XAMPP的mysql客户端.my.cnf在什么位置?

What is the location of mysql client .my.cnf using XAMPP in Windows?

澄清:这个文件默认是不存在的，所以创建的时候，应该放在哪里，让命令行客户端自动读取?

Clarification: This file does not exist by default, so when you create it, where should you place it, in order for the command line client to read it automatically?

推荐答案

输入:

mysql --help

然后看输出.大约 3/4 处的文本块描述了它从哪些文件中找到其默认值 .my.cnf.以下是 XAMPP v3.2.1 中的示例:

Then look at the output. There is a block of text about 3/4 the way down describing what files it finds its defaults .my.cnf from. Here is an example from XAMPP v3.2.1:

Default options are read from the following files in the given order: C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\xampp\mysql\my.ini C:\xampp\mysql\my.cnf C:\xampp\mysql\bin\my.ini C:\xampp\mysql\bin\my.cnf

您的设置可能有所不同.您必须运行该命令以检查特定系统上的实际路径.

Your setup may differ. You will have to run the command to check the actual paths on your particular system.

相关文章