[plug] MySQL Server only half there

[Chris Watt]

I've been reading the manuals and docs for about 2 days and still
haven't found bits useful to me.  Thought I had but it was windows
only, not applicable to unix/osx

Can anyone point me to a useful article?




On 3/20/06, W.Kenworthy <billk at iinet.net.au> wrote:
> 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
> _______________________________________________
> 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
>