Re: [Sheflug] MySQL access

[Ruth Gunstone <xxxxx [at] xxxxxxxxxxxxxxxxxxxxxxxx>]

In message <3BED48BC.1090701 [at] certus-tech.com>
          Robert Pumphrey <rob.pumphrey [at] certus-tech.com> wrote:

[snip]
> 
> If you telnet to mondas, then try to connect to the mysql database on 
> mondas, you are connecting from localhost not gallifrey. The mysql 
> database has no idea that you have logged on to mondas from gallifrey, 
> it only knows the mysql client is running on mondas.

aahh... of course - obvious - now you've told me :-)

> 
> you could try adding a new entry to your mysql users table:

>  >>>localhost   | ruthie    | wibble     .... the same as above

Unfortunately, that didn't improve the situation, until I finally tracked the
problem to the lack of a 'my.cnf' file :-/

I'd foolishly assumed that as MySQL appeared to be responding, it was
configured 'by default'.

I'll go and RTFM now!!

Thanks again, chaps!

-- 
Ruth Gunstone          (ruth at bolsterstone dot demon dot co dot uk)

 /====================================================\ 
 ||  Web-Site: http://www.bolsterstone.demon.co.uk/  ||
 \====================================================/
___________________________________________________________________

Sheffield Linux User's Group - http://www.sheflug.co.uk . 
To unsubscribe from this list send mail to 
shef-lug-request@list.sheflug.org.uk with the word
"unsubscribe" in the body of the message. 

  GNU the choice of a complete generation.