Cara Install MySQL 5 di Debian

Kali ini saya install MySQL 5

Caranya sangat mudah menggunakan apt-get dari terminal

sudo apt-get install mysql-server

Tampilan prosesnya seperti ini:

rahmatriyanto@debian6:~$ su
Password: 
root@debian6:/home/rahmatriyanto# sudo 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 libmysqlclient16
  libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common
  mysql-server-5.1 mysql-server-core-5.1
Suggested packages:
  libipc-sharedcache-perl libterm-readkey-perl tinyca
The following NEW packages will be installed:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16
  libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common mysql-server
  mysql-server-5.1 mysql-server-core-5.1
0 upgraded, 11 newly installed, 0 to remove and 228 not upgraded.
Need to get 22.2 MB/23.3 MB of archives.
After this operation, 54.7 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 https://security.debian.org/ squeeze/updates/main mysql-common all 5.1.73-1 [71.2 kB]
Get:2 https://security.debian.org/ squeeze/updates/main libmysqlclient16 i386 5.1.73-1 [1,927 kB]
Get:3 https://security.debian.org/ squeeze/updates/main mysql-client-5.1 i386 5.1.73-1 [9,615 kB]
Media change: please insert the disc labeled                                   
 'Debian GNU/Linux 6.0.3 _Squeeze_ - Official i386 DVD Binary-1 20111008-13:01'
in the drive '/media/cdrom/' and press enter

Media change: please insert the disc labeled                                   
 'Debian GNU/Linux 6.0.3 _Squeeze_ - Official i386 DVD Binary-1 20111008-13:01'
in the drive '/media/cdrom/' and press enter

Media change: please insert the disc labeled                                   
 'Debian GNU/Linux 6.0.3 _Squeeze_ - Official i386 DVD Binary-1 20111008-13:01'
in the drive '/media/cdrom/' and press enter

Get:4 https://security.debian.org/ squeeze/updates/main mysql-server-core-5.1 i386 5.1.73-1 [3,955 kB]
Get:5 https://security.debian.org/ squeeze/updates/main mysql-server-5.1 i386 5.1.73-1 [6,543 kB]
Get:6 https://security.debian.org/ squeeze/updates/main mysql-server all 5.1.73-1 [65.7 kB]
Fetched 22.2 MB in 4min 1s (91.8 kB/s)                                         
Preconfiguring packages ...
Selecting previously deselected package mysql-common.
(Reading database ... 127614 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.1.73-1_all.deb) ...
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.612-1_i386.deb) ...
Selecting previously deselected package libmysqlclient16.
Unpacking libmysqlclient16 (from .../libmysqlclient16_5.1.73-1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_i386.deb) ...
Selecting previously deselected package mysql-client-5.1.
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.73-1_i386.deb) ...
Selecting previously deselected package mysql-server-core-5.1.
Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.73-1_i386.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.1.73-1) ...
Selecting previously deselected package mysql-server-5.1.
(Reading database ... 127990 files and directories currently installed.)
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.73-1_i386.deb) ...
Selecting previously deselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-2_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.1.73-1_all.deb) ...
Processing triggers for man-db ...
Setting up libnet-daemon-perl (0.43-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.612-1) ...
Setting up libmysqlclient16 (5.1.73-1) ...
Setting up libdbd-mysql-perl (4.016-1) ...
Setting up mysql-client-5.1 (5.1.73-1) ...
Setting up mysql-server-core-5.1 (5.1.73-1) ...
Setting up mysql-server-5.1 (5.1.73-1) ...
Stopping MySQL database server: mysqld.
141225  5:39:06 [Note] Plugin 'FEDERATED' is disabled.
141225  5:39:06  InnoDB: Initializing buffer pool, size = 8.0M
141225  5:39:06  InnoDB: Completed initialization of buffer pool
141225  5:39:06  InnoDB: Started; log sequence number 0 44233
141225  5:39:06  InnoDB: Starting shutdown...
141225  5:39:12  InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Setting up libhtml-template-perl (2.9-2) ...
Setting up mysql-server (5.1.73-1) ...
root@debian6:/home/rahmatriyanto#

Setelah proses install selesai untuk mejalankan MySQL gunakancara berikut:

root@debian6:/home/rahmatriyanto# /etc/init.d/mysql start
 Starting MySQL database server: mysqld.
 Checking for corrupt, not cleanly closed and upgrade needing tables..
 root@debian6:/home/rahmatriyanto# /etc/init.d/mysql restart
 Stopping MySQL database server: mysqld.
 Starting MySQL database server: mysqld.
 Checking for corrupt, not cleanly closed and upgrade needing tables..
 root@debian6:/home/rahmatriyanto# /etc/init.d/mysql reload
 Reloading MySQL database server: mysqld.
 root@debian6:/home/rahmatriyanto# /etc/init.d/mysql force-reload
 Reloading MySQL database server: mysqld.
 root@debian6:/home/rahmatriyanto# /etc/init.d/mysql status
 /usr/bin/mysqladmin Ver 8.42 Distrib 5.1.73, for debian-linux-gnu on i486
 Copyright (c) 2000, 2013, 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.1.73-1
 Protocol version 10
 Connection Localhost via UNIX socket
 UNIX socket /var/run/mysqld/mysqld.sock
 Uptime: 31 sec

Threads: 1 Questions: 104 Slow queries: 0 Opens: 99 Flush tables: 1 Open tables: 23 Queries per second avg: 3.354.
 root@debian6:/home/rahmatriyanto# /etc/init.d/mysql stop
 Stopping MySQL database server: mysqld.
 root@debian6:/home/rahmatriyanto#

Leave a Reply

Your email address will not be published. Required fields are marked *