Re: [Sheflug] MySQL access

[Robert Pumphrey <xxxxx [at] xxxxxxxxxxxxxxx>]

Where are you connecting from? With this privilige you can only connect 
from gallifrey, so on gallifrey you should use the standard mysql client 
with the following arguments
mysql -u ruthie -hmondas -pwibble

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.

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

 >>>Host        | User      | Password	 . . . (lots of priv options)
 >>>gallifrey   | ruthie    | wibble        . . .(all set to 'Y')
 >>>localhost   | ruthie    | wibble     .... the same as above


Rob



Ruth Gunstone wrote:

> 
>>>Host        | User      | Password	 . . . (lots of priv options)
>>>gallifrey   | ruthie    | wibble        . . .(all set to 'Y')
>>>
>>>
> [snip]
> 
> 
> 
> 


___________________________________________________________________

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.