Membuat Database Di MySql Lewat CMD

+==========+==========+==========+==========+==========+==========+==========+==========+
|                                 |
|      )  )            )                    (  (        (  (    (      )    )   |
|    ( /(( /( (      ( /(  (      (    (    )\ ))\ )      )\ ))\ ) )\ ) ( /(  ( /(   |
|    )\())\()))\ )    )\()) )\      )\  )\  (()/(()/(  (  (()/(()/((()/( )\()) )\())   |
|  ((_)((_)\(()/(  ((_)((((_)(  (((_)(((_)(  /(_))(_)) )\  /(_))(_))/(_))(_)\ ((_)\   |
|  __ ((_)((_)/(_))___ ((_)\ _ )\ )\___)\ _ )\(_))(_))_ ((_)(_))(_)) (_))  _((_)_ ((_)   |
+  \ \ / / _ (_)) __\ \ / (_)_\(_)(/ __(_)_\(_) _ \1  \1 __1 _ \ 1  1_ _11 \1 1 1/ /   +
+  \ V / (_) 11 (_ 1\ V / / _ \  1 (__ / _ \ 1  /1 1) 1 _11  / 1__ 1 1 1 .` 1 ' /    +
|    1_1 \___/  \___1 1_1 /_/ \_\  \___/_/ \_\1_1_\1___/1___1_1_\____1___11_1\_1_1\_\   |
|                                 |
|                             .:[ Jastis Black Hat ]:.            |
|                        If you wanna play, play with your level         |
|                              We can do all you can't do            |
|                            http://yogyacarderlink.web.id/             |
+==========+==========+==========+==========+==========+==========+==========+==========+



Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\BLACK HAT>cd\

C:\>cd appserv

C:\AppServ>cd mysql

C:\AppServ\MySQL>cd bin

C:\AppServ\MySQL\bin>mysql -uroot -p
Enter password: *****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.45-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| buku_php          |
| mysql              |
| phpmyadmin        |
| smf                |
| system            |
| test              |
+--------------------+
7 rows in set (0.31 sec)

mysql> create database jastis;
Query OK, 1 row affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| buku_php          |
| jastis            |
| mysql              |
| phpmyadmin        |
| smf                |
| system            |
| test              |
+--------------------+
8 rows in set (0.01 sec)

mysql> use jastis;
Database changed
mysql> create table user(id int(4),nama_lengkap char(50),username char(20),email char(30),password char(30),city char(50));
Query OK, 0 rows affected (0.17 sec)

mysql> show tables;
+------------------+
| Tables_in_jastis |
+------------------+
| user            |
+------------------+
1 row in set (0.02 sec)

mysql> insert into user values("0001","Jastis Bago","Jastis","jastis_quitaris@yahoo.com","jast272010","Medan");
Query OK, 1 row affected (0.05 sec)

mysql> insert into user values("0002","Rangga Kiddies","z0mb13","z0mb13@yahoo.com","lintahdarat666","Jakarta");
Query OK, 1 row affected (0.02 sec)

mysql> insert into user values("0003","Ryan Smith","v3n0m","jenderalvenom666@hotmail","lie78sial","Bekasi");
Query OK, 1 row affected (0.02 sec)

mysql> insert into user values("0004","Antonius","mywisdom","anton@yahoo.com","hitamkelabu666","Tanggerang");
Query OK, 1 row affected (0.02 sec)

mysql> insert into user values("0005","Angga Artupas","Artupas","artupas@yahoo.com","jiakakak43","Jakarta");
Query OK, 1 row affected (0.00 sec)

mysql> desc user;
+--------------+----------+------+-----+---------+-------+
| Field        | Type    | Null | Key | Default | Extra |
+--------------+----------+------+-----+---------+-------+
| id          | int(4)  | YES  |    | NULL    |      |
| nama_lengkap | char(50) | YES  |    | NULL    |      |
| username    | char(20) | YES  |    | NULL    |      |
| email        | char(30) | YES  |    | NULL    |      |
| password    | char(30) | YES  |    | NULL    |      |
| city        | char(50) | YES  |    | NULL    |      |
+--------------+----------+------+-----+---------+-------+
6 rows in set (0.06 sec)

mysql> select *from user;
+------+----------------+----------+---------------------------+----------------+------------+
| id  | nama_lengkap  | username | email                    | password   | city      |
+------+----------------+----------+---------------------------+----------------+------------+
|    1 | Jastis Bago    | Jastis  | [You must be registered and logged in to see this link.] | jast272010   | Californias|
|    2 | Rangga Kiddies | z0mb13  | [You must be registered and logged in to see this link.]          | lintahdarat666   | Jakarta    |
|    3 | Ryan Smith    | v3n0m    | jenderalvenom666@hotmail  | lie78sial   | Bekasi    |
|    4 | Antonius      | mywisdom | [You must be registered and logged in to see this link.]          | hitamkelabu666   | Tanggerang |
|    5 | Angga Artupas  | Artupas  | [You must be registered and logged in to see this link.]        | jiakakak43   | Jakarta    |
+------+----------------+----------+---------------------------+----------------+------------+
5 rows in set (0.00 sec)

mysql> update user set password="2719990" where id="0001";
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select *from user;
+------+----------------+----------+---------------------------+----------------+------------+
| id  | nama_lengkap  | username | email                    | password   | city      |
+------+----------------+----------+---------------------------+----------------+------------+
|    1 | Jastis Bago    | Jastis  | [You must be registered and logged in to see this link.] | 2719990   | Californias|
|    2 | Rangga Kiddies | z0mb13  | [You must be registered and logged in to see this link.]          | lintahdarat666   | Jakarta    |
|    3 | Ryan Smith    | v3n0m    | jenderalvenom666@hotmail  | lie78sial   | Bekasi    |
|    4 | Antonius      | mywisdom | [You must be registered and logged in to see this link.]          | hitamkelabu666   | Tanggerang |
|    5 | Angga Artupas  | Artupas  | [You must be registered and logged in to see this link.]        | jiakakak43   | Jakarta    |
+------+----------------+----------+---------------------------+----------------+------------+
5 rows in set (0.02 sec)

mysql> delete from user where id="0005";
Query OK, 1 row affected (0.00 sec)

mysql> select *from user;
+------+----------------+----------+---------------------------+----------------+------------+
| id  | nama_lengkap  | username | email                    | password   | city      |
+------+----------------+----------+---------------------------+----------------+------------+
|    1 | Jastis Bago    | Jastis  | [You must be registered and logged in to see this link.] | 2719990   | Californias|
|    2 | Rangga Kiddies | z0mb13  | [You must be registered and logged in to see this link.]          | lintahdarat666   | Jakarta    |
|    3 | Ryan Smith    | v3n0m    | jenderalvenom666@hotmail  | lie78sial   | Bekasi    |
|    4 | Antonius      | mywisdom | [You must be registered and logged in to see this link.]          | hitamkelabu666   | Tanggerang |
+------+----------------+----------+---------------------------+----------------+------------+
4 rows in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| buku_php          |
| jastis            |
| mysql              |
| phpmyadmin        |
| smf                |
| system            |
| test              |
+--------------------+
8 rows in set (0.00 sec)

mysql> use mysql;
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql          |
+---------------------------+
| columns_priv              |
| db                        |
| func                      |
| help_category            |
| help_keyword              |
| help_relation            |
| help_topic                |
| host                      |
| proc                      |
| procs_priv                |
| tables_priv              |
| time_zone                |
| time_zone_leap_second    |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
17 rows in set (0.05 sec)

mysql> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
+-----------+------+-------------------------------------------+
1 row in set (0.01 sec)

mysql> desc tables_priv;
+-------------+-------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+-------+
| Field      | Type                                             | Null | Key |      Default    | Extra |
+-------------+-------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+-------+
| Host        | char(60)                                          | NO  | PRI |          |      |
| Db          | char(64)                                          | NO  | PRI |          |      |
| User        | char(16)                                          | NO  | PRI |          |      |
| Table_name  | char(64)                                          | NO  | PRI |          |      |
| Grantor    | char(77)                                          | NO  | MUL |         |      |
| Timestamp  | timestamp                                          | NO  |    | CURRENT_TIMESTAMP |      |
| Table_priv  | set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view') | NO  |    |          |      |
| Column_priv | set('Select','Insert','Update','References')                              | NO  |    |          |      |
+-------------+-------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+-------+
8 rows in set (0.03 sec)

mysql> select user,table_name,grantor,table_priv from tables_priv;
Empty set (0.00 sec)

mysql> GRANT select on jastis.user to Jastis IDENTIFIED BY "08200410";
Query OK, 0 rows affected (0.14 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

mysql> use mysql;
Database changed
mysql> select user,password,select_priv,insert_priv from user;
+--------+-------------------------------------------+-------------+-------------+
| user  | password                                  | select_priv | insert_priv |   
|      
+--------+-------------------------------------------+-------------+-------------+
| root  | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | Y          | Y       |
|                     
| Jastis | *BBAA77143C200A53D19F50A0A8C04AD677277970 | N          | N       |
+--------+-------------------------------------------+-------------+-------------+
2 rows in set (0.02 sec)

mysql> desc tables_priv;
+-------------+-------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+-------+
| Field      | Type                                             | Null | Key | Default       | Extra |
+-------------+-------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+-------+
| Host        | char(60)                                          | NO  | PRI |          |      |
| Db          | char(64)                                          | NO  | PRI |          |      |
| User        | char(16)                                          | NO  | PRI |          |      |
| Table_name  | char(64)                                          | NO  | PRI |          |      |
| Grantor    | char(77)                                          | NO  | MUL |           |      |
| Timestamp  | timestamp                                          | NO  |    | CURRENT_TIMESTAMP |      |
| Table_priv  | set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view') | NO  |    |           |      |
| Column_priv | set('Select','Insert','Update','References')                              | NO  |    |           |      |
+-------------+-------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+-------+
8 rows in set (0.03 sec)

mysql> select user,table_name,grantor,table_priv from tables_priv;
+--------+------------+----------------+------------+
| user  | table_name | grantor        | table_priv |
+--------+------------+----------------+------------+
| Jastis | user      | root@localhost | Select    |
+--------+------------+----------------+------------+
1 row in set (0.00 sec)


mysql> exit
Bye

//* Sign in sebagai Jastis *//

C:\AppServ\MySQL\bin>mysql -uJastis -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.45-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| jastis            |
+--------------------+
2 rows in set (0.11 sec)

mysql>