편집을 취소할 수 있습니다. 이 편집을 되돌리려면 아래의 바뀐 내용을 확인한 후 게시해주세요.
| 최신판 | 당신의 편집 | ||
| 6번째 줄: | 6번째 줄: | ||
==확인== | ==확인== | ||
< | <source lang='console'> | ||
root@zetawiki:~# cat /etc/init.d/mysql | root@zetawiki:~# cat /etc/init.d/mysql | ||
cat: /etc/init.d/mysql: No such file or directory | cat: /etc/init.d/mysql: No such file or directory | ||
</ | </source> | ||
< | <source lang='console'> | ||
root@zetawiki:~# dpkg -l | grep mysql-server | root@zetawiki:~# dpkg -l | grep mysql-server | ||
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='console'> | ||
root@zetawiki:~# apt-get install mysql-server | root@zetawiki:~# apt-get install mysql-server | ||
Reading package lists... Done | Reading package lists... Done | ||
| 42번째 줄: | 42번째 줄: | ||
After this operation, 97.1 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> | ||
< | <source lang='console'> | ||
... (생략) | ... (생략) | ||
</ | </source> | ||
< | <source lang='text'> | ||
Package configuration | Package configuration | ||
| 62번째 줄: | 62번째 줄: | ||
│ │ | │ │ | ||
└─────────────────-───────────────────┘ | └─────────────────-───────────────────┘ | ||
</ | </source> | ||
:→ MySQL의 root 계정 패스워드 지정 | :→ MySQL의 root 계정 패스워드 지정 | ||
< | <source lang='text'> | ||
┌───┤ Configuring mysql-server-5.5 ├───┐ | ┌───┤ Configuring mysql-server-5.5 ├───┐ | ||
│ │ | │ │ | ||
| 75번째 줄: | 75번째 줄: | ||
│ │ | │ │ | ||
└───────────────────────┘ | └───────────────────────┘ | ||
</ | </source> | ||
:→ MySQL의 root 계정 패스워드 재입력 | :→ MySQL의 root 계정 패스워드 재입력 | ||
< | <source lang='console'> | ||
... (생략) | ... (생략) | ||
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. | ||
| 86번째 줄: | 86번째 줄: | ||
Setting up mysql-server (5.5.55-0ubuntu0.14.04.1) ... | Setting up mysql-server (5.5.55-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='console'> | ||
root@zetawiki:~# /etc/init.d/mysql status | root@zetawiki:~# /etc/init.d/mysql status | ||
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.5.55, for debian-linux-gnu on x86_64 | * /usr/bin/mysqladmin Ver 8.42 Distrib 5.5.55, for debian-linux-gnu on x86_64 | ||
| 105번째 줄: | 105번째 줄: | ||
Threads: 1 Questions: 581 Slow queries: 0 Opens: 189 Flush tables: 1 Open tables: 41 Queries per second avg: 12.361 | Threads: 1 Questions: 581 Slow queries: 0 Opens: 189 Flush tables: 1 Open tables: 41 Queries per second avg: 12.361 | ||
</ | </source> | ||
< | <source lang='console'> | ||
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 31551/mysqld | tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 31551/mysqld | ||
</ | </source> | ||
< | <source lang='console'> | ||
root@zetawiki:~# mysql -uroot -p -e'show databases' | root@zetawiki:~# mysql -uroot -p -e'show databases' | ||
Enter password: P@ssw0rd | Enter password: P@ssw0rd | ||
| 120번째 줄: | 120번째 줄: | ||
| performance_schema | | | performance_schema | | ||
+--------------------+ | +--------------------+ | ||
</ | </source> | ||
==같이 보기== | ==같이 보기== | ||