Ways to manage DB in MySQL

cs346

Six ways to CREATE and INSERT INTO tables

Mode local remote local remote window window

Where Mysql console

Putty; Mysql console

Mysql console

Putty; Mysql console

WAMP server icon

Link

command CREATE,INSERT

CREATE, INSERT

Source script; or redirection

Source script; or redirection

http://141.233.176.1/phpmyadmin/

Interactive Batch phpMyAdmin

1. Local MySQL Console

• Select WAMPSERVER icon• Select MySQL >MySQL Console

At the prompt for password, just press return (since I was never asked to enter a password on installation of WAMP on my laptop)

Now you are at the MySQL Console and may enter MySQL commands/queries

2. Remotely via putty to cs346 Linux server

login as: studentUbuntu 9.04student@cs346.cs.uwosh.edu's password: System information as of Thu Nov 18 16:00:01 CST 2010 System load: 0.0 Memory usage: 13% Processes: 98 Usage of /: 1.3% of 223.56GB Swap usage: 0% Users logged in: 0 Graph this data and manage this system at https://landscape.canonical.com/ 20 packages can be updated.16 updates are security updates. Last login: Wed Nov 17 19:05:07 2010 from h216-170-137-127.applwi.dedicated.stat ic.tds.net System information as of Thu Nov 18 16:00:01 CST 2010

System load: 0.0 Memory usage: 13% Processes: 98 Usage of /: 1.3% of 223.56GB Swap usage: 0% Users logged in: 0 Graph this data and manage this system at https://landscape.canonical.com/ 20 packages can be updated.16 updates are security updates. student@CS346:~$ /* Now you are in Linux */

student@CS346:~$ mysql -u student -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 235Server version: 5.0.75-0ubuntu10.3 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. Mysql>

/* Now you are in MySQL Console remotely */

mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || student |+--------------------+2 rows in set (0.00 sec) mysql> use student;

3. and 4. Batch

• See Lab10 instructions on the “source” command;

• See the slide “Upload_install_bookorama_tables_to_student_cs346_Linux.doc” on Linux redirection

5. phpMyAdmin on localhost

• Click WAMPSERVER icon• Select phpMyAdmin• A browser window opens with the location:http://localhost/phpmyadmin/

6. phpMyAdmin on cs346 WAMP 141.233.176.1

• On a browser window, type inhttp://141.233.176.1/phpmyadmin/• An authentication pop-up appears for

username and password at the cs346 WAMP server

phpMyAdmin

• The GUI gives you a way to– SELECT * FROM tablename;– CREATE TABLE– DROP TABLE– etc.

•