usahawan-maju | Cara Membuat Database Dengan CMD - Anda yang sedang belajar cara membuat database semoga postingan kali ini bermanfaat. Hal yang harus dilakukan untuk membuat database dari CMD adalah pastinya masuk cmd terlebih dahulu, kemudian masuk ke root dari file xampp/mysql/bin dimana pada folder bin tersebut terdapat file mysql yang akan kita gunakan. lihatlah pada gambar berikut ini.
Cara masuk kedirektori lain pada cmd adalah dengan mengetikkan cd<spasi> lokasi(direktori)
contoh dalam direktori c:\xampp\mysql\bin ketikan saja pada cmd : cd c:\xampp\mysql\bin (enter)
maka direktori akan berubah sesuai yang kita inginkan.
jangan lupa menyalakan start pada xampp control panel, karena ini sebagai penghubung ke database kita dengan aplikasi lain.
hehehe coret-coretan gambarnya namun skriptnya akan saya ketikkan sebagai berikut :
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\User>cd c:\xampp\mysql\bin
c:\xampp\mysql\bin>mysql -u -p root
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
c:\xampp\mysql\bin>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
c:\xampp\mysql\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.33-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database;
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 '' at line 1
mysql> create database cobalah;
Query OK, 1 row affected (0.00 sec)
mysql> use cobalah;
Database changed
mysql> create table uji (no varchar(2),
-> alamat varchaar(20));
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 'varchaar(20))'
mysql> create table uji ( no varchar(2),
-> alamat varchaar(20));
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 'varchaar(20))'
mysql> create table uji (no varchar(2),
-> alamat varchar(20));
Query OK, 0 rows affected (0.04 sec)
mysql> desck uji;
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 'desck uji' at l
mysql> desc uji;
+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| no | varchar(2) | YES | | NULL | |
| alamat | varchar(20) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)
mysql>
penjelasan error pada script silahkan baca pada gambar yang telah saya coret-coret. Sekian artikel postingan ini saya buat Cara Membuat Database Dengan CMD semoga bermanfaat.
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\User>cd c:\xampp\mysql\bin
c:\xampp\mysql\bin>mysql -u -p root
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
c:\xampp\mysql\bin>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
c:\xampp\mysql\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.33-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database;
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 '' at line 1
mysql> create database cobalah;
Query OK, 1 row affected (0.00 sec)
mysql> use cobalah;
Database changed
mysql> create table uji (no varchar(2),
-> alamat varchaar(20));
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 'varchaar(20))'
mysql> create table uji ( no varchar(2),
-> alamat varchaar(20));
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 'varchaar(20))'
mysql> create table uji (no varchar(2),
-> alamat varchar(20));
Query OK, 0 rows affected (0.04 sec)
mysql> desck uji;
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 'desck uji' at l
mysql> desc uji;
+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| no | varchar(2) | YES | | NULL | |
| alamat | varchar(20) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)
mysql>
penjelasan error pada script silahkan baca pada gambar yang telah saya coret-coret. Sekian artikel postingan ini saya buat Cara Membuat Database Dengan CMD semoga bermanfaat.
