centOS Linux下用yum安装mysql(四)
/log
[root@192 log]# ls
acpid boot.log.2 conman.old dmesg maillog messages.2 ppp samba setroubleshoot tallylog
anaconda.log boot.log.3 cron faillog maillog.1 messages.3 prelink scrollkeeper.log spooler vbox
anaconda.syslog boot.log.4 cron.1 gdm maillog.2 messages.4 rpmpkgs secure spooler.1 wtmp
anaconda.xlog brcm-iscsi.log cron.2 httpd maillog.3 mysqld.log rpmpkgs.1 secure.1 spooler.2 xen
audit btmp cron.3 lastlog maillog.4 news rpmpkgs.2 secure.2 spooler.3 Xorg.0.log
boot.log clumond.log cron.4 libvirt messages piranha rpmpkgs.3 secure.3 spooler.4 Xorg.0.log.old
boot.log.1 conman cups mail messages.1 pm rpmpkgs.4 secure.4 squid yum.log
二、数据库服务器
mysql是支持网络的数据库服务器，经常需要通过互联网去访问，mysql默认使用tcp协议，端口是3306
[root@192 log]# cat mysqld.log
130503 11:25:03 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130503 11:25:07 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130503 11:25:09 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130503 11:25:09 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130503 11:25:12 InnoDB: Started; log sequence number 0 0
130503 11:25:12 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.95' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
[root@192 log]# netstat -tupln
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:2208 0.0.0.0:* LISTEN 3569/hpiod
tcp 0 0 0.0.0.0:5989 0.0.0.0:* LISTEN 3905/cimserver
tcp 0 0 0.0.0.0:11111 0.0.0.0:* LISTEN 4783/ricci
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3549/mysqld
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 2854/portmap
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 13747/httpd
tcp 0 0 0.0.0.0:16851 0.0.0.0:* LISTEN 4669/modclusterd
tcp 0 0 192.168.122.1:53 0.0.0.0:* LISTEN 3888/dnsmasq
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 3590/sshd
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 3602/cupsd
tcp 0 0 0.0.0.0:952 0.0.0.0:* LISTEN 2890/rpc.st