[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

mysql access setup



 


> I need to make mysql accessable from all machines on my network.
> How do I do this under Debian?
> 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)

GRANT ALL PRIVILEGES ON YourDB.*
TO stan@'%';
flush priviledges;

By the way, its better to keep a host, user and database access level ACL
Cheers

Shatam Bhattacharya
New Delhi,
India
 



Reply to: