Re: problem with grant

can you send me the link for the english mysql user group, please. I did search a while for this link on mysql.com but did not find any. Thanx in advance, Andy "Jason Wong" <phplist@gremlins.com.hk> schrieb im Newsbeitrag news:php.db-19120@news.php.net... > On Saturday 11 May 2002 19:19, andy wrote: > > Hi there, > > > > I am trying to understand the use of grant. do have some probs. Maybe > > someone can give me hint.. > > > > I did try this command: > > grant all privileges on *.* to mysqladmin@xxx.xxx.xxx.xxx (xxx... = ip > > adress) > > > > Then I did try to connect from this remote machine to the server using this > > user > > The errormsg is: > > Connection failed: > > 1045- Access denied for user: > > mysqladmin@xxx.xxx.xxx.xxx (using password NO) > > > > What's wrong with my grant table statement? Or is there somehow a firewal > > involved? php works with db access. I am running it on suse7.2 > > You're better off asking on the mysql list. > > You do know that the above statement would grant privileges to /ALL/ your > databases to the user mysqladmin connecting at xxx.xxx.xxx.xxx /WITHOUT/ > requiring the use of a password? > > After doing a grant you need to "flush privileges" before it will take effect. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > > /* > Let me do my TRIBUTE to FISHNET STOCKINGS ... > */