Installed MysQL 5.5.8-win32 January 19, 2011. No-- MySQL 5.5.8 failed. Went back to 5.1. That worked.
|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:
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