November 5, 2011 - Installing MySQL and LibreOffice Base

After several weeks of not working with my virtual machine, it's time to install MySQL Workbench and begin working with databases. I opened my virtual machine, and went directly to the Update Manager. Because it had been a number of days since running the program, it took approximately 35 minutes to install all necessary updates.

When all updates were installed, I opened the Firefox browser and typed in:

www.mysql.com/products/workbench

I clicked the Download Now button

I then select the platform: Ubuntu Linux ver. 11.04 (x86, 32-bit), DEB

And the mirror site: University of Wisconsin/Madison, WI FTP

I selected Save File and waited while the file downloaded.

After the file download was complete, I exited the Downloads dialog box.

I navigated to Places, Downloads where I found the downloaded MySQL file. I double-clicked the mysql-workbench-gpl-5.2.35-1ubu1104-i386.deb folder and clicked the Install button in the window that opened.Once the software was installed, I closed the Ubuntu Software Center window.

I opened MySQl Workbench by navigating to Applications, Programming and clicked New Connection under SQL Development. I typed:

readings

in Connection Name box and left all other settings default: Hostname, Port, Username.

After which, I clicked Test Connection button and a prompt came up to enter my password:

******

A dialog box appeared indicating: Connection parameters are correct.

Next, I went to install LibreOffice Base by going to System, Administration, Synaptic Package Manager. I entered my password and typed libreoffice-base into the Quick Filter search box. I marked it for installation and it indicated the following would also be installed:

libhsqldb-java

Libreoffice-java-common

Libservlet2.5-java

I clicked Apply and the software installed.

Finally, I returned to the Synaptic Package Manager, and typed mysql-client into search box. My results indicated I had mysql-client-5.1 installed, but not mysql-client. I marked it for installation, and clicked Apply.

I am now ready to create databases!