RE: [cobalt-users] OT connecting to a mysql database

["Jay Fesco" <jay@xxxxxxxxxxxx>]

> >
> > server configuration denies access to data source
>

You're right, it's OT.  You may want to join the MySQL users list:

   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

That being said, I develop with MySQL and UltraDev as well, but I NEVER
connect directly to my production databases on the Raq from UD.  I emulate
them on localhost, do my testing there, and then upload as needed.

WebMin (www.webmin.com) has a good MySQL module that works well with our
Raq3.  I know there are prettier interfaces available, but the Webmin
version works quite well for my needs (20+ databases at present).  If you
MUST connect from your local machine to your production box (and you don't
have a fixed IP), you will have to create a new MySQL user that allows any
host to connect.  If you DO have a fixed IP, you can define that as the
'allowed host'.  Still, you take the chance of a bad update, insert, or
delete frying your production database.  Be safe, test local.  My $0.02.

Jay Fesco