Learning Mysql

143/tcp open imap
631/tcp open ipp
1494/tcp open citrix-ica
3306/tcp open mysql
6000/tcp open X 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 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. Fora 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. Finally, fora 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 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: Filename ./ibdata1
InnoDB: File operation call 'create'.
InnoDB: Cannot continue operation 22:31:04 mysqld ended
This particular message indicates that the directory permissions may not beset correctly. 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 example, mysqld.log, in the /var/log/mysql or /var/log/mysqld directory.

Download 4.24 Mb.

Share with your friends: