Re: Mysql

[Raju Mathur <raju@xxxxxxxxxxxxxxx>]

Hi Amit,

I guess there're atleast a couple of other ways of accomplishing this
apart from what you've outlined:

1. Let the script have root access to MySQL.  Alternatively, let the
script have full rights through a special user-ID on the table.

2. Let the user have full rights on the table.

There shouldn't be a problem with permissions since all updates will
be done under control of your program.

Regards,

-- Raju

>>>>> "Amit" == Amit Soni <amitsoni@xxxxxxxxxxxx> writes:

    Amit> Ok, we'll see about the fight in the meet.  for now..help me
    Amit> ! ;o)

    Amit> I wanna setup a very simple database of user infomation
    Amit> name,address, email etc in mysql.

    Amit> Now The passwords for this db i wanna store in mysql(lemme
    Amit> know of a better way)

    Amit> Now once the user has created an account. suppose he wants
    Amit> to change some info.

    Amit> Now since Mysql does not permit.row based user
    Amit> rights.(minimum is table based)

    Amit> what i do is.....I create a temp table in the db with his
    Amit> session id. give him insert/delete/select etc rights on this
    Amit> table.  and he can right to this table and then later on the
    Amit> content s will be transfered to....the main table.

    Amit> Is there a better way of accomplishing this ?

    Amit> What i wanna avoid is. To create the temp table i have to
    Amit> print the username and password of one user in my cgi
    Amit> application.

    Amit> What i want is that a user in mysql should be such that..
    Amit> 1. He can Insert into the userinformation table.  2. He can
    Amit> modify the contents of all coloumns in userinfomation table
    Amit> where userid=hisuserid.

    Amit> I am sure all web programmers here must have done such a
    Amit> thing. Since i am a bit weak in databases. please help me.
-- 
Raju Mathur          raju@xxxxxxxxxxxxx           http://kandalaya.org/