Tak na tohle jsem jeste prisel, ale mam dalsi lahudku :)
Mam databazi, k ni povoleny pristup z hostu '%' (coz znamena odevsud).
Dokonce to (skoro :))) odevsud chodi - jediny pocitac, ze ktereho se k databazi nejde pripojit je 'localhost' :))
Pristup k databazi je povoleny i v tabulce user, i v db a pokud misto '%' pouziju 'localhost', pripojeni se podari...
A ted, baby, radte :-))
Dovolim si ocitovat kus manualu, cast 6.11 Adding new user privileges to MySQL:
mysql) GRANT ALL PRIVILEGES ON *.* TO monty@localhost
IDENTIFIED BY 'something' WITH GRANT OPTION;
mysql) GRANT ALL PRIVILEGES ON *.* TO monty@'%'
IDENTIFIED BY 'something' WITH GRANT OPTION;
monty A full superuser who can connect to the server from anywhere, but who must use a password ('something' to do so. Note that we must issue GRANT statements for both
monty@localhost and monty@'%'. If we don't add the entry with localhost, the anonymous user entry for localhost that is created by mysql_install_db will take precedence
when we connect from the local host, because it has a more specific Host field value and thuse comes earlier in the user table sort order.
Myslim, ze je to presne ono.
UHLIK) Ano, nekde v te oblasti manualu, kterou cituje Martin Horak je presne toto popsano. Nemam to ted u sebe (ach ty woknouse ;-), ale pokud se pamatuji, neni Vas problem v tom, ze by '%' znamenal vsechny mimo loclhost, '%' znamena podle mne vsechny. Nekde v pravech ale musite mit polozku pro localhost, ktera pristup znemozni. Pri kontrole uzivatele mysql totiz nejprve seradi hosty a usery podle specificnosti, a ridi se prvni nalezenou polozkou pro dany pripad - no a 'localhost' je specifictejsi nez '%'.
Pokud jsem to poplet', nebijte me, ale dejte mi to, prosim, vedet...