Centos6.5下Jdk+Tomcat+Mysql环境安装图文教程

[root@xiaoluo ~]# service mysqld start

初始化 MySQL 数据库： WARNING: The host 'xiaoluo' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h xiaoluo password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

               [确定]
正在启动 mysqld：           [确定]

[root@xiaoluo ~]# service mysqld restart
停止 mysqld：            [确定]
正在启动 mysqld：           [确定]
 

[root@xiaoluo ~]# chkconfig --list | grep mysqld
mysqld    0:关闭 1:关闭 2:关闭 3:关闭 4:关闭 5:关闭 6:关闭

[root@xiaoluo ~]# chkconfig mysqld on
[root@xiaoluo ~]# chkconfig --list | grep mysql
mysqld    0:关闭 1:关闭 2:启用 3:启用 4:启用 5:启用 6:关闭

[root@xiaoluo etc]# ls my.cnf 
my.cnf

[root@xiaoluo etc]# cat my.cnf 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[root@xiaoluo ~]# cd /var/lib/mysql/
[root@xiaoluo mysql]# ls -l
总用量 20488
-rw-rw----. 1 mysql mysql 10485760 4月 6 22:01 ibdata1
-rw-rw----. 1 mysql mysql 5242880 4月 6 22:01 ib_logfile0
-rw-rw----. 1 mysql mysql 5242880 4月 6 21:59 ib_logfile1
drwx------. 2 mysql mysql  4096 4月 6 21:59 mysql　　// 这两个是mysql数据库安装时默认的两个数据库文件
srwxrwxrwx. 1 mysql mysql  0 4月 6 22:01 mysql.sock
drwx------. 2 mysql mysql  4096 4月 6 21:59 test　　// 这两个是mysql数据库安装时默认的两个数据库文件

//创建一个我们自己的数据库：
mysql> create database xiaoluo;
Query OK, 1 row affected (0.00 sec)

[root@xiaoluo mysql]# ls -l
总用量 20492
-rw-rw----. 1 mysql mysql 10485760 4月 6 22:01 ibdata1
-rw-rw----. 1 mysql mysql 5242880 4月 6 22:01 ib_logfile0
-rw-rw----. 1 mysql mysql 5242880 4月 6 21:59 ib_logfile1
drwx------. 2 mysql mysql  4096 4月 6 21:59 mysql
srwxrwxrwx. 1 mysql mysql  0 4月 6 22:01 mysql.sock
drwx------. 2 mysql mysql  4096 4月 6 21:59 test
drwx------. 2 mysql mysql  4096 4月 6 22:15 xiaoluo　　// 这个就是我们刚自己创建的xiaoluo数据库
[root@xiaoluo mysql]# cd xiaoluo/
[root@xiaoluo xiaoluo]# ls
db.opt

[root@xiaoluo xiaoluo]# cd 
[root@xiaoluo ~]# cd /var/log
[root@xiaoluo log]# ls
amanda    cron   maillog-20130331 spice-vdagent.log
anaconda.ifcfg.log cron-20130331 mcelog    spooler
anaconda.log   cups   messages   spooler-20130331
anaconda.program.log dirsrv   messages-20130331 sssd
anaconda.storage.log dmesg   mysqld.log   tallylog
anaconda.syslog  dmesg.old  ntpstats   tomcat6
anaconda.xlog   dracut.log  piranha   wpa_supplicant.log
anaconda.yum.log  gdm   pm-powersave.log wtmp
audit     httpd   ppp    Xorg.0.log
boot.log    ibacm.log  prelink   Xorg.0.log.old
btmp     lastlog  sa     Xorg.1.log
btmp-20130401   libvirt  samba    Xorg.2.log
cluster    luci   secure    Xorg.9.log
ConsoleKit   maillog  secure-20130331 yum.log