Re: mysqladmin

[Sasha Pachev]

"Roy F. Cabaniss" wrote:
> 
> I am accessing mysql from within php...
> I am using a php form to add users to the database (and add other information
> later.)
> after a user is added I need to run mysqladmin reload to get the new user
> accepted.
> 
> 1) how do I do that from within php3

execute query "flush privileges" -- this will work only on more recent
versions of MySQL ( 3.22)

> 2) how can I make it happen WITHOUT the password
> 

The user you connect as must have the RELOAD privileges, and must
authenticate appropriately  according to your privilege system
configuration. So if you want it to happen without the password, you can
set up a user that has only RELOAD privileges and is allowed to connect
without a password.

> basically i want them to fill out the form.. click a button and shazamm they are
> in
> 
> --
> Dr. Roy F. Cabaniss   Ph.D. in Marketing
> Chairman, Division of Business
> Huston-Tillotson College
> rcaban@stripped        rcaban@stripped
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread6172@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)