Microsoft Windows [Version 10.0.19042.
1526]
(c) Microsoft Corporation. All rights reserved.
C:\Users\user>dir/w
Volume in drive C has no label.
Volume Serial Number is BCE5-9BBE
Directory of C:\Users\user
[.] [..] .bash_history .gitconfig [.vscode]
[3D Objects] [Contacts] [Desktop] [Documents] [Downloads]
[Favorites] [Links] [Music] [OneDrive] [Saved Games]
[Searches] [Videos]
2 File(s) 381 bytes
15 Dir(s) 34.367.401.984 bytes free
C:\Users\user>dir/u
Invalid switch - "u".
C:\Users\user>cd xampp
The system cannot find the path specified.
C:\Users\user>cd
C:\Users\user
C:\Users\user>cd
C:\Users\user
C:\Users\user>cd..
C:\Users>cd..
C:\>xampp
'xampp' is not recognized as an internal or external command,
operable program or batch file.
C:\>cd..
C:\>dir
Volume in drive C has no label.
Volume Serial Number is BCE5-9BBE
Directory of C:\
06/12/2021 19:54 <DIR> Intel
07/12/2019 01:14 <DIR> PerfLogs
11/02/2022 01:14 <DIR> Program Files
03/02/2022 22:22 <DIR> Program Files (x86)
22/12/2021 16:22 <DIR> Users
12/02/2022 02:45 <DIR> Windows
12/02/2022 19:29 <DIR> xampp
0 File(s) 0 bytes
7 Dir(s) 34.366.279.680 bytes free
C:\>cd/xampp
C:\xampp>dir
Volume in drive C has no label.
Volume Serial Number is BCE5-9BBE
Directory of C:\xampp
12/02/2022 19:29 <DIR> .
12/02/2022 19:29 <DIR> ..
12/02/2022 19:25 <DIR> anonymous
12/02/2022 19:25 <DIR> apache
07/06/2013 03:15 436 apache_start.bat
12/02/2022 19:29 176 apache_stop.bat
05/04/2021 08:16 10.324 catalina_service.bat
05/04/2021 08:17 3.766 catalina_start.bat
05/04/2021 08:17 3.529 catalina_stop.bat
12/02/2022 19:29 <DIR> cgi-bin
12/02/2022 19:25 <DIR> contrib
12/02/2022 19:25 2.731 ctlscript.bat
12/02/2022 19:29 <DIR> FileZillaFTP
30/03/2013 04:29 78 filezilla_setup.bat
07/06/2013 03:15 150 filezilla_start.bat
07/06/2013 03:15 149 filezilla_stop.bat
12/02/2022 19:34 <DIR> htdocs
12/02/2022 19:25 <DIR> img
12/02/2022 19:29 <DIR> install
27/08/2019 06:01 299 killprocess.bat
12/02/2022 19:25 <DIR> licenses
12/02/2022 19:25 <DIR> locale
12/02/2022 19:25 <DIR> mailoutput
12/02/2022 19:25 <DIR> mailtodisk
12/02/2022 19:29 <DIR> MercuryMail
07/06/2013 03:15 136 mercury_start.bat
07/06/2013 03:15 60 mercury_stop.bat
12/02/2022 19:26 <DIR> mysql
03/06/2019 03:39 471 mysql_start.bat
12/02/2022 19:29 256 mysql_stop.bat
13/03/2017 03:04 824 passwords.txt
12/02/2022 19:27 <DIR> perl
12/02/2022 19:29 <DIR> php
12/02/2022 19:28 <DIR> phpMyAdmin
12/02/2022 19:29 792 properties.ini
21/01/2022 08:47 7.498 readme_de.txt
21/01/2022 08:47 7.368 readme_en.txt
12/02/2022 19:29 <DIR> sendmail
30/03/2013 04:29 60.928 service.exe
30/03/2013 04:29 1.255 setup_xampp.bat
12/02/2022 19:25 <DIR> src
18/12/2019 09:25 1.671 test_php.bat
12/02/2022 19:32 <DIR> tmp
12/02/2022 19:26 <DIR> tomcat
12/02/2022 19:29 255.159 uninstall.dat
12/02/2022 19:29 12.521.215 uninstall.exe
12/02/2022 19:29 <DIR> webalizer
12/02/2022 19:25 <DIR> webdav
06/04/2021 03:38 3.368.448 xampp-control.exe
12/02/2022 19:29 178 xampp-control.ini
12/02/2022 19:25 1.084 xampp_shell.bat
30/03/2013 04:29 118.784 xampp_start.exe
30/03/2013 04:29 118.784 xampp_stop.exe
28 File(s) 16.486.549 bytes
25 Dir(s) 34.366.083.072 bytes free
C:\xampp>cd/htdoc
The system cannot find the path specified.
C:\xampp>cd/htdocs
The system cannot find the path specified.
C:\xampp>cd/Mysql
The system cannot find the path specified.
C:\xampp>cd mysql
C:\xampp\mysql>dir
Volume in drive C has no label.
Volume Serial Number is BCE5-9BBE
Directory of C:\xampp\mysql
12/02/2022 19:26 <DIR> .
12/02/2022 19:26 <DIR> ..
12/02/2022 19:26 <DIR> backup
12/02/2022 19:29 <DIR> bin
05/11/2021 11:03 17.987 COPYING
05/11/2021 11:03 2.093 CREDITS
12/02/2022 19:32 <DIR> data
30/03/2013 04:29 848 mysql_installservice.bat
30/03/2013 04:29 395 mysql_uninstallservice.bat
05/11/2021 11:03 2.874 README.md
03/06/2019 03:39 1.095 resetroot.bat
12/02/2022 19:25 <DIR> scripts
12/02/2022 19:26 <DIR> share
05/11/2021 11:03 86.263 THIRDPARTY
7 File(s) 111.555 bytes
7 Dir(s) 34.366.013.440 bytes free
C:\xampp\mysql>cd bin
C:\xampp\mysql\bin>dir
Volume in drive C has no label.
Volume Serial Number is BCE5-9BBE
Directory of C:\xampp\mysql\bin
12/02/2022 19:29 <DIR> .
12/02/2022 19:29 <DIR> ..
22/10/2018 18:10 21.032 api-ms-win-core-console-l1-1-0.dll
22/10/2018 18:10 21.024 api-ms-win-core-console-l1-2-0.dll
22/10/2018 18:10 20.512 api-ms-win-core-datetime-l1-1-0.dll
22/10/2018 18:10 20.544 api-ms-win-core-debug-l1-1-0.dll
22/10/2018 18:10 20.520 api-ms-win-core-errorhandling-l1-1-0.dll
22/10/2018 18:10 24.104 api-ms-win-core-file-l1-1-0.dll
22/10/2018 18:10 20.520 api-ms-win-core-file-l1-2-0.dll
22/10/2018 18:10 20.520 api-ms-win-core-file-l2-1-0.dll
22/10/2018 18:10 20.520 api-ms-win-core-handle-l1-1-0.dll
22/10/2018 18:10 21.032 api-ms-win-core-heap-l1-1-0.dll
22/10/2018 18:10 20.520 api-ms-win-core-interlocked-l1-1-0.dll
22/10/2018 18:10 21.568 api-ms-win-core-libraryloader-l1-1-0.dll
22/10/2018 18:10 23.080 api-ms-win-core-localization-l1-2-0.dll
22/10/2018 18:10 21.032 api-ms-win-core-memory-l1-1-0.dll
22/10/2018 18:10 20.520 api-ms-win-core-namedpipe-l1-1-0.dll
22/10/2018 18:10 21.544 api-ms-win-core-processenvironment-l1-1-0.dll
22/10/2018 18:10 22.560 api-ms-win-core-processthreads-l1-1-0.dll
22/10/2018 18:10 21.056 api-ms-win-core-processthreads-l1-1-1.dll
22/10/2018 18:10 20.008 api-ms-win-core-profile-l1-1-0.dll
22/10/2018 18:10 21.056 api-ms-win-core-rtlsupport-l1-1-0.dll
22/10/2018 18:10 20.520 api-ms-win-core-string-l1-1-0.dll
22/10/2018 18:10 22.568 api-ms-win-core-synch-l1-1-0.dll
22/10/2018 18:10 21.032 api-ms-win-core-synch-l1-2-0.dll
22/10/2018 18:10 21.544 api-ms-win-core-sysinfo-l1-1-0.dll
22/10/2018 18:10 21.032 api-ms-win-core-timezone-l1-1-0.dll
22/10/2018 18:10 20.520 api-ms-win-core-util-l1-1-0.dll
22/10/2018 18:10 21.544 api-ms-win-crt-conio-l1-1-0.dll
22/10/2018 18:10 24.616 api-ms-win-crt-convert-l1-1-0.dll
22/10/2018 18:10 21.032 api-ms-win-crt-environment-l1-1-0.dll
22/10/2018 18:10 22.568 api-ms-win-crt-filesystem-l1-1-0.dll
22/10/2018 18:10 21.544 api-ms-win-crt-heap-l1-1-0.dll
22/10/2018 18:10 21.032 api-ms-win-crt-locale-l1-1-0.dll
22/10/2018 18:10 29.528 api-ms-win-crt-math-l1-1-0.dll
22/10/2018 18:10 28.736 api-ms-win-crt-multibyte-l1-1-0.dll
22/10/2018 18:10 73.048 api-ms-win-crt-private-l1-1-0.dll
22/10/2018 18:10 21.568 api-ms-win-crt-process-l1-1-0.dll
22/10/2018 18:10 25.128 api-ms-win-crt-runtime-l1-1-0.dll
22/10/2018 18:10 26.664 api-ms-win-crt-stdio-l1-1-0.dll
22/10/2018 18:10 26.664 api-ms-win-crt-string-l1-1-0.dll
22/10/2018 18:10 23.080 api-ms-win-crt-time-l1-1-0.dll
22/10/2018 18:10 21.032 api-ms-win-crt-utility-l1-1-0.dll
05/11/2021 13:15 4.321.768 aria_chk.exe
05/11/2021 13:15 3.902.440 aria_dump_log.exe
05/11/2021 13:15 4.136.936 aria_ftdump.exe
05/11/2021 13:15 4.179.432 aria_pack.exe
05/11/2021 13:15 4.303.336 aria_read_log.exe
23/10/2021 04:18 316.816 concrt140.dll
05/11/2021 13:15 3.455.976 innochecksum.exe
05/11/2021 13:15 15.477.224 mariabackup.exe
05/11/2021 13:15 3.389.928 mbstream.exe
23/10/2021 04:18 565.648 msvcp140.dll
23/10/2021 04:18 23.952 msvcp140_1.dll
23/10/2021 04:18 185.720 msvcp140_2.dll
23/10/2021 04:18 56.208 msvcp140_atomic_wait.dll
23/10/2021 04:18 20.368 msvcp140_codecvt_ids.dll
12/02/2022 19:29 5.776 my.ini
05/11/2021 13:15 3.699.688 myisamchk.exe
05/11/2021 13:15 3.580.904 myisamlog.exe
05/11/2021 13:15 3.599.848 myisampack.exe
05/11/2021 13:15 3.564.520 myisam_ftdump.exe
05/11/2021 13:03 25.746 myrocks_hotbackup
05/11/2021 13:15 3.742.696 mysql.exe
05/11/2021 13:15 3.653.608 mysqladmin.exe
05/11/2021 13:15 3.784.680 mysqlbinlog.exe
05/11/2021 13:15 3.662.824 mysqlcheck.exe
05/11/2021 13:15 16.404.968 mysqld.exe
05/11/2021 13:15 3.737.576 mysqldump.exe
05/11/2021 13:03 8.478 mysqldumpslow.pl
05/11/2021 13:03 25.920 mysqld_multi.pl
05/11/2021 13:03 36.124 mysqlhotcopy.pl
05/11/2021 13:15 3.636.200 mysqlimport.exe
05/11/2021 13:15 3.635.688 mysqlshow.exe
05/11/2021 13:15 3.653.096 mysqlslap.exe
05/11/2021 13:03 8.878 mysql_config.pl
05/11/2021 13:03 4.384 mysql_convert_table_format.pl
05/11/2021 13:15 4.908.520 mysql_install_db.exe
05/11/2021 13:15 3.339.752 mysql_ldb.exe
05/11/2021 13:15 3.374.568 mysql_plugin.exe
05/11/2021 13:15 3.387.368 mysql_tzinfo_to_sql.exe
05/11/2021 13:15 3.478.504 mysql_upgrade.exe
05/11/2021 13:15 3.368.424 mysql_upgrade_service.exe
05/11/2021 13:15 2.658.792 mysql_upgrade_wizard.exe
05/11/2021 13:15 3.379.688 my_print_defaults.exe
05/11/2021 13:15 3.504.616 perror.exe
05/11/2021 13:15 3.357.160 replace.exe
05/11/2021 13:15 1.443.816 sst_dump.exe
22/10/2018 18:10 1.026.088 ucrtbase.dll
23/10/2021 04:18 37.240 vcruntime140_1.dll
88 File(s) 143.030.162 bytes
2 Dir(s) 34.366.013.440 bytes free
C:\xampp\mysql\bin>mysql
ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: NO)
C:\xampp\mysql\bin>mysql -u r --password
Enter password:
ERROR 1045 (28000): Access denied for user 'r'@'localhost' (using password: NO)
C:\xampp\mysql\bin>mysql u -r --password
Enter password:
ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: NO)
C:\xampp\mysql\bin>mysql -u -root --password
Enter password:
ERROR 1045 (28000): Access denied for user '-root'@'localhost' (using password: NO)
C:\xampp\mysql\bin>
C:\xampp\mysql\bin>mysql.exe -u root --password
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 10.4.22-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
+--------------------+
5 rows in set (0.035 sec)
MariaDB [(none)]> CREATE DATABASE db_IMAM;
Query OK, 1 row affected (0.017 sec)
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| db_imam |
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
+--------------------+
6 rows in set (0.002 sec)
MariaDB [(none)]> CREATE DATABASE db_sysebs
->
-> jkjlk
-> jhkh;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near 'jkjlk
jhkh' at line 3
MariaDB [(none)]> CREATED DATABASE db_sysebs;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near 'CREATED DATABASE db_sysebs' at line 1
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| db_imam |
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
+--------------------+
6 rows in set (0.003 sec)
MariaDB [(none)]> CREATE DATABASE db_sysebs;
Query OK, 1 row affected (0.003 sec)
MariaDB [(none)]> drop database db
->
->
-> -djflkadjf;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '-djflkadjf' at line 4
MariaDB [(none)]> drop database db_imam;
Query OK, 0 rows affected (0.070 sec)
MariaDB [(none)]> show database;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near 'database' at line 1
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| db_sysebs |
| information_schema |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
+--------------------+
6 rows in set (0.001 sec)
MariaDB [(none)]> use db_sysebs;
Database changed
MariaDB [db_sysebs]> show tables;
Empty set (0.001 sec)
MariaDB [db_sysebs]> CREATE TABLE tbl_mahasiswa
-> (NIM int(12),
-> Nama_Mhs Varchar(40) Not Null,
-> tgl_lahir date,
-> jekel char(10),
-> Alamat varchar(50));
Query OK, 0 rows affected (0.323 sec)
MariaDB [db_sysebs]> describe tbl_mahasiswa;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| NIM | int(12) | YES | | NULL | |
| Nama_Mhs | varchar(40) | NO | | NULL | |
| tgl_lahir | date | YES | | NULL | |
| jekel | char(10) | YES | | NULL | |
| Alamat | varchar(50) | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
5 rows in set (0.224 sec)
MariaDB [db_sysebs]> INSERT INTO tbl_mahasiswa
-> (NIM, Nama_Mhs, tgl_lahir, jekel, Alamat)
-> VALUES
-> ('2110120011','Imam','2004-04-02','Pria','Jakarta Timur');
Query OK, 1 row affected (0.306 sec)
MariaDB [db_sysebs]> select * from tbl_mahasiswa;
+------------+----------+------------+-------+---------------+
| NIM | Nama_Mhs | tgl_lahir | jekel | Alamat |
+------------+----------+------------+-------+---------------+
| 2110120011 | Imam | 2004-04-02 | Pria | Jakarta Timur |
+------------+----------+------------+-------+---------------+
1 row in set (0.002 sec)
MariaDB [db_sysebs]>
