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

52번째 줄: 52번째 줄:
root@ubuntu:~# netstat -ntlp | grep mysqld
root@ubuntu:~# netstat -ntlp | grep mysqld
tcp        0      0 127.0.0.1:3306          0.0.0.0:*              LISTEN      2029/mysqld     
tcp        0      0 127.0.0.1:3306          0.0.0.0:*              LISTEN      2029/mysqld     
</source>
<source lang='cli'>
root@ubuntu:~# mysql -uroot -pP@ssw0rd -e'show databases'
+--------------------+
| Database          |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
</source>
</source>



2014년 12월 3일 (수) 22:38 판

우분투 MySQL 설치
우분투 MySQL 서버 설치

1 설치

root@ubuntu:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl
  libmysqlclient18 libnet-daemon-perl 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:
  libipc-sharedcache-perl tinyca mailx
The following NEW packages will be installed:
  libdbd-mysql-perl libdbi-perl libhtml-template-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
0 upgraded, 13 newly installed, 0 to remove and 37 not upgraded.
Need to get 27.3 MB of archives.
After this operation, 97.6 MB of additional disk space will be used.
Do you want to continue [Y/n]?
... (생략)
New password for the MySQL "root" user:
→ MySQL의 root 계정 패스워드 지정
Repeat password for the MySQL "root" user:
→ MySQL의 root 계정 패스워드 재입력
... (생략)
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.
mysql start/running, process 2029
Setting up libhtml-template-perl (2.10-1) ...
Setting up mysql-server (5.5.40-0ubuntu0.12.04.1) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

2 확인

root@ubuntu:~# mysql -V
mysql  Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.2
root@ubuntu:~# netstat -ntlp | grep mysqld
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      2029/mysqld
root@ubuntu:~# mysql -uroot -pP@ssw0rd -e'show databases'
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+

3 같이 보기

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