MySQL Review (Part 2)

Introduction

a-Workbench_Opening-screen_2

http://dev.mysql.com/doc/workbench/en/  Here, I at long last can proudly present the accoutrements necessary to get your: ‘MySQL’ easily up and running!  Please bare in mind that this new program is exactly what you need, on a very user friendly bases; the program itself is practically intuitive of what you need!  It actually told me that I didn’t have MySQL set up in my configuration file, for the entire web-site, and asked me if I would like like Workbench to set it up for me!  Naturally, I said ‘Yes!’ 

This program is awesome!  The screen capture of the Workbench opening screen, reveals an icon at the top, entitled: ‘MySQL Doc Library’. It will bring you to this help file.  The site above, is where you may download the program from, and find more documentation about Workbench, among other things; be sure and bookmark it for easy reference.

I will take you through the 3 step process of getting hooked up to your remote host, as pictured above, in order of sequence: SQL Development, Data Modeling, and Server Administration…  Before we begin, I must explain a few things.  To begin with, the above interface, is what you’re supposed to get.  And you probably will!

a-Workbench_Opening-screen

This is what I got…

LOL!  This is because, as it turns out for me, that although this program is so easy to use, that I blindly went through the entire process, and still came out with a working server at the other end!  The program practically guides you through it!  I don’t get the graphic interface because Workbench tells me that this virgin of Workbench is incompatible with my local host.  There were no tabs when I got it, other than home, and only the sample model icon at the bottom.  On the porpoise, WordPress.org didn’t exist, and the three icons: root, phpmyadmin, and local host 3306 weren’t there either.

I’m using Apache 2.2 which came with: WordPress.org 3.6.1 download.  Since this program, Workbench is fairly new, I don’t foresee any problem, if you download the latest site that WordPress.org is presently offering.  The first icon on the bottom entitled: ‘My Workbench’ is my own model I made, using the ‘Models’ plus button directly above the icon; once you open this path, it will give you the first tab besides home, through which, you can set up as many models as you need…  So let’s begin…

a-Workbench_MySQL_Model

SQL Development (Step1)

Workbench needs to create a ‘Model’ of the MySQL database that resides on your system, after extracting your server and virgin of WordPress…  To do this, it needs to know the path to your: ‘phpmyadmin’ folder.  The Model button will open up a dialog box to your system for this porpoise.  It brings up all these user type tags shown on your bottom left.  The bottom box is where you name your new ‘schema’  Emmm…  This word might be shot for ‘schematics’ or, diagrams.  Simply type a name provided in the ‘Name’ field.  See the little, gold barrel that says: ‘new_schema1’?  I created that, simply by pressing the little, gold icon listed just below the menu structure.  You may then design table structure for this schema.

Those tiny, blue icons you see under the phpmyadmin tab, are all tables…  These ‘tables’ are featured in your EER Diagram tab shown up top

a-Workbench_Path

The path should look something like the screenshot above…  Just choose the folder.  If for some reason, this folder doesn’t fire it up, try: ‘mysql’, listed in the same folder structure…

Data Modeling (Step 2)

a-Workbench_EER-Diagram-Tables

You might want to spread out your tables a little better than I have here. Just grab the blue header and position to provide room for those funny, little arrows you see taking up half of the tool-bar on the left.  They are ‘relationship’ connectors.  These tables describe dimensions and position only.  They are also connected to real images that will display on your web-site.  These images are available to be brought up in your graphics program with just a click.  If you’d like to see what each one looks like, they’re in the mysql folder I mentioned earlier.  All the parameters of your tables are completely customizable…

Looking to your upper right, there are three more tables that you can include: ‘Timestamps, User, and Category.’  Just double click them and they will appear in your diagram.  As pictured above, I selected the ‘User’ table, and furnished it with a more useful name: ‘Personal Info’.  By double clicking the table header, you get this box below, with many tabs.  The checked ‘NN’ check-boxes just means ‘Not Null’… If you choose the ‘index’ tab, one will appear below your table (featured in grey).  I have also made a trigger for it, simply by choosing the trigger tab. Right click a trigger, and choose ‘delete to remove one.  The good news is, Your ERR diagram comes up automatically, tables and all, when you first set up your model!  So cool! I will show you a more complete layout later…  On to the final step…

Server Administration (Step 3)

a-Workbench_local-host-connect

This is so easy, you won’t believe it!  What you see above is the third tab created simply by going into your ‘Server’ menu and choosing: ‘Connect to Server’. And this is called: ‘The MySQL Editor’.  Anytime I try to access any of the management selections on the left, I get this dialog box.  Never-the less, it still has in fact, connected with my Server!  And this interface, I am certain, connects your Server, now alive and kicking, to your remote server on WordPress.org, and is for organizing pages, tables, scripts, headers, footers, images, etc.. you will place there…

Not to forget, Dreamweaver told me that my virgin of php wasn’t working.  And this can’t be true or Workbench wouldn’t have been able to work with phpmyadmin.  Also, my virgin of WordPress.org came with an empty config. file, and that is the only reason mine can’t talk to the remote server yet.  The info. to fill in your config. file, just incase you don’t get one either, resides on The WordPress forum… So there you have it, fast, simple, efficient, and here is your MySQL, fully configured and ready to rock!

There are actually two fully FREE virgins of MySQL Workbench: The commercial brand and the Enterprise one.  You want the commercial brand.  As an added bonus, there is no time limit upon how long you explore this user friendly, feature rich program!  There are also Utility packages that will help you with scripting etc..

A Complete Workbench Model

a-Workbench_Working_Model

Notice how all the tables here have interconnections and now belong in their own categories, such as: Customer Data, Inventory, Business and Views.  The files in ‘Views’ are not connected because they are not tables…  The color schemes really help!

Preferences

a-Workbench_Preference_Dialog_Box

You may explore the preferences dialog box (accessible through the ‘Edit’ menu) all you like, when you have time and figure more out about what you’re doing.  Mean-while, there’s something with it you absolutely must do!  The program will only open at first boot, and never again until next boot, unless you check the: ‘Automatically reopen previous model at start’. check-box!

http://www.mysql.com/products/workbench/  This help file runs you through Workbench 6.0.  I sincerely believe this program will greatly help ease the process of getting your server recognized by your remote one!   Perhaps this program is so much easier to work with than Dreamweaver CS3, because the CS3 model for the server is just out of date.  Whatever the reason, if you want to hook up to your web-site, MySQL Workbench is just the program for you!  There you go!  Your very own connection program that actually works in: The Kings Own English…

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s