omlouvam se za OT
potrebuji do jedne databaze v MYSQL pristupovat pouze ze site 192.168.0.0/24 a nevim jak zalozit uzivatele. Pristup z jednoho PC neni problem, pristup ze vsech taky ne.
zkousel jsem
UPDATE  user SET host =  '192.168.0.%' WHERE user =  'pokus';
tak mi to vytvori uzivatele
SELECT user, host, password FROM user where user='pokus';
+-------+-------------+-------------------------------------------+
| user  | host        | password                                  |
+-------+-------------+-------------------------------------------+
| pokus | 192.168.0.% | *AADB89769FF364D8537700AE065872FDA6E980F3 |
+-------+-------------+-------------------------------------------+

z localhosta se pripojim, ale z jineho kompu v siti ne.
status
--------------
mysql  Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.3 (i386) using  5.2

Connection id:          25
Current database:
Current user:           po...@localhost


jak na to
diky
--
FreeBSD mailing list (users-l@freebsd.cz)
http://www.freebsd.cz/listserv/listinfo/users-l

Odpovedet emailem