Foambats4all: Created page with "Category:Technical Manuals The ''MySQL Workbench'' is a utility that allows HDMs and the tech team to access and edit the database using their credentials. With this utili..."

2015-01-02T22:04:51Z

Created page with "Category:Technical Manuals The ''MySQL Workbench'' is a utility that allows HDMs and the tech team to access and edit the database using their credentials. With this utili..."

New page

[[Category:Technical Manuals]]
The ''MySQL Workbench'' is a utility that allows HDMs and the tech team to access and edit the database using their credentials. With this utility you can access and modify the backend that makes ''A Land Far Away'' persistent, such as search logs and quest variables.

== Installation ==
The Workbench requires the following components before installation:
* [http://www.microsoft.com/download/en/details.aspx?id=17113 Microsoft .NET Framework 4 Client Profile]
* [http://www.microsoft.com/en-us/download/details.aspx?id=40784 Visual C++ Redistributable for Visual Studio 2013]

Once the both of those have been installed, you can grab the workbench itself [http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.2.4-winx64.msi here].

== Configuration ==
Once you have the Workbench opened, configuration can be managed by taking following steps:
* Navigate to '''Database -> Manage Connections''', and click the '''New''' button in the lower left of the window.
* From the '''Connection Method''' dropdown box, select '''Standard TCP/IP over SSH'''.
* Use the '''SSH Username''' and '''SSH Key File''' provided by the [[Infrastructure Administrator]].
* Use the '''Username''', '''Password''', and '''Default Schema''' from the connection information found on the forums. This data should reflect the same information found in the mysql ini file.

Setting Up MySQL Workbench - Revision history

Foambats4all: Created page with "Category:Technical Manuals The ''MySQL Workbench'' is a utility that allows HDMs and the tech team to access and edit the database using their credentials. With this utili..."