hosts to connect. A quick and dirty test would be to modify the mysql start
script and add an argument for --skip-grant-tables such as:
$bindir/safe_mysqld --skip-grant-tables --datadir=$datadir . . . Then
restart mysqld.
If that works, then the more graceful solution is to first remove that
argument then adjust the grant tables on the databases used from the remote
host.
HTH
_____
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 06, 2004 1:16 PM
To: CF-Talk
Subject: Re: SOT: BD 6.1 and mySQL
Now we're outside my realm of experience. My mySQL db is on a seperate
server. I can connect to it via the CF dev server and mySQL Control
Center on that same machine, as well as mySQL-Front on my personal
system. I have double checked what I thought to be the pertinent
variables (mySQL server IP, db name, un & pw), and even
uninstalled/reinstalled BD + below said instructions to start over from
scratch. No luck as yet.
Cutter
Jochem van Dieten wrote:
> Cutter (CF-Talk) wrote:
> > When I set up a mySQL datasource and go to verify that connection it
> > returns the following error:
> >
> > verifying (insert db name here)...
> > General SQL Error
> >
> > I followed the instructions from the following BD FAQ file:
> >
> >
>
http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faq
Id=216
<http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?fa
qId=216>
>
> Can you connect using the MySQL command line tool from the same
> host using the same parameters?
>
> Jochem
>
> --
> I don't get it
> immigrants don't work
> and steal our jobs
> - Loesje
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
