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#