Connecting to MySQL from the MySQL text monitor of the Unix server such as undcemcs02.und.edu
Use the following command:
undcemcs02> mysql -h undcsmysql.mysql.database.azure.com -u userid -p
Enter password:
Logining into MySQL
Now you can start MySQL applications.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.1.73 Source distribution
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.
Selecting the default database
There may have several databases already created in MySQL.
To select the default database, use the following command, for example,
mysql> use wenchen;
Database changed
where the wenchen is the database name assigned to the instructor.
The MySQL DBA will create another database for you.
Exiting from MySQL
mysql> exit;
Bye
undcemcs02>
