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

잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight))
 
(사용자 2명의 중간 판 20개는 보이지 않습니다)
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@jmnote02:~# 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 libmysqlclient18 libnet-daemon-perl
   libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
   libplrpc-perl mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5
   mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5
   mysql-server-core-5.5
   mysql-server-core-5.5 perl perl-base perl-modules
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 libmysqlclient18 libnet-daemon-perl
   libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
   libplrpc-perl mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server
   mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server
   mysql-server-5.5 mysql-server-core-5.5
   mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 12 newly installed, 0 to remove and 48 not upgraded.
The following packages will be upgraded:
Need to get 27.3 MB of archives.
  perl perl-base perl-modules
After this operation, 97.5 MB of additional disk space will be used.
3 upgraded, 11 newly installed, 0 to remove and 142 not upgraded.
Do you want to continue [Y/n]? Y
Need to get 16.2 MB of archives.
</source>
After this operation, 97.1 MB of additional disk space will be used.
<source lang='cli'>
Do you want to continue? [Y/n]
</syntaxhighlight>
<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'>
... (생략)
... (생략)
141213  1:24:27 [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 30674
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@jmnote02:~# 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@jmnote02:~# 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      30674/mysqld
affiliates. Other names may be trademarks of their respective
</source>
owners.
<source lang='cli'>
 
root@jmnote02:~# 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          |
60번째 줄: 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 }}