Learning Mysql

at the command line. If the MySQL bin directory isn’t listed there, take the following steps.
For a Linux or Mac system, open your
/.bashrc shell configuration file (start anew file if there isn’t one already) in a text editor using the instructions in Using a Text Editor at the beginning of this chapter, and add this line to the bottom:
export PATH=$PATH:/usr/local/mysql/bin:
If you use a shell other than bash, you’ll need to edit the appropriate shell configuration file. For example, if you use tcsh
, you’ll need to edit the
/.tcshrc or
/.cshrc file and add the line:
setenv PATH $PATH:/usr/local/mysql/bin
To activate the changes, type
$
source
/.bashrc
, logout and login again, or simply restart the computer.
For Windows, you can update the path in two ways. The first way is to run the MySQL
server configuration program again by selecting MySQL Server Instance Config Wizard from the Windows Start menu and selecting the Include Bin Directory in Windows
PATH” checkbox as described earlier in this chapter.
The second way is to manually add the appropriate entry to your Windows path by following these steps. Open the Windows control panel. If you don’t have the control panel Classic View enabled (its disabled by default),
you’ll need to step through one additional window (if you have Classic View enabled, you can skip this step. Under XP, if you have Category View enabled, you’ll see an icon for Performance and Maintenance open this. Under Vista, the control panel window will open at the Control Panel Home view by default click on the
System and Maintenance entry. Open the System entry. Under Vista, click on the Advanced System Settings link under the list of tasks. Select the Advanced tab. Click on the Environment Variables button. In the bottom half of the window, you’ll seethe System variables pane. Scroll down this list until you see an entry for Path. Double-click on this entry, or select it and press the Edit button. In the dialog box that appears, go to the end of the Variable value field and add a semicolon followed by the path to the MySQL bin directory. For example, if you installed MySQL to the C:\Program Files\MySQL\MySQL Server 5.0\bin directory,
you should add:
;C:\Program Files\MySQL\MySQL Server 5.0\bin
The semicolon at the start is a delimiter used to separate entries in the system path.

Download 4.24 Mb.

Share with your friends: