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