How to Fix the "MySQL Command Not Found" Error?

If you encounter the "MySQL command not found" error when trying to run MySQL commands in your terminal or command prompt, it typically indicates that the system cannot locate the MySQL binary files. Here are steps to resolve this issue on various operating systems:

1. Verify MySQL Installation

First, confirm that MySQL is installed on your system:

• On Linux, use the command:
  
  

• On Windows, open Command Prompt and type:
  
  

If you get a version response, MySQL is installed but might not be in your PATH. If not, install MySQL or troubleshoot the installation.

2. Add MySQL to the System PATH

Your system's PATH variable tells the OS where to look for executable files. If MySQL isn't in this path, you'll get the "command not found" error.

For Linux

1. Locate the MySQL directory, often found in /usr/bin/mysql or /usr/local/mysql/bin.

2. Open your .bashrc or .zshrc file:
   
   

3. Add the following line, replacing with the MySQL directory path:
   
   

4. Save and reload the configuration:
   
   

For macOS

1. Find the MySQL path, usually /usr/local/mysql/bin.

2. Open the terminal configuration file (e.g., .zshrc or .bash_profile).

3. Add the MySQL path:
   
   

4. Save and reload:
   
   

For Windows

1. Locate the MySQL installation folder (commonly C:\Program Files\MySQL\MySQL Server 8.0\bin).

2. Go to System Properties > Environment Variables.

3. Find the Path variable under System Variables, click Edit, and add your MySQL path.

4. Click OK and restart Command Prompt.

3. Test the MySQL Command

After adding MySQL to your PATH, test if the command works by opening a new terminal or Command Prompt and typing:

If configured correctly, you should see the MySQL version, indicating the error is resolved.

Was this answer helpful? 0 0