Getting Started with MySQL Administrator for Metawerx Customers - v1.2


MySQL/Administrator is an open source, downloadable GUI-based tool.

This document describes the use of MySQL/Administrator remotely to connect to and manage your MySQL database.

MySQL Administrator is similar to Microsoft Access or Enterprise Manager and can be used to
manipulate your MySQL database remotely.

This information is intended for use by hosting customers of Metawerx Developer Hosting,
however, it also serves as a useful guide for getting started with MySQL, either
through a secure, encrypted remote connection, or locally for new developers.


CONTENTS


Introduction
Getting started with MySQL Administrator



INTRODUCTION


The metawerx servers are protected using firewalls.  To access the database
servers, you must first connect over "SSH" to establish a secure, encrypted
connection.

Once established, you can safely transfer financial information and other
data to and from the server.

If you are using Linux, you can use the SSH tool which is built into the operating
system.

On Windows, we recommend the use of PuTTY of PLINK.

Please read the PLINK section or PuTTY section of the following guide before
attempting to connect to MySQL.

	SSH (RSync and PuTTY) Info/Tips
	Section 2
	"Starting a connection with PLINK"
	
Make sure PuTTY/PLink is connected and running each time you want to use MySQL
Administrator to connect to your database.

** Hint: If you want to check if PuTTY/PLink is definitely connected, click the
PuTTY/PLink window and hit the ENTER key.  A new $ prompt should show each time
you hit the Enter key.



GETTING STARTED WITH MYSQL ADMINISTRATOR


This tutorial explains how to set up a connection in MySQL Administrator.

First, download and install MySQL Administrator.

	http://www.mysql.com/products/tools/administrator/index.html

Open MySQL Administrator

A dialog box will show up (Register Server)

	Enter the following:
	Name: METAWERX (or any other name you prefer)
	Host Name: localhost
	User Name: (your username, eg: cooljavastuff)
	Password: (your password, eg: myPassword)

Click the [Test] button (located at the bottom of the window).

	If all goes well, it should say "Connection Successful"
	* If this step fails, ensure the PuTTY window is still open.
	* If you want to check if PuTTY is definitely connected, click the PuTTY
	window and hit the ENTER key.  A new $ prompt should show each time you hit
	the Enter key.
	
Save this connection (click [Add])

A section titled "MySQL Servers" will appear on the left of the MySQL Administrator window.
This will have the new connection name in it, marked with a red square, which means
you are not yet connected.

Double click the connection and it should turn into a green triangle (connected ok).
* If this step fails, ensure the PuTTY window is still open.

After double-clicking, a Databases folder will appear, as well as Server
Administration and User Administration.

Drill down into the structure and you should find all of your tables.

Right click a table and select "Open Table" to display all the rows from the table.

The software is similar to Microsoft Access.   You will find you can double click
cells to edit them, insert and delete records.

		

COPYRIGHT NOTICE


All material is (c)Copyright Neale Rudd, Metawerx Pty Ltd, 1997-2014.

If you found this information helpful, additional guides can be found at
http://www.metawerx.net/admin under the 'Resources' link.


END OF DOCUMENT