Of course you still have to trigger a reload.
You can do a $dbh->do("FLUSH PRIVILEGES"); for that though..Just my 2 pence (Some of us europeans can't) Jon >AFAIK the mysqladmin tool doesn't really do anything else than alter the >predefined database called mysql that's in charge of all the >configuraton of the other databases - why not simply alter that DB with >the DBI? i think the mysql docs describe the db-structure in more >detail... > >just my two cents (ha! finally us europeans can say that, too! :-) > >M. > >> -----Original Message----- >> From: William R Ward [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, March 07, 2002 5:41 PM >> To: [EMAIL PROTECTED] >> Subject: mysqladmin tasks from Perl? >> >> >> >> I have passwords enabled in my MySQL server, and it's rather >> unpleasant having to deal with the mysqladmin program from a >> Perl script. For example, installing the software means you >> have to create the database that it uses, which requires a >> separate password command. Is there any way to do these >> tasks through DBD::msyql? >> >> --Bill. >> >> -- >> William R Ward [EMAIL PROTECTED] >> http://www.wards.net/~bill/ >> >> -------------------------------------------------------------- >> --------------- >> If you're not part of the solution, you're part of the >> precipitate. >> > >
