Bill's Reference

MySQL  

 

Installed MysQL 5.5.8-win32 January 19, 2011.  No-- MySQL 5.5.8 failed.  Went back to 5.1.  That worked.

Configuration information:

Option Details Last Update
Option TCP/IP  Yes, allowed.  Port #3306 assigned.  Enabled "strict" mode. 2011--01
Service Launch as Windows Service: yes.  Service name: MySQL  
password Root Password: (b3 Z_6)  

How to get into the database?  Run the Command Line Client from the MySQL program grouping.  This will bring up a window with the command prompt.  Then, for example, to see the database "ruby", run:

use ruby;

show tables;

select * from movies;

 

And, voila.  You will see a list of tables, and then a list of rows from the table movies.

To insert a row of data:

insert into movies (id, title, year) values ("0002", "General", "1925");

My installation at CH is "ruby" (server), "ruby" (database) and I have created a table "movies".

 

 

 

All Contents Copyright © Bill Van Dyk
 2010 All Rights Reserved
Font: Verdana