OK, but how do I do that. I'm sorry if I sound dumb, but I've had to
mess with command line utilities 3 times since windows was release so I
am more than a little rusty (it took me 4.5 hours to get mySQL online).
As I said before, I am able to connect to the db server from my machine
using mySQL-Front (graphic db admin tool), so I must have allowed the
remote access when I did my original install.
Cutter
Steven Erat wrote:
> MySQL has default security restrictions that typically don't allow remote
> 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]
- SOT: BD 6.1 and mySQL Cutter (CF-Talk)
- Re: SOT: BD 6.1 and mySQL Jochem van Dieten
- Re: SOT: BD 6.1 and mySQL Cutter (CF-Talk)
- Re: SOT: BD 6.1 and mySQL Jochem van Dieten
- Re: SOT: BD 6.1 and mySQL Cutter (CF-Talk)
- Re: SOT: BD 6.1 and mySQL Jochem van Dieten
- Re: SOT: BD 6.1 and mySQL Cutter (CF-Talk)
- RE: SOT: BD 6.1 and mySQL Steven Erat
- RE: SOT: BD 6.1 and mySQL Cutter (CF-Talk)
- RE: SOT: BD 6.1 and mySQL Vince Bonfanti
- Re: SOT: BD 6.1 and mySQL Cutter (CF-Talk)
- RE: SOT: BD 6.1 and mySQL Vince Bonfanti