- 다른 뜻에 대해서는 우분투 MySQL 클라이언트 설치 문서를 참조하십시오.
- 다른 뜻에 대해서는 CentOS MySQL 서버 설치 문서를 참조하십시오.
- 우분투 MySQL 설치
- 우분투 MySQL 서버 설치
1 확인
<source lang='console'> root@zetawiki:~# cat /etc/init.d/mysql cat: /etc/init.d/mysql: No such file or directory </syntaxhighlight> <source lang='console'> root@zetawiki:~# dpkg -l | grep mysql-server root@zetawiki:~# aptitude show mysql-server | grep ^State State: not installed </syntaxhighlight>
2 설치
<source lang='console'> 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] </syntaxhighlight> <source lang='console'> ... (생략) </syntaxhighlight> <source 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 계정 패스워드 지정
<source lang='text'>
┌───┤ Configuring mysql-server-5.5 ├───┐ │ │ │ Repeat password for the MySQL "root" user. │ │ │ │ │ │ ********____________________________________ │ │ │ │ <Ok> │ │ │ └───────────────────────┘
</syntaxhighlight>
- → 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 [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) ... </syntaxhighlight>
3 확인
<source lang='console'> 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 </syntaxhighlight> <source lang='console'> root@zetawiki:~# netstat -ntlp | grep mysqld tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 31551/mysqld </syntaxhighlight> <source lang='console'> root@zetawiki:~# mysql -uroot -p -e'show databases' Enter password: P@ssw0rd +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ </syntaxhighlight>
4 같이 보기
-
{{comment.page_title}} ―{{comment.name}}