Databases Reference
In-Depth Information
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: 13)
Fill help tables
/home/saied/mysql/libexec/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)
...
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 (127.0.0.1):
Not shown: 1669 closed ports
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
80/tcp open http
