What If Things Don’t Work | 77

9. Press the OK button to close the edit dialog box, and then press the OK button to close the Environment Variables dialog box. The new path should be active immediately.
Error Message Running mysql_install_db
If, on a Linux or Mac OS X system, you get messages like these when running mysql_install_db
:
$ bin/mysql_install_db
Installing all prepared tables
/home/saied/mysql/libexec/mysqld: Can't read dir of '/root/tmp/' (Errcode: Fill help tables
/home/saied/mysql/libexec/mysqld: Can't read dir of '/root/tmp/' (Errcode: then the setting for your temporary files isn’t set correctly. The solution is to declare the directory to use for temporary files as export TMPDIR=/tmp
On most systems, the directory /tmp is present and accessible by all users. You can use any other directory you wish, but remember that it must exist, and you must have permission to create and delete files in that directory.
Server Doesn’t Start
Possible questions to ask yourself include Do you have filesystem access to the MySQL commands Under Linux, try running mysqld_safe as the user root. Under Windows, ensure that you have administrator privileges. Under Mac OS X, check that you used the sudo keyword when calling mysqld_safe
• Is the server already running Try stopping the server first and then starting it again Is there another server using port 3306? Try starting your server with a different port using the port option.
If you’re interested, you can list the open ports on a system using the open source nmap security scanner program that is available for Linux, Windows, and Mac OS
X. To list the open ports on your own machine (
localhost
), you’d type nmap localhost
Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2006-07-23 02:09 EST
Interesting ports on saied-ltc.cs.rmit.edu.au (Not shown 1669 closed ports
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
80/tcp open http

Download 4.24 Mb.

Share with your friends: