Re: mysql and users on 2 servers

[wagnerc@plebeian.com (Chris Wagner)]

At 05:51 PM 1/11/2006 +0100, Marek Podmaka wrote:
>  webservers. How can I make it possible for every user to connect
>  also from phpmyadmin? I don't want to have 2 mysql users for each my
>  user (one for eadh webserver IP). If I had read mysql doc right,
>  hosts table is used only in 2nd stage of authorization, so this
>  would allow them to connect from any IP....

I think u want to allow that username to connect from any ip address.  To do
that u put the % wildcard in for the hostname in mysql.  So u create their
account like 'user'@'%'.  This is easy in MySQL control center.





--
REMEMBER THE WORLD TRADE CENTER         ---=< WTC 911 >=--
"...ne cede malis"

00000100