Pertemuan 1
cd.. => Keluar dari 1 Directory
cd \ => Keluar dari semua Directory
cd<spasi> => Masuk ke Directory
lalu masuk ke Directory
C:\Program Files\xampp\mysql\bin>
- Ketik mysql -u root
C:\Program Files\xampp\mysql\bin>mysql
-u root
Jika Mysql meminta password tambahkan –p
(password: root)
C:\Program Files\xampp\mysql\bin>mysql
-u root -p
Untuk membuat database
Ketik
create database <nama>;
Untuk melihat database
Program Running dalam CMD :
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\STMIK>cd \
C:\>cd "Program Files\xampp\mysql"\bin
C:\Program Files\xampp\mysql\bin>mysql -u root –p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.27-community
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database SBD_Markus;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| mysql |
| phpmyadmin |
| sbd_markus |
| test |
| webauth |
+--------------------+
7 rows in set (0.00 sec)
mysql>
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\STMIK>cd \
C:\>cd "Program Files\xampp\mysql"\bin
C:\Program Files\xampp\mysql\bin>mysql -u root –p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.27-community
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database SBD_Markus;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| mysql |
| phpmyadmin |
| sbd_markus |
| test |
| webauth |
+--------------------+
7 rows in set (0.00 sec)
mysql>
