Installing MySQL - Learning MySQL - page 79

143/tcp open imap
631/tcp open ipp
1494/tcp open citrix-ica
3306/tcp open mysql
6000/tcp open X11
8080/tcp open http-proxy
32770/tcp open sometimes-rpc3
Nmap finished: 1 IP address (1 host up) scanned in 0.472 seconds
Here, you can see that there is a MySQL server listening on port 3306.
A good place to find clues to your problem is to look at the error logfile; this is normally
in the data directory with the system host name and the extension .err . For example,
the logfile for the host eden.learningmysql.com is generally called eden.err or eden.lear
ningmysql.com.err . For a Linux host, this might be the file /var/lib/mysql/eden.err , /usr/
local/mysql/eden.err , or /opt/lampp/var/mysql/eden.err , depending on the way MySQL
was installed. Similarly, on a Windows system, possible locations for the error logfile
include C:\mysql-5.0.22-win32\data\eden.err , C:\Program Files\MySQL
\MySQL Server 5.0\data\eden.err , and C:\Program Files\xampp\mysql\data\eden.err . Fi-
nally, for a Mac OS X system, likely locations for the error logfile are /usr/local/mysql/
eden.err and /Applications/xampp/xamppfiles/var/mysql/eden.err .
You can use the more command to look inside this file:
$ more /var/lib/mysql/eden.err
050813 22:31:04 mysqld started
050813 22:31:04 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
050813 22:31:04 mysqld ended
This particular message indicates that the directory permissions may not be set cor-
rectly. Press Ctrl-C to exit the more program.
If you installed MySQL on a Linux system using packages provided by your Linux
distribution, you may instead find the MySQL logs under a different name—for ex-
ample, mysqld.log , in the /var/log/mysql or /var/log/mysqld directory.
Client Programs Can't Connect to the Server
Consider these questions:
1. Did you use the correct username and password? Since the default MySQL instal-
lation doesn't have a password set, it is easy to be confused when passwords are
enabled. For the MySQL command-line tools, try using the user and password
options. If you've forgotten your password, try resetting it by following the steps
of “Resetting Forgotten MySQL Passwords” in Chapter 9.