과학도를 위한 Linux

테스트용 리눅스(centos-6.5_x85_64) apm 설치-③

NeoAlchemist 2014. 1. 4. 16:46
728x90
반응형

자 이젠 본격적으로 APM(apache + php + mysql)을 설치해보겠습니다.

 

우선 기본만 설치된 리눅스 서버이니까 필요한 패키지가 설치되어있는지 확인해봐야겠습니다.

 

[root@linux ~]# rpm -qa | grep mysql*
mysql-libs-5.1.71-1.el6.x86_64

 

mysql 관련으로 설치된 패키지는 이거뿐이군요 ㅋ

mysql 관련 패키지가 어떤것이 있는지 다음 명령으로(선홍색표기) 확인해보겠습니다

 

[root@linux ~]# yum install mysql*

Dependencies Resolved

==========================================================================
 Package                    Arch   Version                  Repository
                                                                     Size
==========================================================================
Installing:
 mysql                      x86_64 5.1.71-1.el6             base    893 k
 mysql-bench                x86_64 5.1.71-1.el6             base    428 k
 mysql-connector-java       noarch 1:5.1.17-6.el6           base    1.4 M
 mysql-connector-odbc       x86_64 5.1.5r1144-7.el6         base    114 k
 mysql-devel                x86_64 5.1.71-1.el6             base    129 k
 mysql-embedded             x86_64 5.1.71-1.el6             base    2.4 M
 mysql-embedded-devel       x86_64 5.1.71-1.el6             base    4.8 M
 mysql-server               x86_64 5.1.71-1.el6             base    8.6 M
 mysql-test                 x86_64 5.1.71-1.el6             base    5.3 M
