Using MySQL Text Monitor (Cont.)


MySQL text monitor, the MySQL command-line interface, enables users to manipulate SQL commands. Programmers and DBAs commonly used it as the default available fundamental interface and you do NOT need to set up the environment in order to use it. Useful commands for MySQL text monitor are listed as follows (the cheat sheet can be found from here):
mysql -h undcemmysql.mysql.database.azure.com -u user_id -p
Sign in to MySQL text monitor:
    shell⯈ mysql -h undcemmysql.mysql.database.azure.com -u user_id -p 
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 113
    Server version: 8.0.42-azure Source distribution

    Copyright (c) 2000, 2025, 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>
show databases;
List existing databases:
   mysql> show databases; 
   +--------------------+
   | Database           |
   +--------------------+
   | information_schema |
   | performance_schema |
   | user_id            |
   +--------------------+
   3 rows in set (0.04 sec)
use user_id;
Switch database to use:
   mysql> use user_id; 
   Reading table information for completion of table and
   column names. You can turn off this feature to get a
   quicker startup with -A
   Database changed