2.3.3.7 Customizing the PATH for MySQL Tools (original) (raw)

The world's most popular open source database

2.3.3.7 Customizing the PATH for MySQL Tools

Warning

You must exercise great care when editing your systemPATH by hand; accidental deletion or modification of any portion of the existingPATH value can leave you with a malfunctioning or even unusable system.

To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable:

• On the Windows desktop, right-click the My Computer icon, and select .
• Next select the tab from the menu that appears, and click the Environment Variables button.
• Under System Variables, select , and then click theEdit button. The dialogue should appear.
• Place your cursor at the end of the text appearing in the space marked Variable Value. (Use theEnd key to ensure that your cursor is positioned at the very end of the text in this space.) Then enter the complete path name of your MySQLbin directory (for example,C:\Program Files\MySQL\MySQL Server 8.4\bin)
  Note
  There must be a semicolon separating this path from any values present in this field.
  Dismiss this dialogue, and each dialogue in turn, by clicking OK until all of the dialogues that were opened have been dismissed. The newPATH value should now be available to any new command shell you open, allowing you to invoke any MySQL executable program by typing its name at the DOS prompt from any directory on the system, without having to supply the path. This includes the servers, themysql client, and all MySQL command-line utilities such as mysqladmin andmysqldump.

You should not add the MySQL bin directory to your Windows PATH if you are running multiple MySQL servers on the same machine.