Installing for dependencies:
 alsa-lib                   x86_64 1.0.22-3.el6             base    370 k
 apache-tomcat-apis         noarch 0.1-1.el6                base    164 k
 atk                        x86_64 1.30.0-1.el6             base    195 k
 avahi-libs                 x86_64 0.6.25-12.el6            base     54 k
 axis                       noarch 1.2.1-7.3.el6_3          base    1.5 M
 bcel                       x86_64 5.2-7.2.el6              base    1.4 M
 cairo                      x86_64 1.8.8-3.1.el6            base    309 k
 classpathx-jaf             x86_64 1.0-15.4.el6             base    100 k
 classpathx-mail            noarch 1.1.1-9.4.el6            base    479 k
 cups-libs                  x86_64 1:1.4.2-50.el6_4.5       base    317 k
 fontconfig                 x86_64 2.8.0-3.el6              base    186 k
 freetype                   x86_64 2.3.11-14.el6_3.1        base    359 k
 geronimo-specs             noarch 1.0-3.5.M2.el6           base    111 k
 geronimo-specs-compat      noarch 1.0-3.5.M2.el6           base    7.1 k
 gnutls                     x86_64 2.8.5-10.el6_4.2         base    346 k
 gtk2                       x86_64 2.20.1-4.el6             base    3.3 M
 hicolor-icon-theme         noarch 0.11-1.1.el6             base     40 k
 jakarta-commons-discovery  noarch 1:0.4-5.4.el6            base     73 k
 jakarta-commons-httpclient x86_64 1:3.1-0.7.el6_3          base    587 k
 jakarta-commons-logging    noarch 1.0.4-10.el6             base     52 k
 jasper-libs                x86_64 1.900.1-15.el6_1.1       base    136 k
 java-1.5.0-gcj             x86_64 1.5.0.0-29.1.el6         base    139 k
 java_cup                   x86_64 1:0.10k-5.el6            base    197 k
 jpackage-utils             noarch 1.7.5-3.12.el6           base     59 k
 keyutils-libs-devel        x86_64 1.4-4.el6                base     28 k
 krb5-devel                 x86_64 1.10.3-10.el6_4.6        base    495 k
 libICE                     x86_64 1.0.6-1.el6              base     53 k
 libSM                      x86_64 1.2.1-2.el6              base     37 k
 libX11                     x86_64 1.5.0-4.el6              base    584 k
 libX11-common              noarch 1.5.0-4.el6              base    192 k
 libXau                     x86_64 1.0.6-4.el6              base     24 k
 libXcomposite              x86_64 0.4.3-4.el6              base     20 k
 libXcursor                 x86_64 1.1.13-6.20130524git8f677eaea.el6
                                                            base     28 k
 libXdamage                 x86_64 1.1.3-4.el6              base     18 k
 libXext                    x86_64 1.3.1-2.el6              base     35 k
 libXfixes                  x86_64 5.0-3.el6                base     23 k
 libXft                     x86_64 2.3.1-2.el6              base     55 k
 libXi                      x86_64 1.6.1-3.el6              base     35 k
 libXinerama                x86_64 1.1.2-2.el6              base     20 k
 libXrandr                  x86_64 1.4.0-1.el6              base     36 k
 libXrender                 x86_64 0.9.7-2.el6              base     30 k
 libXtst                    x86_64 1.2.1-2.el6              base     29 k
 libart_lgpl                x86_64 2.3.20-5.1.el6           base     65 k
 libcom_err-devel           x86_64 1.41.12-18.el6           base     32 k
 libgcj                     x86_64 4.4.7-4.el6              base     19 M
 libjpeg-turbo              x86_64 1.2.1-3.el6_5            updates 174 k
 libpng                     x86_64 2:1.2.49-1.el6_2         base    182 k
 libselinux-devel           x86_64 2.0.94-5.3.el6_4.1       base    136 k
 libsepol-devel             x86_64 2.0.41-4.el6             base     64 k
 libthai                    x86_64 0.1.12-3.el6             base    183 k
 libtiff                    x86_64 3.9.4-9.el6_3            base    342 k
 libtool-ltdl               x86_64 2.2.6-15.5.el6           base     44 k
 libxcb                     x86_64 1.8.1-1.el6              base    110 k
 log4j                      x86_64 1.2.14-6.4.el6           base    679 k
 mx4j                       noarch 1:3.0.1-9.13.el6         base    1.1 M
 openssl-devel              x86_64 1.0.1e-16.el6_5.1        updates 1.2 M
 pango                      x86_64 1.28.1-7.el6_3           base    350 k
 perl                       x86_64 4:5.10.1-136.el6         base     10 M
 perl-DBD-MySQL             x86_64 4.013-3.el6              base    134 k
 perl-DBI                   x86_64 1.609-4.el6              base    705 k
 perl-Module-Pluggable      x86_64 1:3.90-136.el6           base     40 k
 perl-Pod-Escapes           x86_64 1:1.04-136.el6           base     32 k
 perl-Pod-Simple            x86_64 1:3.13-136.el6           base    212 k
 perl-Time-HiRes            x86_64 4:1.9721-136.el6         base     48 k
 perl-libs                  x86_64 4:5.10.1-136.el6         base    578 k
 perl-version               x86_64 3:0.77-136.el6           base     51 k
 pixman                     x86_64 0.26.2-5.1.el6_5         updates 200 k
 regexp                     x86_64 1.5-4.4.el6              base    105 k
 sinjdoc                    x86_64 0.5-9.1.el6              base    705 k
 slf4j                      noarch 1.5.8-8.el6              base    131 k
 unixODBC                   x86_64 2.2.14-12.el6_3          base    378 k
 wsdl4j                     noarch 1.5.2-7.8.el6            base    157 k
 xml-commons-apis           x86_64 1.3.04-3.6.el6           base    439 k
 xml-commons-resolver       x86_64 1.1-4.18.el6             base    145 k
 zip                        x86_64 3.0-1.el6                base    260 k
 zlib-devel                 x86_64 1.2.3-29.el6             base     44 k
Updating for dependencies:
 openssl                    x86_64 1.0.1e-16.el6_5.1        updates 1.5 M

Transaction Summary
==========================================================================
Install      85 Package(s)
Upgrade       1 Package(s)

Total download size: 75 M
Is this ok [y/N]: n
Exiting on user Command

 

설치할 패키지와 어마어마한 관련 패키지들이 뜨네요 ㄷㄷ

일단 꼭 필요하다고 생각되는 위 명령 결과값중 붉은색 패키지만 설치해보기로 하죠.

 

다음 명령으로 mysql rpm 패키지들을 설치하겠습니다.

 

[root@linux ~]# yum -y install mysql mysql-server mysql-connector-odbc mysql-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: ftp.neowiz.com
 * extras: ftp.neowiz.com
 * updates: ftp.neowiz.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.71-1.el6 will be installed
