1 / 16

Ways to manage DB in MySQL

Ways to manage DB in MySQL. cs346. Six ways to CREATE and INSERT INTO tables. 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).

nailah
Download Presentation

Ways to manage DB in MySQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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.

More Related