There is no internal MySQL command to trace this, it’s a little too abstract. The file might be in 5 (or more?) locations, and they would all be valid because they load cascading.
- /etc/my.cnf
- /etc/mysql/my.cnf
- $MYSQL_HOME/my.cnf
- [datadir]/my.cnf
- ~/.my.cnf
Those are the default locations MySQL looks at. If it finds more than one, it will load each of them & values override each other (in the listed order, I think). Also, the --defaults-file
parameter can override the whole thing, so… basically, it’s a huge pain in the butt.
But thanks to it being so confusing, there’s a good chance it’s just in /etc/my.cnf.
(if you just want to see the values: SHOW VARIABLES
, but you’ll need the permissions to do so.)
Related Posts:
- error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
- error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
- WordPress cloning issue
- How to bind MySQL server to more than one IP address?
- How can I export the privileges from MySQL and then import to a new server?
- What is the debian-sys-maint MySQL user (and more)?
- Chmod 777 to a folder and all contents [duplicate]
- Cannot connect to the Docker daemon at unix:/var/run/docker.sock. Is the docker daemon running?
- Amazon Linux: apt-get: command not found
- How do I find all files containing specific text on Linux?
- “Couldn’t find a file descriptor referring to the console” on Ubuntu bash on Windows
- Where can I find php.ini?
- gzip: stdin: not in gzip format tar: Child returned status 1 tar: Error is not recoverable: exiting now
- Linux: ‘Username’ is not in the sudoers file. This incident will be reported
- “E: Unable to locate package python-pip” on Ubuntu 18.04 [duplicate]
- How can I exclude directories from grep -R?
- How to exclude a directory in find . command
- mysql_config not found when installing mysqldb python interface
- Linux error while loading shared libraries: cannot open shared object file: No such file or directory
- Shell command to tar directory excluding certain files/folders
- QEMU: /bin/sh: can’t access tty; job control turned off
- Explaining the ‘find -mtime’ command
- Meaning of exit status 1 returned by linux command
- Creating a new directory in C
- Extract file basename without path and extension in bash
- How to change permissions for a folder and its subfolders/files in one step
- mv: cannot stat error : No such file or directory error
- mysql_config not found when installing mysqldb python interface
- Linux error while loading shared libraries: cannot open shared object file: No such file or directory
- Pseudo-terminal will not be allocated because stdin is not a terminal
- linux command to get size of files and directories present in a particular folder?
- screen Cannot open your terminal ‘/dev/pts/0’ – please check
- ./configure : /bin/sh^M : bad interpreter
- TCP congestion control version: HTCP module vs highspeed module in linux kernel
- How to use regex with find command?
- What is the difference between /etc/rc.local and ~/.bashrc?
- Snort Message – WARNING: No preprocessors configured for policy 0
- Compile the Fortran program in Windows using gfortran
- How can I set the ‘backend’ in matplotlib in Python?
- Yum fails with – There are no enabled repos.
- How to get the process ID to kill a nohup process?
- Unable to establish SSL connection upon wget on Ubuntu 14.04 LTS
- Writing a simple shell in C using fork/execvp
- Using ls to list directories and their total sizes
- configure: error: cannot run C compiled programs
- tar: add all files and directories in current directory INCLUDING .svn and so on
- What does set -e mean in a bash script?
- What does set -e mean in a bash script?
- “find: paths must precede expression:” How do I specify a recursive search that also finds files in the current directory?
- Difference between exec, execvp, execl, execv?
- Configuring Apache for localhost
- Restarting cron after changing crontab file?
- cd into directory without having permission
- Android – Command not found
- EC2 ssh Permission denied (publickey,gssapi-keyex,gssapi-with-mic)
- What does ‘bash -c’ do?
- Error establishing a database connection – WordPress setup, everything else is working
- How to edit content in WordPress and the Polylang – plugin? – with demosite
- How can I sort du -h output by size
- What exactly do the colors in htop status bars mean?
- Why is my crontab not working, and how can I troubleshoot it?
- Showing total progress in rsync: is it possible?
- Why is “chmod -R 777 /” destructive?
- What’s the best way of handling permissions for Apache 2’s user www-data in /var/www?
- How to check if a library is installed?
- Is it normal to get hundreds of break-in attempts per day?
- How to setup passwordless `sudo` on Linux?
- How do I prevent accidental rm -rf /*?
- How do I verify the speed of my NIC?
- What does Virtual memory size in top mean?
- What’s the best way to check if a volume is mounted in a Bash script?
- How do I find the UUID of a filesystem
- Find out symbolic link target via command line
- Meaning of directories on Unix and Unix like systems
- How to handle security updates within Docker containers?
- Job scheduling using crontab, what will happen when computer is shutdown during that time?
- Is it possible to make Nginx listen to different ports?
- how do you create an ssh key for another user?
- REJECT vs DROP when using iptables
- Linux command line best practices and tips?
- How to run command as user who has /usr/sbin/nologin as Shell?
- How to get pid of just started process
- How to disable everything in crontab -l?
- df says disk is full, but it is not
- Perform rsync while following sym links
- What is the maximum port number?
- Show all users and their groups/vice versa
- Why is TCP accept() performance so bad under Xen?
- Caching/preloading files on Linux into RAM
- How to sort ps output by process start time?
- What’s wrong with always being root?
- Is there a proper way to clear logs?
- Hundreds of failed ssh logins
- Transfer 15TB of tiny files
- What should I do when I got the KEYEXPIRED error message after an apt-get update?
- protocol version mismatch — is your shell clean?
- How do I join two named pipes into single input stream in linux
- How should an IT department choose a standard Linux distribution?
- Command line program to test DHCP service
- Service start request repeated too quickly, refusing to start limit