[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [cobalt-users] MySQL for different users
- Subject: Re: [cobalt-users] MySQL for different users
- From: jens@xxxxxxxxxxxxxxxxxxxx (Jens Kristian Søgaard)
- Date: Mon Oct 23 12:32:04 2000
- List-id: Mailing list for users to share thoughts on Cobalt products. <cobalt-users.list.cobalt.com>
"Avi Brender" <support@xxxxxxxxxxxxxx> writes:
> The following 2 commands (under the MySQL DB) will allow you to set a user
> to have a specific DB:
You must remember to run this command after running the two others:
FLUSH PRIVILEGES;
But I would indeed say, that you have choosen a bad way of handling
user. It's not "nice" to mess around with the internal tables of
MySQL; it's much more "nice" to use the commands provided by MySQL -
such as the GRANT command (it automatically flushes, so you won't have
to remember that too).
--
Jens Kristian Søgaard, Mermaid Consulting I/S,
jens@xxxxxxxxxxxxxxxxxxxx,
http://www.mermaidconsulting.com/