Paul Linehan writes:
>
>
> OK - fair enough - two questions though.
>
>
> Can I just hand delete the records that I manually inserted?
>
If you are brave and sure in yourslef.
>
> What is the syntax of the grant?
>
This is properly described in our fine manual.
>
> I log on as the roo
> > Is it wrong to hand edit these tables? root with the
> > password "new_password" is a valid logon for this db.
> Don't touch MySQL privilege tables, except host table.
> That way you just mess up the things, as you did.
> Use GRANT / REVOKE / SET PASSWORD ..
OK - fair enough - two q