"우분투 MySQL 설치"의 두 판 사이의 차이

잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight))
 
(사용자 2명의 중간 판 21개는 보이지 않습니다)
1번째 줄: 1번째 줄:
{{테스트|우분투 12.04 LTS}}
{{다른뜻|우분투 MySQL 클라이언트 설치}}
{{다른뜻|CentOS MySQL 서버 설치}}
{{테스트|우분투 12, 우분투 14}}
;우분투 MySQL 설치
;우분투 MySQL 설치
;우분투 MySQL 서버 설치
;우분투 MySQL 서버 설치
==확인==
<syntaxhighlight lang='console'>
root@zetawiki:~# cat /etc/init.d/mysql
cat: /etc/init.d/mysql: No such file or directory
</syntaxhighlight>
<syntaxhighlight lang='console'>
root@zetawiki:~# dpkg -l | grep mysql-server
root@zetawiki:~# aptitude show mysql-server | grep ^State
State: not installed
</syntaxhighlight>
==설치==
==설치==
<source lang='cli'>
<syntaxhighlight lang='console'>
root@ubuntu:~# apt-get install mysql-server
root@zetawiki:~# apt-get install mysql-server
Reading package lists... Done
Reading package lists... Done
Building dependency tree       
Building dependency tree       
Reading state information... Done
Reading state information... Done
The following extra packages will be installed:
The following extra packages will be installed:
   libdbd-mysql-perl libdbi-perl libhtml-template-perl
   libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
  libmysqlclient18 libnet-daemon-perl libplrpc-perl
   mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5
   libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5
  mysql-server-core-5.5 perl perl-base perl-modules
  mysql-common mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
Suggested packages:
   libipc-sharedcache-perl tinyca mailx
   libclone-perl libmldbm-perl libnet-daemon-perl libplrpc-perl
  libsql-statement-perl libipc-sharedcache-perl tinyca mailx perl-doc
  libterm-readline-gnu-perl libterm-readline-perl-perl make libb-lint-perl
  libcpanplus-dist-build-perl libcpanplus-perl libfile-checktree-perl
  liblog-message-perl libobject-accessor-perl
The following NEW packages will be installed:
The following NEW packages will be installed:
   libdbd-mysql-perl libdbi-perl libhtml-template-perl
   libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
  libmysqlclient18 libnet-daemon-perl libplrpc-perl
   mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server
   libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5
  mysql-server-5.5 mysql-server-core-5.5
  mysql-common mysql-server mysql-server-5.5
The following packages will be upgraded:
  mysql-server-core-5.5
  perl perl-base perl-modules
0 upgraded, 13 newly installed, 0 to remove and 37 not upgraded.
3 upgraded, 11 newly installed, 0 to remove and 142 not upgraded.
Need to get 27.3 MB of archives.
Need to get 16.2 MB of archives.
After this operation, 97.6 MB of additional disk space will be used.
After this operation, 97.1 MB of additional disk space will be used.
Do you want to continue [Y/n]?
Do you want to continue? [Y/n]
</source>
</syntaxhighlight>
<source lang='cli'>
<syntaxhighlight lang='console'>
... (생략)
... (생략)
New password for the MySQL "root" user:
</syntaxhighlight>
</source>
<syntaxhighlight lang='text'>
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>                                    │ 
  │                                                                        │ 
  └─────────────────-───────────────────┘ 
</syntaxhighlight>
:→ MySQL의 root 계정 패스워드 지정
:→ MySQL의 root 계정 패스워드 지정
<source lang='cli'>
<syntaxhighlight lang='text'>
Repeat password for the MySQL "root" user:
  ┌───┤ Configuring mysql-server-5.5 ├───┐
</source>
  │                                              │
  │ Repeat password for the MySQL "root" user.  │
  │                                              │
  │                                              │
  │ ********____________________________________ │
  │                                              │
  │                  <Ok>                      │
  │                                              │
  └───────────────────────┘
