[thelist] [mySQL] user admin help please!

Chris Johnston fuzzylizard at gmail.com
Mon Aug 16 19:52:41 CDT 2004


On Mon, 16 Aug 2004 16:38:44 -0700 (PDT), Tom Dell'Aringa
<pixelmech at yahoo.com> wrote:
> 
> I'm trying to use mySQL Administrator as the GUI for this. It seems I can add a user just fine. I
> then add 'localhost' as the host to connect to. (The other choice seems to be 'build' and I have
> no idea what that is). Yet that account does not work, because changing my DB connection to that
> user/pw name throws a connection error.

Just adding a user is not enough. The only time that MySQL reads the
user/host/db tables is when it first starts up. This means that for a
new user to be recognized you need to either restart the server or
issue the following command:

FLUSH PRIVILEGES;

This will cause mysql to reread all the control tables and your new
user will be recognized.

In addition, In MySQL administrator, in addition to adding a user and
a host, you also need to assign permissions on a per database basis
and a per host basis. There is a tab that allows you to do this in the
section under Users. Select a user, then select a host for that user,
click on the tab and select a DB and select the priveleges for that
user.

And then either restart the server or issue the flush privileges command.

http://dev.mysql.com/doc/mysql/en/FLUSH.html

Hope that helps.

-- 
chris johnston

www.fuzzylizard.com
"For millions of years, mankind lived just like the animals and
something happened which unleashed the power of our imagination, we
learned to talk."
Pink Floyd


More information about the thelist mailing list