Download
ways to manage db in mysql n.
Skip this Video
Loading SlideShow in 5 Seconds..
Ways to manage DB in MySQL PowerPoint Presentation
Download Presentation
Ways to manage DB in MySQL

Ways to manage DB in MySQL

71 Vues Download Presentation
Télécharger la présentation

Ways to manage DB in MySQL

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Ways to manage DB in MySQL cs346

  2. Six ways to CREATE and INSERT INTO tables

  3. 1. Local MySQL Console • Select WAMPSERVER icon • Select MySQL >MySQL Console

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

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

  6. 2. Remotely via putty to cs346 Linux server login as: student Ubuntu 9.04 student@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

  7. 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 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 235 Server 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 */

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

  9. 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

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

  11. 6. phpMyAdmin on cs346 WAMP 141.233.176.1 • On a browser window, type in http://141.233.176.1/phpmyadmin/ • An authentication pop-up appears for username and password at the cs346 WAMP server

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