RE: [PHP-DB] mysql database not 'taking' changes
| From: | Mark | Date: | Mon, 23 Dec 2002 21:07:52 +0000 |
| Subject: | RE: [PHP-DB] mysql database not 'taking' changes | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24355@lists.php.net to get a copy of this message | ||
--- Jody Cleveland <Cleveland@mail.winnefox.org> wrote:
> > Sorry. Stupid technospeak on my part.
>
> No problem, much ignorance on my part.
>
> > When you connect to the database, you tell it to use a particular
> > username and password. When these new tables were created, did
> you
> > change the permissions in the mysql table for the user, or does
> that
> > account have access to all the tables/databases? Basically, did
> you
> > grant or change permissions when the new tables were created?
>
> I created a database called squirrelmail. I was logged in as root
> when I
> created it, but after I created the database, I typed:
> GRANT select,insert,update,delete ON squirrelmail.* TO
> squirreluser@localhost IDENTIFIED BY 'sqpassword';
>
> > BTW, CRUD = Create, Read, Update, Delete
>
> I was wondering what that meant!
>
> It looks like the changes take now, but I have to logout of
> squirrelmail and
> log back in for them to take effect. Any ideas?
Not to punt, but you might want to check with the Squirrelmail folks
to see if that's normal behavior. I don't use it personally, but I
can refer you to a few people who do if no one on this list knows...
>
> Thanks!
>
> Jody
=====
Mark Weinstock
mark_weinstock@yahoo.com
***************************************
You can't demand something as a "right" unless you are willing to fight to death to
defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***************************************
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com