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