Sidar,

> how do i create a user that can connect to any database from any host on my lan....

mysql> GRANT ALL ON *.* TO 'youruser'@'192.168.%' IDENTIFIED BY 'secret';

Assuming your network has IP addresses starting with 192.168.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to