--> Processing Dependency: perl(Sys::Hostname) for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: perl(IPC::Open3) for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: perl(Getopt::Long) for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: perl(File::Temp) for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: perl(Fcntl) for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: perl(Exporter) for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: /usr/bin/perl for package: mysql-5.1.71-1.el6.x86_64
---> Package mysql-connector-odbc.x86_64 0:5.1.5r1144-7.el6 will be installed
--> Processing Dependency: unixODBC for package: mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
--> Processing Dependency: libodbcinst.so.2()(64bit) for package: mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
--> Processing Dependency: libltdl.so.7()(64bit) for package: mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
---> Package mysql-devel.x86_64 0:5.1.71-1.el6 will be installed
--> Processing Dependency: openssl-devel for package: mysql-devel-5.1.71-1.el6.x86_64
---> Package mysql-server.x86_64 0:5.1.71-1.el6 will be installed
--> Processing Dependency: perl-DBI for package: mysql-server-5.1.71-1.el6.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.71-1.el6.x86_64
--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.71-1.el6.x86_64
--> Running transaction check
---> Package libtool-ltdl.x86_64 0:2.2.6-15.5.el6 will be installed
---> Package openssl-devel.x86_64 0:1.0.1e-16.el6_5.1 will be installed
--> Processing Dependency: openssl = 1.0.1e-16.el6_5.1 for package: openssl-devel-1.0.1e-16.el6_5.1.x86_64
--> Processing Dependency: zlib-devel for package: openssl-devel-1.0.1e-16.el6_5.1.x86_64
--> Processing Dependency: krb5-devel for package: openssl-devel-1.0.1e-16.el6_5.1.x86_64
---> Package perl.x86_64 4:5.10.1-136.el6 will be installed
--> Processing Dependency: perl-libs = 4:5.10.1-136.el6 for package: 4:perl-5.10.1-136.el6.x86_64
--> Processing Dependency: perl-libs for package: 4:perl-5.10.1-136.el6.x86_64
--> Processing Dependency: perl(version) for package: 4:perl-5.10.1-136.el6.x86_64
--> Processing Dependency: perl(Pod::Simple) for package: 4:perl-5.10.1-136.el6.x86_64
--> Processing Dependency: perl(Module::Pluggable) for package: 4:perl-5.10.1-136.el6.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.10.1-136.el6.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
---> Package unixODBC.x86_64 0:2.2.14-12.el6_3 will be installed
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.10.3-10.el6_4.6 will be installed
--> Processing Dependency: libselinux-devel for package: krb5-devel-1.10.3-10.el6_4.6.x86_64
--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.10.3-10.el6_4.6.x86_64
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.10.3-10.el6_4.6.x86_64
---> Package openssl.x86_64 0:1.0.1e-15.el6 will be updated
---> Package openssl.x86_64 0:1.0.1e-16.el6_5.1 will be an update
---> Package perl-Module-Pluggable.x86_64 1:3.90-136.el6 will be installed
---> Package perl-Pod-Simple.x86_64 1:3.13-136.el6 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.13-136.el6.x86_64
---> Package perl-libs.x86_64 4:5.10.1-136.el6 will be installed
---> Package perl-version.x86_64 3:0.77-136.el6 will be installed
---> Package zlib-devel.x86_64 0:1.2.3-29.el6 will be installed
--> Running transaction check
---> Package keyutils-libs-devel.x86_64 0:1.4-4.el6 will be installed
---> Package libcom_err-devel.x86_64 0:1.41.12-18.el6 will be installed
---> Package libselinux-devel.x86_64 0:2.0.94-5.3.el6_4.1 will be installed
--> Processing Dependency: libsepol-devel >= 2.0.32-1 for package: libselinux-devel-2.0.94-5.3.el6_4.1.x86_64
--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.0.94-5.3.el6_4.1.x86_64
---> Package perl-Pod-Escapes.x86_64 1:1.04-136.el6 will be installed
--> Running transaction check
---> Package libsepol-devel.x86_64 0:2.0.41-4.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================
 Package                 Arch     Version                 Repository
                                                                     Size
==========================================================================
Installing:
 mysql                   x86_64   5.1.71-1.el6            base      893 k
 mysql-connector-odbc    x86_64   5.1.5r1144-7.el6        base      114 k
 mysql-devel             x86_64   5.1.71-1.el6            base      129 k
 mysql-server            x86_64   5.1.71-1.el6            base      8.6 M
