[plug] MySQL Server only half there

[W.Kenworthy]

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