OT-prihlaseni do mysql z dane site

Jaroslav Votruba jaroslav.votruba at keytec.cz
Wed Mar 4 08:04:07 CET 2009


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:           pokus at localhost


jak na to
diky


More information about the Users-l mailing list