Using MySQL Text Monitor

  1. Check the MySQL Help Pages.

  2. Apply for a UND Engineering Linux accont.

  3. Use VPN (Virtual Private Network) to connect to the UND networks.
    4.  You may not need to do this if you are on campus.

  4. Log in to the Linux server undcemcs02.und.edu .

  5. Connect to MySQL from the MySQL text monitor.
    6.  Use the following command: 
      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 330
  Server version: 8.0.37-azure Source distribution

  Copyright (c) 2000, 2024, 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>
    You can change your password by using the following command: 
      mysql> set password = old_password("pwpwpwpw"); 
  Query OK, 0 rows affected (0.01 sec)
    where pwpwpwpw is whatever new password you want.

    There may have several databases already created in MySQL. To select the default database, use the following command, for example, 
      mysql> use user_id; 
  Database changed
    where the user_id is the database name assigned by the DBA for you.

    Exiting from MySQL: 
      mysql> exit; 
  Bye

  shell>