Installing for dependencies:
 keyutils-libs-devel     x86_64   1.4-4.el6               base       28 k
 krb5-devel              x86_64   1.10.3-10.el6_4.6       base      495 k
 libcom_err-devel        x86_64   1.41.12-18.el6          base       32 k
 libselinux-devel        x86_64   2.0.94-5.3.el6_4.1      base      136 k
 libsepol-devel          x86_64   2.0.41-4.el6            base       64 k
 libtool-ltdl            x86_64   2.2.6-15.5.el6          base       44 k
 openssl-devel           x86_64   1.0.1e-16.el6_5.1       updates   1.2 M
 perl                    x86_64   4:5.10.1-136.el6        base       10 M
 perl-DBD-MySQL          x86_64   4.013-3.el6             base      134 k
 perl-DBI                x86_64   1.609-4.el6             base      705 k
 perl-Module-Pluggable   x86_64   1:3.90-136.el6          base       40 k
 perl-Pod-Escapes        x86_64   1:1.04-136.el6          base       32 k
 perl-Pod-Simple         x86_64   1:3.13-136.el6          base      212 k
 perl-libs               x86_64   4:5.10.1-136.el6        base      578 k
 perl-version            x86_64   3:0.77-136.el6          base       51 k
 unixODBC                x86_64   2.2.14-12.el6_3         base      378 k
 zlib-devel              x86_64   1.2.3-29.el6            base       44 k
Updating for dependencies:
 openssl                 x86_64   1.0.1e-16.el6_5.1       updates   1.5 M

Transaction Summary
==========================================================================
Install      21 Package(s)
Upgrade       1 Package(s)

