Bagaimana kabar antum hari ini..?
Tes...Tes....
Ehm.....ehm....ehm....
Di coba..di coba satu dua tiga Hallo.....
Ok Akhi hari ini ane belajar Basis Data karo Sistem Informasi Manajemen atau byasa kita sebut (SIM)...
Tapi sayangnya Dosennya tidak bisa hadir because ada kepentingan yang lain .. EeeetzZzz.. tapi jangan salah bukan berarti lari dari tugas ok..?
Alhamdulillah ada penggantinya yaitu Dosen Muda PeTIK mau tau siapa namanya..?
Beliau Adalah....
Jreng2...jreng...
Ust.Bili Sabili masih muda, cakep, gokil pokoknya harus bilang Wow gitu...
selain muda dan ganteng beliau juga mendapatkan nilai IP yang tinggi dari yang lain nya lhoo.... Sungguh menakjubkan...
Eeeet Deh ko malah cuRhatz Ups...
Ok kita Masuk ke Pelajaran...
Basis Data Tadi belajar tentang Mysql ...
Yuk Jelajahi Terminal....
Pertama Kita Buka Terminal terus usahakan MysQL sudah terinsTall yua,,,
langkahnya contoh :
abdiellah@abdiellah-System-Product-Name:~$
sudo su
maka akan muncul--->
[sudo] password for abdiellah:(masukan password yang sudah kita atur)
klik Enter.....
maka akan muncul....
root@abdiellah-System-Product-Name:/home/abdiellah#
teruz... ketik dpkg --list mysql-server
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required
(Status,Err: uppercase=bad)
||/ Name Version
Description
+++-==============-==============-============================================
ii mysql-server 5.1.63-0ubuntu MySQL
database server (metapackage depending
root@abdiellah-System-Product-Name:/home/abdiellah#
service mysql status
mysql start/running, process 913
root@abdiellah-System-Product-Name:/home/abdiellah#
/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 913
root@abdiellah-System-Product-Name:/home/abdiellah#
root@abdiellah-System-Product-Name:/home/abdiellah#
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands
end with ; or \g.
Your MySQL connection id is 37
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
-> show databases;
ERROR 1064 (42000): You have an error
in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'show databases' at
line 2
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| petik |
+--------------------+
3 rows in set (0.02 sec)
mysql> create databases petik;
ERROR 1064 (42000): You have an error
in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'databases petik' at
line 1
UpzzZzzz... ternyata Ada yang ERROR... :-(letak salahnya adalh kita harus buka use petik terlebih dahulu gays...
mysql> use petik;
Reading table information for
completion of table and column names
You can turn off this feature to get a
quicker startup with -A
Database changed
mysql> show tables;
+-----------------+
| Tables_in_petik |
+-----------------+
| siswa |
+-----------------+
1 row in set (0.00 sec)
kalau mau keluar..
mysql>\q
maka akan muncul
By tertanda sudah keluar...
root@abdiellah-System-Product-Name:/home/abdiellah#
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands
end with ; or \g.
Your MySQL connection id is 39
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 |
| mysql |
| petik |
+--------------------+
3 rows in set (0.00 sec)
mysql> show tables;
ERROR 1046 (3D000): No database
selected
mysql> show tables petik;
ERROR 1046 (3D000): No database
selected
mysql> use petik;
Reading table information for
completion of table and column names
You can turn off this feature to get a
quicker startup with -A
Database changed
mysql> use petik;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_petik |
+-----------------+
| siswa |
+-----------------+
1 row in set (0.00 sec)
mysql> \q
Bye
root@abdiellah-System-Product-Name:/home/abdiellah#
mysql
Welcome to the MySQL monitor. Commands
end with ; or \g.
Your MySQL connection id is 40
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 tables;
ERROR 1046 (3D000): No database
selected
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| petik |
+--------------------+
3 rows in set (0.00 sec)
mysql> use petik;
Reading table information for
completion of table and column names
You can turn off this feature to get a
quicker startup with -A
Database changed
mysql> grant all privileges on *.*
to 'dilah@localhost' identified by 'mujahid';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> use mysql;
Reading table information for
completion of table and column names
You can turn off this feature to get a
quicker startup with -A
Database changed
mysql> select user from user;
+------------------+
| user |
+------------------+
| dilah@localhost |
| root |
| root |
| debian-sys-maint |
| root |
+------------------+
5 rows in set (0.00 sec)
mysql> \q
Bye
mysql> grant all privileges on *.*
to 'dilah'@'localhost' identified by 'mujahid';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye
root@abdiellah-System-Product-Name:/home/abdiellah#
mysql -u dilah -p petik
Enter password:
Reading table information for
completion of table and column names
You can turn off this feature to get a
quicker startup with -A
Welcome to the MySQL monitor. Commands
end with ; or \g.
Your MySQL connection id is 45
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> \q
Bye
Wallahu a'lam...
kalo pusing..? sama ane juga hahahaha...
0 komentar:
Posting Komentar