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>