Re: mysql access setup

["Matias Rollan" <cygar@safesource.com.ar>]

Hola !
On Sun, May 15, 2005 at 08:20:37AM -0400, stan wrote:
> I need to make mysql accessable from all machines on my network.
> 
> How do I do this under Debian?

The same as under other distribution. :)

> 
> Curently if I just do "mysql" on the machine I've installed it on,
> I get connected, but if I do "mysql -h foo" even on foo, I get:
> 
> ERROR 1045: Access denied for user: 'stan@panda' (Using password: NO)
> 
> What do I need to do to fix this?

You need that "stan" user be allowed to access from other places besides
"localhost" [ you can take a look at mysql.user table where stan user
is allowed to access to mysql just from localhost].

i.e: to be able to log from anywhere:
		
		mysql> GRANT ALL PRIVILEGES ON *.* TO 'stan'@'%' IDENTIFIED BY
		'yourpasswd';

		To be able to log from your local network [192.168.1.0/24] just
		replace '%' to '192.168.1.%'.

Saludos !
-- 
  Matías Rollán
  <cygar@safesource.com.ar>