How to configure mysql environment variables

How to configure MySQL environment variables? Find the MySQL installation path (such as C:\Program Files\MySQL\MySQL Server 8.0 in Windows). Configure the PATH variable and add the MySQL bin folder path. Configure the MYHOME and MYSQL_HOME variables to specify the MySQL installation path respectively. Test the environment variable configuration and enter mysql --version in the terminal to check whether the output is correct.

Configure MySQL environment variables

In order to use MySQL in the system, you need to configure the environment variables to specify the installation of MySQL path and other necessary information. Here's how to configure MySQL environment variables:

1. Find the MySQL installation path

• In Windows, this is usually located at C:\Program Files\ MySQL\MySQL Server 8.0.
• On macOS and Linux, usually located at /usr/local/mysql.

2. Configure PATH

• Windows:

  • right click Click "This PC" and select "Properties."
  • Select the "Advanced System Settings" tab.
  • Click "Environment Variables".
  • In the "System Variables" section, select the "Path" variable and click "Edit".
  • Add the path to the MySQL bin folder at the end of "Variable Value" (such as C:\Program Files\MySQL\MySQL Server 8.0\bin).

• macOS and Linux:

  • Enter the following command in a terminal window:

    <code>export PATH=$PATH:~/mysql/bin</code>

3. Configure MYHOME

• ##Windows:

  In the "Environment Variables" window, click "New".
  • Enter
  • MYHOME in the "Variable Name" field, and enter the MySQL installation path in the "Variable Value" field (such as C:\Program Files\MySQL\MySQL Server 8.0).

• macOS and Linux:

  ##Enter the following command:

  • <code>export MYHOME=~/mysql</code>

4. Configure MYSQL_HOME

##Windows:

• In In the Environment Variables window, click New.

  Enter
  • MYSQL_HOME
  in the "Variable Name" field, and enter the MySQL installation path in the "Variable Value" field (such as
  • C:\Program Files\MySQL\MySQL Server 8.0).
macOS and Linux:

• ##Enter the following command:

  <code>export MYSQL_HOME=~/mysql</code>

  5. Test

Enter mysql --version

in the terminal window.

• If the MySQL version information is output, the environment variable is configured successfully.

The above is the detailed content of How to configure mysql environment variables. For more information, please follow other related articles on the PHP Chinese website!