Total download size: 25 M
Downloading Packages:
(1/22): keyutils-libs-devel-1.4-4.el6.x86_64.rpm   |  28 kB     00:00    
(2/22): krb5-devel-1.10.3-10.el6_4.6.x86_64.rpm    | 495 kB     00:00    
(3/22): libcom_err-devel-1.41.12-18.el6.x86_64.rpm |  32 kB     00:00    
(4/22): libselinux-devel-2.0.94-5.3.el6_4.1.x86_64 | 136 kB     00:00    
(5/22): libsepol-devel-2.0.41-4.el6.x86_64.rpm     |  64 kB     00:00    
(6/22): libtool-ltdl-2.2.6-15.5.el6.x86_64.rpm     |  44 kB     00:00    
(7/22): mysql-5.1.71-1.el6.x86_64.rpm              | 893 kB     00:00    
(8/22): mysql-connector-odbc-5.1.5r1144-7.el6.x86_ | 114 kB     00:00    
(9/22): mysql-devel-5.1.71-1.el6.x86_64.rpm        | 129 kB     00:00    
(10/22): mysql-server-5.1.71-1.el6.x86_64.rpm      | 8.6 MB     00:01    
(11/22): openssl-1.0.1e-16.el6_5.1.x86_64.rpm      | 1.5 MB     00:00    
(12/22): openssl-devel-1.0.1e-16.el6_5.1.x86_64.rp | 1.2 MB     00:00    
(13/22): perl-5.10.1-136.el6.x86_64.rpm            |  10 MB     00:01    
(14/22): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm     | 134 kB     00:00    
(15/22): perl-DBI-1.609-4.el6.x86_64.rpm           | 705 kB     00:00    
(16/22): perl-Module-Pluggable-3.90-136.el6.x86_64 |  40 kB     00:00    
(17/22): perl-Pod-Escapes-1.04-136.el6.x86_64.rpm  |  32 kB     00:00    
(18/22): perl-Pod-Simple-3.13-136.el6.x86_64.rpm   | 212 kB     00:00    
(19/22): perl-libs-5.10.1-136.el6.x86_64.rpm       | 578 kB     00:00    
(20/22): perl-version-0.77-136.el6.x86_64.rpm      |  51 kB     00:00    
(21/22): unixODBC-2.2.14-12.el6_3.x86_64.rpm       | 378 kB     00:00    
(22/22): zlib-devel-1.2.3-29.el6.x86_64.rpm        |  44 kB     00:00    
--------------------------------------------------------------------------
Total                                     4.1 MB/s |  25 MB     00:06    
寃쎄퀬: rpmts_HdrFromFdno: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Importing GPG key 0xC105B9DE:
 Userid : CentOS-6 Key (CentOS 6 Official Signing Key) <centos-6-key@centos.org>
 Package: centos-release-6-5.el6.centos.11.1.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : openssl-1.0.1e-16.el6_5.1.x86_64                      1/23
  Installing : libtool-ltdl-2.2.6-15.5.el6.x86_64                    2/23
  Installing : unixODBC-2.2.14-12.el6_3.x86_64                       3/23
  Installing : 1:perl-Pod-Escapes-1.04-136.el6.x86_64                4/23
  Installing : 3:perl-version-0.77-136.el6.x86_64                    5/23
  Installing : 1:perl-Pod-Simple-3.13-136.el6.x86_64                 6/23
  Installing : 4:perl-libs-5.10.1-136.el6.x86_64                     7/23
  Installing : 1:perl-Module-Pluggable-3.90-136.el6.x86_64           8/23
  Installing : 4:perl-5.10.1-136.el6.x86_64                          9/23
  Installing : perl-DBI-1.609-4.el6.x86_64                          10/23
  Installing : mysql-5.1.71-1.el6.x86_64                            11/23
  Installing : perl-DBD-MySQL-4.013-3.el6.x86_64                    12/23
  Installing : libsepol-devel-2.0.41-4.el6.x86_64                   13/23
  Installing : libselinux-devel-2.0.94-5.3.el6_4.1.x86_64           14/23
  Installing : libcom_err-devel-1.41.12-18.el6.x86_64               15/23
  Installing : zlib-devel-1.2.3-29.el6.x86_64                       16/23
  Installing : keyutils-libs-devel-1.4-4.el6.x86_64                 17/23
  Installing : krb5-devel-1.10.3-10.el6_4.6.x86_64                  18/23
  Installing : openssl-devel-1.0.1e-16.el6_5.1.x86_64               19/23
  Installing : mysql-devel-5.1.71-1.el6.x86_64                      20/23
  Installing : mysql-server-5.1.71-1.el6.x86_64                     21/23
  Installing : mysql-connector-odbc-5.1.5r1144-7.el6.x86_64         22/23
  Cleanup    : openssl-1.0.1e-15.el6.x86_64                         23/23
  Verifying  : 1:perl-Module-Pluggable-3.90-136.el6.x86_64           1/23
  Verifying  : perl-DBD-MySQL-4.013-3.el6.x86_64                     2/23
  Verifying  : libselinux-devel-2.0.94-5.3.el6_4.1.x86_64            3/23
  Verifying  : 4:perl-5.10.1-136.el6.x86_64                          4/23
  Verifying  : perl-DBI-1.609-4.el6.x86_64                           5/23
  Verifying  : openssl-devel-1.0.1e-16.el6_5.1.x86_64                6/23
  Verifying  : mysql-server-5.1.71-1.el6.x86_64                      7/23
  Verifying  : mysql-5.1.71-1.el6.x86_64                             8/23
  Verifying  : openssl-1.0.1e-16.el6_5.1.x86_64                      9/23
  Verifying  : keyutils-libs-devel-1.4-4.el6.x86_64                 10/23
  Verifying  : 1:perl-Pod-Simple-3.13-136.el6.x86_64                11/23
  Verifying  : unixODBC-2.2.14-12.el6_3.x86_64                      12/23
  Verifying  : zlib-devel-1.2.3-29.el6.x86_64                       13/23
  Verifying  : mysql-devel-5.1.71-1.el6.x86_64                      14/23
  Verifying  : libtool-ltdl-2.2.6-15.5.el6.x86_64                   15/23
  Verifying  : 3:perl-version-0.77-136.el6.x86_64                   16/23
  Verifying  : libcom_err-devel-1.41.12-18.el6.x86_64               17/23
  Verifying  : libsepol-devel-2.0.41-4.el6.x86_64                   18/23
  Verifying  : 1:perl-Pod-Escapes-1.04-136.el6.x86_64               19/23
  Verifying  : 4:perl-libs-5.10.1-136.el6.x86_64                    20/23
  Verifying  : mysql-connector-odbc-5.1.5r1144-7.el6.x86_64         21/23
  Verifying  : krb5-devel-1.10.3-10.el6_4.6.x86_64                  22/23
  Verifying  : openssl-1.0.1e-15.el6.x86_64                         23/23

Installed:
  mysql.x86_64 0:5.1.71-1.el6                                            
  mysql-connector-odbc.x86_64 0:5.1.5r1144-7.el6                         
  mysql-devel.x86_64 0:5.1.71-1.el6                                      
  mysql-server.x86_64 0:5.1.71-1.el6                                     

