[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] MySQL for different users



"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/