자 이젠 본격적으로 APM(apache + php + mysql)을 설치해보겠습니다.
우선 기본만 설치된 리눅스 서버이니까 필요한 패키지가 설치되어있는지 확인해봐야겠습니다.
[root@linux ~]# rpm -qa | grep mysql*
mysql-libs-5.1.71-1.el6.x86_64
mysql 관련으로 설치된 패키지는 이거뿐이군요 ㅋ
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를 마저 설치해보겠습니다.