메뉴 건너뛰기

Cloudera, BigData, Semantic IoT, Hadoop, NoSQL

Cloudera CDH/CDP 및 Hadoop EcoSystem, Semantic IoT등의 개발/운영 기술을 정리합니다. gooper@gooper.com로 문의 주세요.



1. mysql설치

root@master:/usr/local# apt-get install mysql-server

(404오류가발생시 https://www.gooper.com/ss/index.php?mid=bigdata&category=2772&document_srl=2995를 참조하여 조치후 설치한다)


Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libc-dev-bin libc6 libc6-dev libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl libnih-dbus1 libnih1 libplrpc-perl libterm-readkey-perl mysql-client-5.5
mysql-client-core-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
glibc-doc tinyca mailx
Recommended packages:
manpages-dev libhtml-template-perl
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server
mysql-server-5.5 mysql-server-core-5.5
The following packages will be upgraded:
libc-dev-bin libc6 libc6-dev libnih-dbus1 libnih1
5 upgraded, 12 newly installed, 0 to remove and 537 not upgraded.
1 not fully installed or removed.
Need to get 31.1 MB/31.2 MB of archives.
After this operation, 84.8 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
WARNING: The following packages cannot be authenticated!
libnih-dbus1 libnih1 libc6-dev libc-dev-bin libc6 mysql-common libmysqlclient18 libnet-daemon-perl libplrpc-perl libdbi-perl libdbd-mysql-perl mysql-client-core-5.5
libterm-readkey-perl mysql-client-5.5 mysql-server-core-5.5 mysql-server-5.5 mysql-server
Authentication warning overridden.
Get:1 http://old-releases.ubuntu.com/ubuntu/ raring/main libnih-dbus1 armhf 1.0.3-4ubuntu16 [15.1 kB]
Get:2 http://old-releases.ubuntu.com/ubuntu/ raring/main libnih1 armhf 1.0.3-4ubuntu16 [51.2 kB]
Get:3 http://old-releases.ubuntu.com/ubuntu/ raring-security/main libc6-dev armhf 2.17-0ubuntu5.1 [2216 kB]
Get:4 http://old-releases.ubuntu.com/ubuntu/ raring-security/main libc-dev-bin armhf 2.17-0ubuntu5.1 [69.0 kB]
Get:5 http://old-releases.ubuntu.com/ubuntu/ raring-security/main libc6 armhf 2.17-0ubuntu5.1 [3894 kB]
Get:6 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-common all 5.5.34-0ubuntu0.13.04.1 [13.3 kB]
Get:7 http://old-releases.ubuntu.com/ubuntu/ raring-security/main libmysqlclient18 armhf 5.5.34-0ubuntu0.13.04.1 [858 kB]
Get:8 http://old-releases.ubuntu.com/ubuntu/ raring/main libdbi-perl armhf 1.622-1 [846 kB]
Get:9 http://old-releases.ubuntu.com/ubuntu/ raring/main libdbd-mysql-perl armhf 4.021-1 [91.4 kB]
Get:10 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-client-core-5.5 armhf 5.5.34-0ubuntu0.13.04.1 [1740 kB]
Get:11 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-client-5.5 armhf 5.5.34-0ubuntu0.13.04.1 [7649 kB]
Get:12 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-server-core-5.5 armhf 5.5.34-0ubuntu0.13.04.1 [5370 kB]
Get:13 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-server-5.5 armhf 5.5.34-0ubuntu0.13.04.1 [8321 kB]
Get:14 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-server all 5.5.34-0ubuntu0.13.04.1 [11.5 kB]
Fetched 31.1 MB in 1min 9s (448 kB/s)
Preconfiguring packages ...

Package configuration


+-----------------------------------------+ Configuring mysql-server-5.5 +-----------------------------------------+
| While not mandatory, it is highly recommended that you set a password for the MySQL administrative "root" user. |
| |
| If this field is left blank, the password will not be changed. |
| |
| New password for the MySQL "root" user: |
| |
| ****_________________________________________________________________________________ |
| |
| <Ok> |
| |
+------------------------------------------------------------------------------------------------------------------+


+------+ Configuring mysql-server-5.5 +-------+
| |
| |
| Repeat password for the MySQL "root" user: |
| |
| ___________________________________________ |
| |
| <Ok> |
| |
+---------------------------------------------+

(Reading database ... 59905 files and directories currently installed.)
Preparing to replace libnih-dbus1:armhf 1.0.3-4ubuntu11 (using .../libnih-dbus1_1.0.3-4ubuntu16_armhf.deb) ...
Unpacking replacement libnih-dbus1:armhf ...
Preparing to replace libnih1:armhf 1.0.3-4ubuntu11 (using .../libnih1_1.0.3-4ubuntu16_armhf.deb) ...
Unpacking replacement libnih1:armhf ...
Preparing to replace libc6-dev:armhf 2.15-0ubuntu20 (using .../libc6-dev_2.17-0ubuntu5.1_armhf.deb) ...
Unpacking replacement libc6-dev:armhf ...
Preparing to replace libc-dev-bin 2.15-0ubuntu20 (using .../libc-dev-bin_2.17-0ubuntu5.1_armhf.deb) ...
Unpacking replacement libc-dev-bin ...
Preparing to replace libc6:armhf 2.15-0ubuntu20 (using .../libc6_2.17-0ubuntu5.1_armhf.deb) ...

-------------------------------------------

Package configuration


+-------------------------------------------------------------------------+ Configuring libc6 +-------------------------------------------------------------------------+
| |
| xscreensaver and xlockmore must be restarted before upgrading |
| |
| One or more running instances of xscreensaver or xlockmore have been detected on this system. Because of incompatible library changes, the upgrade of the GNU libc |
| library will leave you unable to authenticate to these programs. You should arrange for these programs to be restarted or stopped before continuing this upgrade, to |
| avoid locking your users out of their current sessions. |
| |
| <Ok> |
| |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------+ Configuring libc6 +-------------------------------------------------------------------------+
| |
| There are services installed on your system which need to be restarted when certain libraries, such as libpam, libc, and libssl, are upgraded. Since these restarts |
| may cause interruptions of service for the system, you will normally be prompted on each upgrade for the list of services you wish to restart. You can choose this |
| option to avoid being prompted; instead, all necessary restarts will be done for you automatically so you can avoid being asked questions on each library upgrade. |
| |
| Restart services during package upgrades without asking? |
| |
| <Yes> <No> |
| |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------+ Configuring libc6 +-------------------------------------------------------------------------+
| Running services and programs that are using NSS need to be restarted, otherwise they might not be able to do lookup or authentication any more (for services such |
| as ssh, this can affect your ability to login). Please review the following space-separated list of init.d scripts for services to be restarted now, and correct it |
| if needed. |
| |
| Note: restarting sshd/telnetd should not affect any existing connections. |
| |
| Services to restart for GNU libc library upgrade: |
| |
| cron_________________________________________________________________________________________________________________________________________________________________ |
| |
| <Ok> |
| |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Stopping some services possibly affected by the upgrade (will be restarted later):
cron: stopping...done.

Unpacking replacement libc6:armhf ...
Processing triggers for man-db ...
Setting up libc6:armhf (2.17-0ubuntu5.1) ...
Generating locales...
ko_KR.EUC-KR... done
Generation complete.
Checking for services that may need to be restarted...
Checking init scripts...
Restarting services possibly affected by the upgrade:
cron: restarting...done.

Services restarted successfully.
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
Selecting previously unselected package mysql-common.
(Reading database ... 59918 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.5.34-0ubuntu0.13.04.1_all.deb) ...
Selecting previously unselected package libmysqlclient18:armhf.
Unpacking libmysqlclient18:armhf (from .../libmysqlclient18_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Selecting previously unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...
Selecting previously unselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.622-1_armhf.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1_armhf.deb) ...
Selecting previously unselected package mysql-client-core-5.5.
Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Selecting previously unselected package libterm-readkey-perl.
Unpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.30-4build4_armhf.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.34-0ubuntu0.13.04.1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 60296 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.34-0ubuntu0.13.04.1_all.deb) ...
Processing triggers for ureadahead ...
Processing triggers for man-db ...
Setting up libaio1:armhf (0.3.109-2ubuntu1) ...
Setting up libnih1:armhf (1.0.3-4ubuntu16) ...
Setting up libnih-dbus1:armhf (1.0.3-4ubuntu16) ...
Setting up libc-dev-bin (2.17-0ubuntu5.1) ...
Setting up libc6-dev:armhf (2.17-0ubuntu5.1) ...
Setting up libmysqlclient18:armhf (5.5.34-0ubuntu0.13.04.1) ...
Setting up libnet-daemon-perl (0.48-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.622-1) ...
Setting up libdbd-mysql-perl (4.021-1) ...
Setting up mysql-client-core-5.5 (5.5.34-0ubuntu0.13.04.1) ...
Setting up libterm-readkey-perl (2.30-4build4) ...
Setting up mysql-client-5.5 (5.5.34-0ubuntu0.13.04.1) ...
Setting up mysql-server-core-5.5 (5.5.34-0ubuntu0.13.04.1) ...
Setting up mysql-server-5.5 (5.5.34-0ubuntu0.13.04.1) ...
190519 12:11:16 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
mysql start/running, process 14399
Processing triggers for ureadahead ...
Setting up mysql-server (5.5.34-0ubuntu0.13.04.1) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
localepurge: Disk space freed in /usr/share/locale: 0 KiB
localepurge: Disk space freed in /usr/share/man: 0 KiB
localepurge: Disk space freed in /usr/share/gnome/help: 0 KiB
localepurge: Disk space freed in /usr/share/omf: 0 KiB

