Enter password: *******

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 8
Server version: 8.0.26 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

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> use empd

ERROR 1049 (42000): Unknown database 'empd'
mysql> use empd;
ERROR 1049 (42000): Unknown database 'empd'
mysql> use dhruv_a
Database changed
mysql> show tables
-> ;
+-------------------+
| Tables_in_dhruv_a |
+-------------------+
| employee |
| marksheet |
+-------------------+
2 rows in set (0.09 sec)

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| aritro |
| army |
| bts |
| cha |
| childern |
| class |
| class1 |
| com |
| confectionary |
| cus_details |
| cust_details |
| dhruv_a |
| dudu |
| emp |
| emp_table |
| employee |
| exam2 |
| exam3 |
| fd |
| harsh |
| info |
| information_schema |
| jimin |
| manager |
| mayur |
| music |
| mysql |
| nono |
| office |
| performance_schema |
| poopoo |
| result |
| root |
| royalclothing |
| ruhaan |
| sakila |
+--------------------+
36 rows in set (0.01 sec)

mysql> drop sakila

-> ;
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 'sakila'
at line 1
mysql> drop database sakila;
Query OK, 23 rows affected (0.58 sec)

mysql> drop database ruhaan;

Query OK, 0 rows affected (0.01 sec)

mysql> drop database royalclothing;

Query OK, 1 row affected (0.04 sec)

mysql> drop database root;

Query OK, 0 rows affected (0.01 sec)

mysql> drop database result;

Query OK, 1 row affected (0.03 sec)

mysql> drop database poopoo;

Query OK, 0 rows affected (0.01 sec)

mysql> drop database performance_schema;

ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database
'performance_schema'
mysql> use performance_schema;
Database changed
mysql> show table;
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> show tables;
+------------------------------------------------------+
| Tables_in_performance_schema |
+------------------------------------------------------+
| accounts |
| binary_log_transaction_compression_stats |
| cond_instances |
| data_lock_waits |
| data_locks |
| error_log |
| events_errors_summary_by_account_by_error |
| events_errors_summary_by_host_by_error |
| events_errors_summary_by_thread_by_error |
| events_errors_summary_by_user_by_error |
| events_errors_summary_global_by_error |
| events_stages_current |
| events_stages_history |
| events_stages_history_long |
| events_stages_summary_by_account_by_event_name |
| events_stages_summary_by_host_by_event_name |
| events_stages_summary_by_thread_by_event_name |
| events_stages_summary_by_user_by_event_name |
| events_stages_summary_global_by_event_name |
| events_statements_current |
| events_statements_histogram_by_digest |
| events_statements_histogram_global |
| events_statements_history |
| events_statements_history_long |
| events_statements_summary_by_account_by_event_name |
| events_statements_summary_by_digest |
| events_statements_summary_by_host_by_event_name |
| events_statements_summary_by_program |
| events_statements_summary_by_thread_by_event_name |
| events_statements_summary_by_user_by_event_name |
| events_statements_summary_global_by_event_name |
| events_transactions_current |
| events_transactions_history |
| events_transactions_history_long |
| events_transactions_summary_by_account_by_event_name |
| events_transactions_summary_by_host_by_event_name |
| events_transactions_summary_by_thread_by_event_name |
| events_transactions_summary_by_user_by_event_name |
| events_transactions_summary_global_by_event_name |
| events_waits_current |
| events_waits_history |
| events_waits_history_long |
| events_waits_summary_by_account_by_event_name |
| events_waits_summary_by_host_by_event_name |
| events_waits_summary_by_instance |
| events_waits_summary_by_thread_by_event_name |
| events_waits_summary_by_user_by_event_name |
| events_waits_summary_global_by_event_name |
| file_instances |
| file_summary_by_event_name |
| file_summary_by_instance |
| global_status |
| global_variables |
| host_cache |
| hosts |
| keyring_component_status |
| keyring_keys |
| log_status |
| memory_summary_by_account_by_event_name |
| memory_summary_by_host_by_event_name |
| memory_summary_by_thread_by_event_name |
| memory_summary_by_user_by_event_name |
| memory_summary_global_by_event_name |
| metadata_locks |
| mutex_instances |
| objects_summary_global_by_type |
| performance_timers |
| persisted_variables |
| prepared_statements_instances |
| processlist |
| replication_applier_configuration |
| replication_applier_filters |
| replication_applier_global_filters |
| replication_applier_status |
| replication_applier_status_by_coordinator |
| replication_applier_status_by_worker |
| replication_asynchronous_connection_failover |
| replication_asynchronous_connection_failover_managed |
| replication_connection_configuration |
| replication_connection_status |
| replication_group_member_stats |
| replication_group_members |
| rwlock_instances |
| session_account_connect_attrs |
| session_connect_attrs |
| session_status |
| session_variables |
| setup_actors |
| setup_consumers |
| setup_instruments |
| setup_objects |
| setup_threads |
| socket_instances |
| socket_summary_by_event_name |
| socket_summary_by_instance |
| status_by_account |
| status_by_host |
| status_by_thread |
| status_by_user |
| table_handles |
| table_io_waits_summary_by_index_usage |
| table_io_waits_summary_by_table |
| table_lock_waits_summary_by_table |
| threads |
| tls_channel_status |
| user_defined_functions |
| user_variables_by_thread |
| users |
| variables_by_thread |
| variables_info |
+------------------------------------------------------+
110 rows in set (0.01 sec)

