[plug] MySQL Server only half there

W.Kenworthy billk at iinet.net.au
Mon Mar 20 12:17:20 WST 2006


Start with reading the docs/manual.  If you dont know mysql at the level
of those two files, you need to get up to speed before you do anything
else.

BillK

On Mon, 2006-03-20 at 11:10 +0800, Chris Watt wrote:
> How do I go about finding and checking those files, and what should I
> be looking for in them?
> 
> I'm not particularly savvy with mysql's underside, as I only really
> know how to use it as a database that already works.
> 
> I've never had an install not allow connections before so I'm at a loss!!
> 
> Thanks Guys!
> 
> 
> 
> 
> On 3/20/06, W.Kenworthy <billk at iinet.net.au> wrote:
> > Theres at least two issues depending on how you have set up mysql.
> >
> > my.cnf and mysqlaccess.cnf on the server may need checking (default is
> > usually local access only)
> >
> > And the users table in mysql must allow the user at host to connect.
> >
> > Use the "mysql' client both locally and remotely until you have it
> > worked out, then try other apps as Ive seen issues with other software
> > (encryption).
> >
> > BillK
> >
> >
> > On Mon, 2006-03-20 at 10:26 +0800, Chris Watt wrote:
> > > Hi Guys,
> > >
> > > I've set myself up here so I can experiment with Ruby on Rails with
> > > MySQL.  Problem is, while RoR can connect to it no problem (as can
> > > command line mysqladmin), I can't connect to the server with any
> > > client software (using cocoasql).
> > >
> > > I'm running it on a G5 iMac.  Are there any config errors I need
> > > somewhere?  The error I get is : 192.168.2.3 can't connect to this
> > > server, insufficient privileges (along those lines).
> > >
> > > Also, why is my computer connecting to itself from it's IP nad not
> > > from Localhost/127.0.0.1??
> > >
> > > Cheers Guys
> > > ~Chris
> > > _______________________________________________
> > > PLUG discussion list: plug at plug.org.au
> > > http://www.plug.org.au/mailman/listinfo/plug
> > > Committee e-mail: committee at plug.linux.org.au
> > _______________________________________________
> > PLUG discussion list: plug at plug.org.au
> > http://www.plug.org.au/mailman/listinfo/plug
> > Committee e-mail: committee at plug.linux.org.au
> >
> _______________________________________________
> PLUG discussion list: plug at plug.org.au
> http://www.plug.org.au/mailman/listinfo/plug
> Committee e-mail: committee at plug.linux.org.au



More information about the plug mailing list