[ILUG] Re: MySQL

[Mel]

On Tue, 11 Apr 2000, John P. Looney wrote:

> On Tue, Apr 11, 2000 at 01:36:25PM +0100, John P. Looney mentioned:
> >  Ack. How do I add a user to Mysql. I've a user;
> > 
> > 
> >  Any idea what could be wrong ?
> 
>  Mutter. I've been using Oracle too long. Forgot you've to restart the
> database for it to take effect...
> 

I'm reading a backlog so this might have been answered already. Forgive me
if it has

Handiest way is to

GRANT ALL PRIVILEGES on database.* TO user at localhost IDENTIFIED BY 'user'
WITH GRANT OPTION;

GRANT ALL PRIVILEGES on databas.* TO user@% IDENTIFIED BY 'user' WITH
GRANT OPTION;

UPDATE user SET Password = password('testpass') where User ='user';

FLUSH PRIVILEGES;

You don't need to restart the database.