MySQL¶

Whitepapers On Integration between MySQL and Office Products¶

These whitepapers will be helpful for Windows users in particular:

• mysql_wp_access_frontends.pdf
• mysql_wp_Excel_guide.en.pdf
• mysql_wp_windows.en.pdf

You can download all of the software from the Oracle web site: http://dev.mysql.com/downloads/

Developing on Windows¶

If you are doing website development on Windows then we recommend that you download the complete integrated set of tools: Apache / MySQL / PHP for Windows. This is usually referred to as the WAMP server package ("W" as in "Windows"). The equivalent LAMP ("L" as n Linux) package is usually either already part of your Linux distribution or can be downloaded through the package manager.

The WampServer website is: http://www.wampserver.com/en/

Developing on Linux¶

Instructions on building a complete virtual machine that includes MySQL can be found at Building a Generic Ubuntu LAMP Server

Using phpMyAdmin To Access The Database¶

Using MySQL Workbench To Access The Database¶

Although you can use phpMyAdmin locally, you cannot readily, due to security constraints, use it to access a remote database such as on a server located on campus. For this, MySQL Workbench is the appropriate solution. It can be downloaded from the MySQL website.

The necessary step to access the remote database is the use of a TCP over SSH connection. This will, within the Workbench, create a secure connection to the server and allow full access to the database. The key is to create a connection configured as shown below:

The key information to note is that in this example:

• the Connection Method has been set to Standard TCP/IP over SSH which changes the rest of the screen to the needed parameters as shown
• the MySQL server is running on mdl-vm1.eng.rpi.edu with anderm8 being a Linux operating system account on that node
• db_user would be the MySQL account needed to access the database
• the passwords are not visible here - they are stored in the keychain to avoid having to re-enter them every time

Note - NOTHING on the Remote Management, System Profile, SSL or Advanced tabs needs to be changed!

From the front page of the Workbench you can now click on this connection and will be connected to your database on the

• dog_collar is the name of the database that db_user has permission to access.

One great feature is that you can export, edit and then import CSV files to help you populate your tables with meaningful data! Be careful if your database structure changers as the old CSV files may no longer work without editing.