Connect
Entrance to a MySQL server
The Entrance
tree displays a green icon for connected servers, and a light blue icon
for servers that are not connected. In the screenshot below,
"sam" is connected, and "joe" is not connected:
To connect to a
server: select it in the tree, then click the "Connect" tool on
the toolbar.
The first green
server and database in the tree is the default database for executing
SQL scripts. A status message at the bottom of the window tells
you which one this is.
To
change connection settings
Control-click (or
right-click) a server icon in the tree to bring up its popup menu:
and then select "Set
connection properties..." to bring up the Connection Properties dialog:
Here you can change the
connection properties. You can also test them before making them
permanent. The "Display Name" is the label that will appear for
this connection in the Entrance tree. "Host" can be either a host
name or an IP address, eg. 10.0.1.1.
Before you put
sensitive material into a MySQL database you will want to change the
root password. There are details about this on the MySQL web
site, http://www.mysql.com/.
Remember
that when you change a password from a MySQL script, you must change
the password setting for any connections that use that password in
Entrance, too. WARNING: If you
click �€œRemember password�€� your password will be saved between
sessions
as clear text in a system file (The file is
entrance.tree in the system directory)
Add
databases
Use "Add databases..." to
show additional databases in the Entrance tree. You can select
multiple databases in the list box that appears before clicking OK.
You can also use "New
database..." in the Database menu to create a new database on the
current server.
Troubleshooting
Use the "Test" button to
safely test a connection. If the test is successful you will see
a green message, otherwise a red one:
If the test completes
quickly, but fails, you have a problem with the settings. Change
them and try again.
If the test takes more
than a few seconds to complete, there is probably another problem.
In this case, you can click the "Stop" button to stop the test.
Make sure that the network is working on your desktop computer
and that you can you "ping" the remote host.
If the host is another
desktop computer, it may have gone to sleep, or the MySQL server may
may be down.
Please
note: This web page and other Entrance documentation web pages
are copyrighted material and have not been released under the terms of
the GPL.
Copyright
(c) Tod Landis 2006,2007 All Rights Reserved
Modified: June 15, 2007
Java
and the Java Coffee Cup Logo are trademarks or registered trademarks of
Sun Microsystems, Inc. in the U.S. and other countries. Solaris
is a trademark of Sun Microsystems, Inc. MySQL is a registered
trademark of MySQL AB in the United States, the European Union and
other countries. Windows is a trademark of Microsoft Corporation.
Macintosh is a trademark of Apple Computer, Inc.