Dependency Installed:
  keyutils-libs-devel.x86_64 0:1.4-4.el6                                 
  krb5-devel.x86_64 0:1.10.3-10.el6_4.6                                  
  libcom_err-devel.x86_64 0:1.41.12-18.el6                               
  libselinux-devel.x86_64 0:2.0.94-5.3.el6_4.1                           
  libsepol-devel.x86_64 0:2.0.41-4.el6                                   
  libtool-ltdl.x86_64 0:2.2.6-15.5.el6                                   
  openssl-devel.x86_64 0:1.0.1e-16.el6_5.1                               
  perl.x86_64 4:5.10.1-136.el6                                           
  perl-DBD-MySQL.x86_64 0:4.013-3.el6                                    
  perl-DBI.x86_64 0:1.609-4.el6                                          
  perl-Module-Pluggable.x86_64 1:3.90-136.el6                            
  perl-Pod-Escapes.x86_64 1:1.04-136.el6                                 
  perl-Pod-Simple.x86_64 1:3.13-136.el6                                  
  perl-libs.x86_64 4:5.10.1-136.el6                                      
  perl-version.x86_64 3:0.77-136.el6                                     
  unixODBC.x86_64 0:2.2.14-12.el6_3                                      
  zlib-devel.x86_64 0:1.2.3-29.el6                                       

Dependency Updated:
  openssl.x86_64 0:1.0.1e-16.el6_5.1                                     

Complete!

 

설치 및 관련 패키지 업데이트 까지 했다고 뜨네요..

제대로 설치 되었는지 다시 한번 확인해보겠습니다

 

[root@linux ~]# rpm -qa | grep mysql
mysql-libs-5.1.71-1.el6.x86_64
mysql-devel-5.1.71-1.el6.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-5.1.71-1.el6.x86_64
mysql-server-5.1.71-1.el6.x86_64

 

앞에서 설치하고자 했던 패키지가 설치되었습니다.

 

[root@linux ~]# ls /etc/my*
/etc/my.cnf

[root@linux ~]# vi /etc/my.cnf

 

[mysqld]

## from /usr/share/mysql/my-huge.cnf

port = 3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

## from /usr/share/mysql/my-huge.cnf

## 자신의 시스템에 맞게 설정 혹은 주석(#)처리

#skip-locking
#key_buffer = 384M
#max_allowed_packet = 1M
#table_cache = 512
#sort_buffer_size = 2M
#read_buffer_size = 2M
#read_rnd_buffer_size = 8M
#myisam_sort_buffer_size = 64M
#thread_cache_size = 8
#query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
#thread_concurrency = 8

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

##character set -> utf8

init_connect=SET collation_connection = utf8_general_ci
init_connect=SET NAMES utf8
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
character-set-client-handshake=FALSE


 

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

 

[mysql.server]
user=mysql
basedir=/var/lib
default-character-set=utf8

 

[mysqldump]
default-character-set=utf8

[mysql]
default-character-set=utf8

 

* esc키 누른 후 :wq 입력하여 저장


 

*mysql 유저 퍼미션 설정

[root@linux ~]# chown -R mysql:mysql /var/lib/mysql/

 

 

*mysql DB생성

[root@linux ~]# mysql_install_db
WARNING: The host 'linux.pc' 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 linux.pc 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!

 

mysql 데몬 시작 방법 ( 다음 두가지 중 하나)

 

1.

 

[root@linux ~]# /etc/rc.d/init.d/mysqld start

mysqld (을)를 시작 중:                                     [  OK  ]

 

 2.

 

[root@linux ~]# /usr/bin/mysqld_safe &
[1] 1450
[root@linux ~]# 140107 07:57:30 mysqld_safe Logging to '/var/log/mysqld.log'.
140107 07:57:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

*mysql root 패스워드 설정


 

[root@linux ~]# mysqladmin -u root password '여기에비밀번호입력'
[root@linux ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like 'c%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
| collation_connection     | utf8_general_ci            |
| collation_database       | utf8_general_ci            |
| collation_server         | utf8_general_ci            |
| completion_type          | 0                          |
| concurrent_insert        | 1                          |
| connect_timeout          | 10                         |
+--------------------------+----------------------------+
14 rows in set (0.00 sec)

mysql>

mysql> quit
Bye
[root@linux ~]#

 

 

 

 

 

mysql DataBase 를 생성하고 데몬을 실행 후 실행상태를 확인하고 데이터베이스에 접속까지 해봤습니다.

설치과정을 거의 다 보여드리려니 막상 명령어 몇개 치지도 않았는데 내용만 많아지네요 ;;;

지금까지 mysql 설치를 끝냈고 서버설정등을 해야하는데 정식 서버가 아니기때문에

생략하기로 하고 차후 실전서버를 셋팅할 기회가 되면 좀 더 자세히 ;;;

 

여기서 끊고 다음엔 apach 와  php를 마저 설치해보겠습니다.

728x90
반응형