From Site5Wiki

Contents 1 GUI Methods 1.1 SiteAdmin 1.2 NeoBase 1.3 MySQL Query Browser 1.3.1 Query Browser Video Tutorials for Beginners 1.4 MySQL Administrator 1.4.1 Information for Beginners 1.5 Troubleshooting GUI Connections 2 Command line/Shell Access Methods

GUI Methods

SiteAdmin

1. Log into your Backstage portal and enter the SiteAdmin interface you wish to work with.
2. From the left hand side menu select MySQL Databases and then select Manage Databases.
3. Add your IP address to the Grant database access to a host/IP at the bottom of this page.
4. Once this process is complete, create a new database with which you wish to work.
5. Select Manage Users and create a new MySQL database user account.
6. Grant this newly-created user the necessary access rights to the database in question.

Use these above details to then log into your database from a remote location. When connecting from a remote machine, use your account domain name or IP for the hostname.

NeoBase

NeoBase is the database program for the FOSS office suite NeoOffice, a fork of OpenOffice which runs on OSX. NeoBase can manage MySQL databases from external sources using more than one method, as explained in the NeoOffice wiki.

• Configuring MySQL using JDBC and NeoOffice 2.x
  • MySQL Connector/JDBC, aka the MySQL Connector/J, at mysql.com download link for driver
• Configuring MySQL using ODBC
  • MySQL Connector/ODBC at mysql.com download link for driver

MySQL Query Browser

• information at mysql.com

Query Browser Video Tutorials for Beginners

• Visually Building Queries
• Manually Creating Queries
• Creating a Master Detail View
• Comparing Result Sets
• Editing Queries
• Working with BLOBs
• Export a Result Set

MySQL Administrator

• information at mysql.com
  • [Documentation]

Information for Beginners

• Best practices
• Video tutorial

Troubleshooting GUI Connections

I still can't connect!

Make sure you have granted the database user access to the database and make sure that you are using the correct username, database name and password. These are case sensitive!

Start from scratch and delete the database username previously created. Create a new database user and call it whatever you wish, as an example use "default". Follow the above steps in order including creating a new database user (do not use the default database user) then try again. Contact support if you have continuing troubles.

Command line/Shell Access Methods

The following was written by User:Jablko:

I keep getting the following error trying to connect to MySQL databases from the Site5 SSH shell:

-jailshell-3.00$ mysqldump -u archives_public -p -h localhost archives_ofdevelopment
Enter password: 
mysqldump: Got error: 2002: Can't connect to local MySQL server through

socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
-jailshell-3.00$ 

I found the following forum posts on this topic:

• http://forums.site5.com/showthread.php?t=13104
• http://forums.site5.com/showthread.php?t=9181
• http://forums.site5.com/showthread.php?t=14189

I plan to open a ticket to request a bash shell.
Site5 responded quickly:

I have altered your shell type to Bash to allow for access to the MySQL services.

You will need to log out and back into shell for this change to take effect.

When you enable Get Shell Access in the Site5 Backstage, you by default get a limited shell called jailshell.

Jailshell is part of cPanel's security features; you can read a presentation on it [http://trainingseminar.cpanel.net/slides/tracka/Security%201.pdf in .pdf format, thanks to cpanel.net. --Carla 14:41, 15 August 2007 (EDT)

You get SSH access to this shell, but the jailshell restricts access to MySQL command line tools. The bash shell, on the other hand, provides access to MySQL command line tools:

-bash-3.00$ mysqldump -u archives_public -p -h localhost archives_ofdevelopment
Enter password: 
-- MySQL dump 10.9
--
-- Host: localhost    Database: archives_ofdevelopment
[...]
-bash-3.00$ 

---