Locating MySQL .ini File from the Command Line - Dave's Search

Click For Summary
To determine the location of the MySQL configuration (.ini) file from the command line, users can utilize the command "mysql --help," which provides detailed information, including the paths to configuration files. The discussion highlights a common issue where MySQL installations may place the executable and configuration files in different directories, such as executables in "C:\Program Files\MySQL" and configuration files in "C:\Program Data\MySQL." This discrepancy can lead to confusion, but the command line offers a straightforward way to identify the correct paths.
cpscdave
Messages
402
Reaction score
120
I found this before out on the interwebs, but alas can't find it today.

How can you print the location of the .ini file that MySQL is using from the MySQL command line??
Thanks,
-Dave
 
Technology news on Phys.org
Note quite,
I thought there was a way you could use SHOW. Maybe I've found it but the setup I have here is different...

Issue came when I installed a MySQL server, it put the executable in c:\program files\MySQL
but the ini and data directories were in c:\Program Data\MySQL\

Some how I used the command line to figure that out :)
 
So yeah you can just do mysql --help and it will tell you in the middle of the wall of text it outputs :)
 

Thread 'Who is responsible for the software when AI takes over programming?'

I tried a web search "the loss of programming ", and found an article saying that all aspects of writing, developing, and testing software programs will one day all be handled through artificial intelligence. One must wonder then, who is responsible. WHO is responsible for any problems, bugs, deficiencies, or whatever malfunctions which the programs make their users endure? Things may work wrong however the "wrong" happens. AI needs to fix the problems for the users. Any way to...
View full post »

Similar threads

Mysqld command does not start the MySQL Server
  • · Replies 12 ·
Replies
12
Views
11K
Python Most efficient way to randomly choose a word from a file with a list of words
  • · Replies 35 ·
2
Replies
35
Views
6K
Searching through many tables in MySQL
  • · Replies 21 ·
Replies
21
Views
3K
Learning Database Concepts & Applications
  • · Replies 16 ·
Replies
16
Views
3K
Trying To Run A Python File [Solved]
  • · Replies 2 ·
Replies
2
Views
1K
Java FileFinder using Breadth First Search algorithm fails
  • · Replies 2 ·
Replies
2
Views
2K
Small confusion about redirection in Linux
  • · Replies 10 ·
Replies
10
Views
2K
How do I connect a button pressed signal with code in Godot 4?
  • · Replies 1 ·
Replies
1
Views
5K
Git, staging and committing files
  • · Replies 20 ·
Replies
20
Views
4K
Python De-Shebanging a Python program file
  • · Replies 10 ·
Replies
10
Views
2K