Total disk space freed by localepurge: 0 KiB



2. reboot후 확인

hadoop@master:~$ mysql

Welcome to the MySQL monitor.  Commands end with ; or g.

Your MySQL connection id is 36

Server version: 5.5.34-0ubuntu0.13.04.1 (Ubuntu)


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 databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| test               |

+--------------------+

2 rows in set (0.01 sec)


mysql> 

번호 제목 날짜 조회 수
101 로그 파일에 대해 Elasticsearch 사용하기 2014.09.25 1516
100 호튼웍스 하둡을 검색엔진과 연동하는 방법과 아키텍쳐 2014.09.25 1282
99 hadoop 기반 문서 검색 2014.09.25 1122
98 하둡 분산 파일 시스템을 기반으로 색인하고 검색하기 2014.09.25 1061
97 lateral view 예제 2014.09.18 843
96 root가 localhost에서 mysql로 접근하지 못하는 경우의 해결방법(패스워드) 2014.09.10 747
» mysql 5.5.34-0ubuntu0.13.04용 설치/진행 화면 2014.09.10 1211
94 apt-get install mysql-server수행시 "404 Not Found" 오류발생시 조치방법 2014.09.10 1579
93 banana pi에 hive 0.13.1+mysql(metastore)설치 file 2014.09.09 2545
92 원격지에서 zio공유기를 통해서 노트북의 mysql접속을 허용하는 방법 2014.09.07 1036
91 sqoop작업시 hdfs의 개수보다 더많은 값이 중복되어 oracle에 입력되는 경우가 있음 2014.09.02 4288
90 java.util.NoSuchElementException발생시 조치 2014.08.27 1426
89 hadoop의 data디렉토리를 변경하는 방법 2014.08.24 1118
88 시스템날짜를 현재 정보로 동기화 하는 방법(rdate, ntpdate이용) 2014.08.24 1140
87 FAILED: IllegalStateException Variable substitution depth too large: 40 오류발생시 조치사항 2014.08.19 1653
86 원보드 컴퓨터 비교표 file 2014.08.04 899
85 외부 기기(usb, 하드)등 mount(연결)하기 2014.08.03 661
84 데이타 제공 사이트 링크 2014.08.03 636
83 lubuntu 호스트 네임변경 2014.08.03 1008
82 oozie 에서 sqoop action실행 에러 - 컬럼개수 차이 2014.07.17 1143
위로