mysql> select* from data_locks;

Empty set (0.02 sec)

mysql> select* from data_locks_waits;

ERROR 1146 (42S02): Table 'performance_schema.data_locks_waits' doesn't exist
mysql> select* from data_locks_waits;
ERROR 1146 (42S02): Table 'performance_schema.data_locks_waits' doesn't exist
mysql> select* from data_lock_wait
-> ;
ERROR 1146 (42S02): Table 'performance_schema.data_lock_wait' doesn't exist
mysql> select* from data_lock_wait ;
ERROR 1146 (42S02): Table 'performance_schema.data_lock_wait' doesn't exist
mysql> select* from data_lock_wait ;
ERROR 1146 (42S02): Table 'performance_schema.data_lock_wait' doesn't exist
mysql> select* from data_lock_wait ;
ERROR 1146 (42S02): Table 'performance_schema.data_lock_wait' doesn't exist
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| aritro |
| army |
| bts |
| cha |
| childern |
| class |
| class1 |
| com |
| confectionary |
| cus_details |
| cust_details |
| dhruv_a |
| dudu |
| emp |
| emp_table |
| employee |
| exam2 |
| exam3 |
| fd |
| harsh |
| info |
| information_schema |
| jimin |
| manager |
| mayur |
| music |
| mysql |
| nono |
| office |
| performance_schema |
+--------------------+
30 rows in set (0.00 sec)

mysql> drop bts;

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 'bts' at
line 1
mysql> drop database bts;
Query OK, 1 row affected (0.05 sec)

mysql> drop database army;

Query OK, 1 row affected (0.03 sec)

mysql> drop database aritro;

Query OK, 1 row affected (0.03 sec)

mysql> drop database cha;

Query OK, 0 rows affected (0.01 sec)

mysql> drop database children;

ERROR 1008 (HY000): Can't drop database 'children'; database doesn't exist
mysql>
mysql> drop database childern;
Query OK, 1 row affected (0.03 sec)
mysql> drop database class;
Query OK, 1 row affected (0.03 sec)

mysql> drop database class1;

Query OK, 1 row affected (0.03 sec)

mysql> drop database con

-> ;
ERROR 1008 (HY000): Can't drop database 'con'; database doesn't exist
mysql> drop database com;
Query OK, 1 row affected (0.03 sec)

mysql> drop database confectionery;

ERROR 1008 (HY000): Can't drop database 'confectionery'; database doesn't exist
mysql> drop database confectionary;
Query OK, 0 rows affected (0.01 sec)

mysql> drop database cus_details;

Query OK, 1 row affected (0.06 sec)

mysql> drop database cust_details;

Query OK, 0 rows affected (0.01 sec)

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| dhruv_a |
| dudu |
| emp |
| emp_table |
| employee |
| exam2 |
| exam3 |
| fd |
| harsh |
| info |
| information_schema |
| jimin |
| manager |
| mayur |
| music |
| mysql |
| nono |
| office |
| performance_schema |
+--------------------+
19 rows in set (0.01 sec)

mysql> drop database dudu;

Query OK, 0 rows affected (0.01 sec)

mysql> drop database emp;

Query OK, 2 rows affected (0.04 sec)

mysql> drop database emp_table;

Query OK, 1 row affected (0.03 sec)
mysql> drop database employee;
Query OK, 3 rows affected (0.06 sec)

mysql> drop database exam2;

Query OK, 1 row affected (0.02 sec)

mysql> drop database exam3;

Query OK, 0 rows affected (0.01 sec)

mysql> drop database fd

-> ;
Query OK, 0 rows affected (0.01 sec)

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| dhruv_a |
| harsh |
| info |
| information_schema |
| jimin |
| manager |
| mayur |
| music |
| mysql |
| nono |
| office |
| performance_schema |
+--------------------+
12 rows in set (0.01 sec)

mysql> drop database info;

Query OK, 1 row affected (0.06 sec)

mysql> drop database information_schema

-> ;
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database
'information_schema'
mysql> drop database jimin;
Query OK, 1 row affected (0.02 sec)

mysql> drop database manager;

Query OK, 0 rows affected (0.01 sec)

mysql> drop database mayur;

Query OK, 1 row affected (0.06 sec)

mysql> drop database music;

Query OK, 2 rows affected (0.04 sec)

mysql> drop database mysql;

ERROR 3552 (HY000): Access to system schema 'mysql' is rejected.
mysql> drop database nono;
Query OK, 0 rows affected (0.01 sec)

mysql> drop database office

-> ;
Query OK, 1 row affected (0.03 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| dhruv_a |
| harsh |
| information_schema |
| mysql |
| performance_schema |
+--------------------+
5 rows in set (0.01 sec)

mysql> drop database harsh;

Query OK, 0 rows affected (0.01 sec)

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| dhruv_a |
| information_schema |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

mysql> use dhruv_a;

Database changed
mysql> select* from employee;
+------+--------+---------+--------+
| ENO | ENAME | JOB | SALARY |
+------+--------+---------+--------+
| 1001 | Adam | doctor | 150000 |
| 1002 | Amaal | Enginer | 165000 |
| 1003 | Ali | doctor | 180000 |
| 1004 | simran | Manager | 125000 |
| 1005 | Rabil | Enginer | 185000 |
+------+--------+---------+--------+
5 rows in set (0.04 sec)