편집을 취소할 수 있습니다. 이 편집을 되돌리려면 아래의 바뀐 내용을 확인한 후 게시해주세요.
| 최신판 | 당신의 편집 | ||
| 1번째 줄: | 1번째 줄: | ||
{{테스트|우분투 12.04 LTS}} | |||
{{테스트|우분투 12 | |||
;우분투 MySQL 설치 | ;우분투 MySQL 설치 | ||
;우분투 MySQL 서버 설치 | ;우분투 MySQL 서버 설치 | ||
==확인== | ==확인== | ||
< | <source lang='cli'> | ||
root@zetawiki:~# | root@zetawiki:~# /etc/init.d/mysql | ||
-bash: /etc/init.d/mysql: No such file or directory | |||
</ | </source> | ||
< | <source lang='cli'> | ||
root@zetawiki:~# dpkg -l | grep mysql | root@zetawiki:~# dpkg -l | grep mysql | ||
root@zetawiki:~# aptitude show mysql-server | grep ^State | root@zetawiki:~# aptitude show mysql-server | grep ^State | ||
State: not installed | State: not installed | ||
</ | </source> | ||
==설치== | ==설치== | ||
< | <source lang='cli'> | ||
root@zetawiki:~# apt-get install mysql-server | root@zetawiki:~# apt-get install mysql-server | ||
Reading package lists... Done | Reading package lists... Done | ||
| 25번째 줄: | 23번째 줄: | ||
libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 | 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-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5 | ||
mysql-server-core-5.5 | mysql-server-core-5.5 | ||
Suggested packages: | Suggested packages: | ||
libclone-perl libmldbm-perl libnet-daemon-perl libplrpc-perl | libclone-perl libmldbm-perl libnet-daemon-perl libplrpc-perl | ||
libsql-statement-perl libipc-sharedcache-perl tinyca mailx | libsql-statement-perl libipc-sharedcache-perl tinyca mailx | ||
The following NEW packages will be installed: | The following NEW packages will be installed: | ||
libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 | libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 | ||
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, 11 newly installed, 0 to remove and 31 not upgraded. | |||
Need to get 9,302 kB of archives. | |||
After this operation, 96.6 MB of additional disk space will be used. | |||
Need to get | Do you want to continue? [Y/n] | ||
After this operation, | </source> | ||
Do you want to continue? [Y/n] | <source lang='cli'> | ||
</ | |||
< | |||
... (생략) | ... (생략) | ||
New password for the MySQL "root" user: | |||
</source> | |||
</ | |||
:→ MySQL의 root 계정 패스워드 지정 | :→ MySQL의 root 계정 패스워드 지정 | ||
< | <source lang='cli'> | ||
Repeat password for the MySQL "root" user: | |||
</source> | |||
</ | |||
:→ MySQL의 root 계정 패스워드 재입력 | :→ MySQL의 root 계정 패스워드 재입력 | ||
< | <source lang='cli'> | ||
... (생략) | ... (생략) | ||
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 [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. | 160315 17:44:19 [Note] /usr/sbin/mysqld (mysqld 5.5.47-0ubuntu0.14.04.1) starting as process 4054 ... | ||
mysql start/running, process | mysql start/running, process 4217 | ||
Setting up libhtml-template-perl (2.95-1) ... | Setting up libhtml-template-perl (2.95-1) ... | ||
Processing triggers for ureadahead (0.100.0-16) ... | Processing triggers for ureadahead (0.100.0-16) ... | ||
Setting up mysql-server (5.5. | Setting up mysql-server (5.5.47-0ubuntu0.14.04.1) ... | ||
Processing triggers for libc-bin (2.19-0ubuntu6.6) ... | Processing triggers for libc-bin (2.19-0ubuntu6.6) ... | ||
</ | </source> | ||
==확인== | ==확인== | ||
< | <source lang='cli'> | ||
root@zetawiki:~# /etc/init.d/mysql status | root@zetawiki:~# /etc/init.d/mysql status | ||
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.5. | * /usr/bin/mysqladmin Ver 8.42 Distrib 5.5.47, for debian-linux-gnu on x86_64 | ||
Copyright (c) 2000, | Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. | ||
Oracle is a registered trademark of Oracle Corporation and/or its | Oracle is a registered trademark of Oracle Corporation and/or its | ||
| 98번째 줄: | 66번째 줄: | ||
owners. | owners. | ||
Server version 5.5. | Server version 5.5.47-0ubuntu0.14.04.1 | ||
Protocol version 10 | Protocol version 10 | ||
Connection Localhost via UNIX socket | Connection Localhost via UNIX socket | ||
UNIX socket /var/run/mysqld/mysqld.sock | UNIX socket /var/run/mysqld/mysqld.sock | ||
Uptime: | Uptime: 1 min 55 sec | ||
Threads: 1 Questions: | Threads: 1 Questions: 584 Slow queries: 0 Opens: 189 Flush tables: 1 Open tables: 41 Queries per second avg: 5.078 | ||
</ | </source> | ||
< | <source lang='cli'> | ||
root@zetawiki:~# netstat -ntlp | grep mysqld | root@zetawiki:~# netstat -ntlp | grep mysqld | ||
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN | tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 4217/mysqld | ||
</ | </source> | ||
< | <source lang='cli'> | ||
root@zetawiki:~# mysql -uroot - | root@zetawiki:~# mysql -uroot -pP@ssw0rd -e'show databases' | ||
+--------------------+ | +--------------------+ | ||
| Database | | | Database | | ||
| 120번째 줄: | 87번째 줄: | ||
| performance_schema | | | performance_schema | | ||
+--------------------+ | +--------------------+ | ||
</ | </source> | ||
==같이 보기== | ==같이 보기== | ||
*[[우분투 아파치 설치]] | |||
* [[우분투 아파치 | *[[CentOS MySQL 설치]] | ||
* [[CentOS MySQL | |||
[[분류: apt-get]] | [[분류: apt-get]] | ||