</syntaxhighlight>
:→ MySQL의 root 계정 패스워드 재입력
:→ MySQL의 root 계정 패스워드 재입력
<source lang='cli'>
<syntaxhighlight lang='console'>
... (생략)
... (생략)
141203  5:34:35 [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.
160315 17:44:19 [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 2029
160315 17:44:19 [Note] /usr/sbin/mysqld (mysqld 5.5.55-0ubuntu0.14.04.1) starting as process 31551 ...
Setting up libhtml-template-perl (2.10-1) ...
mysql start/running, process 31551
Setting up mysql-server (5.5.40-0ubuntu0.12.04.1) ...
Setting up libhtml-template-perl (2.95-1) ...
Processing triggers for libc-bin ...
Processing triggers for ureadahead (0.100.0-16) ...
ldconfig deferred processing now taking place
Setting up mysql-server (5.5.55-0ubuntu0.14.04.1) ...
</source>
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
</syntaxhighlight>


==확인==
==확인==
<source lang='cli'>
<syntaxhighlight lang='console'>
root@ubuntu:~# mysql -V
root@zetawiki:~# /etc/init.d/mysql status
mysql Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.2
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.5.55, for debian-linux-gnu on x86_64
</source>
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
<source lang='cli'>
 
root@ubuntu:~# netstat -ntlp | grep mysqld
Oracle is a registered trademark of Oracle Corporation and/or its
tcp        0      0 127.0.0.1:3306          0.0.0.0:*              LISTEN      2029/mysqld    
affiliates. Other names may be trademarks of their respective
</source>
owners.
<source lang='cli'>
 
root@ubuntu:~# mysql -uroot -pP@ssw0rd -e'show databases'
Server version 5.5.55-0ubuntu0.14.04.1
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 47 sec
 
Threads: 1  Questions: 581  Slow queries: 0  Opens: 189  Flush tables: 1  Open tables: 41  Queries per second avg: 12.361
</syntaxhighlight>
<syntaxhighlight lang='console'>
root@zetawiki:~# netstat -ntlp | grep mysqld
tcp        0      0 127.0.0.1:3306          0.0.0.0:*              LISTEN      31551/mysqld    
</syntaxhighlight>
<syntaxhighlight lang='console'>
root@zetawiki:~# mysql -uroot -p -e'show databases'
Enter password: P@ssw0rd
+--------------------+
+--------------------+
| Database          |
| Database          |
63번째 줄: 120번째 줄:
| performance_schema |
| performance_schema |
+--------------------+
+--------------------+
</source>
</syntaxhighlight>


==같이 보기==
==같이 보기==
*[[우분투 아파치 웹서버 설치]]
* [[MySQL 원격 접속 허용]]
* [[우분투 아파치 설치]]
* [[우분투 MySQL 클라이언트 설치]]
* [[CentOS MySQL 설치]]
* [[우분투 MariaDB 설치]]
* [[우분투 PostgreSQL 설치]]


[[분류: apt-get]]
[[분류: apt-get]]

2020년 11월 2일 (월) 00:56 기준 최신판

  다른 뜻에 대해서는 우분투 MySQL 클라이언트 설치 문서를 참조하십시오.
  다른 뜻에 대해서는 CentOS MySQL 서버 설치 문서를 참조하십시오.
우분투 MySQL 설치
우분투 MySQL 서버 설치

1 확인[ | ]

root@zetawiki:~# cat /etc/init.d/mysql
cat: /etc/init.d/mysql: No such file or directory
root@zetawiki:~# dpkg -l | grep mysql-server
root@zetawiki:~# aptitude show mysql-server | grep ^State
State: not installed

2 설치[ | ]

root@zetawiki:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
  mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5
  mysql-server-core-5.5 perl perl-base perl-modules
Suggested packages:
  libclone-perl libmldbm-perl libnet-daemon-perl libplrpc-perl
  libsql-statement-perl libipc-sharedcache-perl tinyca mailx perl-doc
  libterm-readline-gnu-perl libterm-readline-perl-perl make libb-lint-perl
  libcpanplus-dist-build-perl libcpanplus-perl libfile-checktree-perl
  liblog-message-perl libobject-accessor-perl
The following NEW packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
  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:
  perl perl-base perl-modules
3 upgraded, 11 newly installed, 0 to remove and 142 not upgraded.
Need to get 16.2 MB of archives.
After this operation, 97.1 MB of additional disk space will be used.
Do you want to continue? [Y/n]
... (생략)
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>                                    │   
  │                                                                         │   
  └─────────────────-───────────────────┘
→ MySQL의 root 계정 패스워드 지정
  ┌───┤ Configuring mysql-server-5.5 ├───┐
  │                                              │
  │ Repeat password for the MySQL "root" user.   │
  │                                              │
  │                                              │
  │ ********____________________________________ │
  │                                              │
  │                   <Ok>                       │
  │                                              │
  └───────────────────────┘
→ MySQL의 root 계정 패스워드 재입력
... (생략)
160315 17:44:19 [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.
160315 17:44:19 [Note] /usr/sbin/mysqld (mysqld 5.5.55-0ubuntu0.14.04.1) starting as process 31551 ...
mysql start/running, process 31551
Setting up libhtml-template-perl (2.95-1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up mysql-server (5.5.55-0ubuntu0.14.04.1) ...
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...

3 확인[ | ]

root@zetawiki:~# /etc/init.d/mysql status
 * /usr/bin/mysqladmin  Ver 8.42 Distrib 5.5.55, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2017, 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.

Server version		5.5.55-0ubuntu0.14.04.1
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/run/mysqld/mysqld.sock
Uptime:			47 sec

Threads: 1  Questions: 581  Slow queries: 0  Opens: 189  Flush tables: 1  Open tables: 41  Queries per second avg: 12.361
root@zetawiki:~# netstat -ntlp | grep mysqld
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      31551/mysqld
root@zetawiki:~# mysql -uroot -p -e'show databases'
Enter password: P@ssw0rd
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+

4 같이 보기[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}