Many Mac users need to confirm whether MySQL is installed before starting new projects or troubleshooting database issues. This guide walks through reliable methods to check the installation status and version details.
The following table summarizes the quickest ways to verify a MySQL installation on macOS, including command, expected output, and privilege requirements.
| Method | Command | Requires Sudo | Use Case |
|---|---|---|---|
| Check binary with version flag | mysql --version | No | Quick installed check |
| Check binary location | which mysql | No | Confirm which binary is used |
| List managed services | brew services list | grep mysql | No | Homebrew managed processes |
| Query server process | ps aux | grep mysql | No | Verify running instance |
| Connect to server | mysql -u root -p -e "SELECT VERSION()" | Yes if privileged user required | Validate server responsiveness |
Checking MySQL Installation via Terminal
The Terminal app on macOS provides direct access to the command line tools that report MySQL status. You can run simple commands to see whether the MySQL client and server components exist and are reachable.
Open Terminal and begin with lightweight checks before escalating to queries that require authentication or elevated permissions.
Using mysql --version
The mysql --version command prints the client version without connecting to any server. If this command is not found, the MySQL client binary is likely not in your PATH or not installed.
Using which mysql
The which mysql command returns the full path to the MySQL executable. A missing output indicates that the client binary is unavailable, while a path suggests the client component is present.
Verifying MySQL Server Status
Confirming that the MySQL server is installed is not enough; you also need to know whether the server process is actively running and accepting connections.
Use process and service queries to validate that the background database daemon is present and operational on your Mac.
Listing Homebrew Services
If you installed MySQL through Homebrew, you can list managed services with brew services list and filter for MySQL. This shows whether the service is started, stopped, or loaded.
Searching Running Processes
The command ps aux | grep mysql shows any MySQL-related processes such as mysqld or mysqladmin. The presence of a mysqld process indicates that the server is running, provided the line is not the grep command itself.
Testing MySQL Server Responsiveness
To verify that the server is not only installed but also functional, connect to it using the MySQL client. This step often requires sudo or access to a privileged account.
A successful connection with a returned version number confirms that both the client and server are properly configured and communicating.
MySQL Installation Locations on Mac
Depending on the installation method, MySQL binaries and configuration files reside in different standard locations on macOS.
Understanding these paths helps with troubleshooting, configuration edits, and manual operations.
Common Binary Paths
For Homebrew installations, binaries are typically under /usr/local/bin or /opt/homebrew/bin on Apple Silicon. Native package installers may place files in /usr/local/mysql/bin.
Configuration and Data Directories
Configuration files often reside in /etc or within the local installation prefix, while data directories are commonly located under /usr/local/var/mysql or /opt/homebrew/var/mysql.
Next Steps for Managing MySQL on Mac
Use these key points as a checklist for verifying and maintaining MySQL on macOS.
- Run
mysql --versionto confirm client installation - Use
which mysqlto locate the binary path - Check Homebrew services if you use brew to install MySQL
- Inspect running processes with
ps aux | grep mysql - Test server connectivity with a simple authenticated query
- Verify configuration and data directories for custom setups
FAQ
Reader questions
How do I know if MySQL was installed with Homebrew or a native package?
Check for Homebrew services with brew services list | grep mysql and verify the binary path using which mysql . Homebrew paths typically contain /Homebrew or /opt/homebrew .
What does 'command not found: mysql' mean?
This indicates that the MySQL client binary is not in your shell’s PATH, or MySQL client tools were never installed, even if the server exists.
Why does mysql --version succeed but mysql -u root fail?
The client binary can be present while the server is stopped or not configured for local access. This mismatch means the installation is detected, but the service is not running or accepting connections.
How can I check if the MySQL daemon is running without using ps aux?
Use brew services info mysql for Homebrew-managed setups, or check the Activity Manager for running MySQL processes on macOS.