우분투 MySQL 설치

Jmnote (토론 | 기여)님의 2015년 12월 14일 (월) 11:07 판 (→‎같이 보기)
우분투 MySQL 설치
우분투 MySQL 서버 설치

1 설치

root@jmnote02:~# 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 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 mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server
  mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 12 newly installed, 0 to remove and 48 not upgraded.
Need to get 27.3 MB of archives.
After this operation, 97.5 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
... (생략)
New password for the MySQL "root" user:
→ MySQL의 root 계정 패스워드 지정
Repeat password for the MySQL "root" user:
→ MySQL의 root 계정 패스워드 재입력
... (생략)
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.
mysql start/running, process 30674
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@jmnote02:~# mysql -V
mysql  Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.2
root@jmnote02:~# netstat -ntlp | grep mysqld
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      30674/mysqld
root@jmnote02:~# mysql -uroot -pP@ssw0rd -e'show databases'
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+

3 같이 보기

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