Oleh : Imam A.W., S.Kom., M.Kom.

  • Instalasi MySql 5 denggan perintah :

    root@ubuntu:/# apt-get install mysql-server mysql-client

    Isi dengan password Root pada Mysql 5

    New password for the MySQL “root” user: <– yourrootsqlpassword
    Repeat password for the MySQL “root” user: <– yourrootsqlpassword

  • Jalankan service mysql dengan perintah :

    root@ubuntu:/# /etc/init.d/mysql restart

    Rather than invoking init scripts through /etc/init.d, use the service(8)

    utility, e.g. service mysql restart

    Since the script you are attempting to invoke has been converted to an

    Upstart job, you may also use the stop(8) and then start(8) utilities,

    e.g. stop mysql ; start mysql. The restart(8) utility is also available.

    mysql stop/waiting

    mysql start/running, process 1851

  • Ujicoba dengan login ke database server dengan cara :

    root@ubuntu:/# mysql -u nabiha -p

    Enter password:

    Welcome to the MySQL monitor. Commands end with ; or \g.

    Your MySQL connection id is 47

    Server version: 5.1.63-0ubuntu0.11.10.1 (Ubuntu)

    Copyright (c) 2000, 2011, 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.

    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

    mysql> show databases;

    +——————–+

    | Database |

    +——————–+

    | information_schema |

    | coba |

    | mysql |

    | phpmyadmin |

    | testing |

    +——————–+

    5 rows in set (0.05 sec)

    mysql>

    mysql> quit

    Bye

  • Instalasi dan Konfigurasi PHPMyAdmin

    Sebelum memlui instalasi PhpMyadmin, pastikan terlebih dahulu web server telah terinstal, dikonfigurasi dan berjalan dengan baik.

    PHPMyAdmin adalah sebuah Interface WEB yang digunakan untuk memanag Database Mysql.

    – Install dengan perintah :

    root@ubuntu:/# apt-get install phpmyadmin

    Jawab pertanyaan dengan jawaban di bawah ini :

    Web server to reconfigure automatically: <– apache2
    Configure database for phpmyadmin with dbconfig-common? <– No

    • Panggil phpmyadmin dengan menuliskan pada URL address kita : http://server/phpmyadmin. Masukkan user dan password database mysql yang telah kita buat pada saat melakukan instalasi MySQL Server.

  • Untuk mematikan service database gunakan perintah:

    root@ubuntu:/# /etc/init.d/mysql stop

    Rather than invoking init scripts through /etc/init.d, use the service(8)

    utility, e.g. service mysql stop

    Since the script you are attempting to invoke has been converted to an

    Upstart job, you may also use the stop(8) utility, e.g. stop mysql

    mysql stop/waiting

  • Untuk melihat status service database gunakan perintah:

    root@ubuntu:/# /etc/init.d/mysql status

    Rather than invoking init scripts through /etc/init.d, use the service(8)

    utility, e.g. service mysql status

    Since the script you are attempting to invoke has been converted to an

    Upstart job, you may also use the status(8) utility, e.g. status mysql

    mysql start/running, process 1851

  • Log database dapat dilihat dengan perintah :

    root@ubuntu:/# tail -f /var/log/mysql.log