--- Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Stephen Liu wrote:
> >> If you want to
> >> get rid of the user entirely, use DROP USER.
> >
> > Could you please explain in more detail??? Where shall I add "DROP
> > USER"
>
> The manual always explains the full syntax (http://dev.mysql.com/),
Stephen Liu wrote:
If you want to
get rid of the user entirely, use DROP USER.
Could you please explain in more detail??? Where shall I add "DROP
USER"
The manual always explains the full syntax (http://dev.mysql.com/), but in
brief,
DROP USER 'vmailuser'@'localhost';
will remove the use
--- Baron Schwartz <[EMAIL PROTECTED]> wrote:
> OK, the privileges are gone. USAGE is a synonym for "no privileges."
Noted with tks.
> If you want to
> get rid of the user entirely, use DROP USER.
Could you please explain in more detail??? Where shall I add "DROP
USER"
> > To safe guard,
Stephen Liu wrote:
mysql> SHOW GRANTS FOR 'vmailuser'@'localhost';
+--+
| Grants for [EMAIL PROTECTED]
Hi Baron,
> > I suppose it has been done ???
>
> Yes, but you can check with SHOW GRANTS FOR 'vmailuser'@'localhost'
> to be sure.
mysql> SHOW GRANTS FOR 'vmailuser'@'localhost';
+
Hi,
Stephen Liu wrote:
Hi Baron,
Tks for your advice.
To undo this GRANT, run
REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
mysql> REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql>
Hi Baron,
Tks for your advice.
> To undo this GRANT, run
>
> REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
> 'vmailuser'@'localhost';
mysql> REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql>
I suppose it has bee
Hi Stephen,
Stephen Liu wrote:
Hi folks,
OpenBSD 4.0 x86_64
Mysql
Postfix_2.4.3
After running following command;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO
'vmailuser'@'localhost' IDENTIFIED BY 'password123';
Query OK, 0 rows affected (0.00 sec)
I found I made a mistake to r
Hi folks,
OpenBSD 4.0 x86_64
Mysql
Postfix_2.4.3
After running following command;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO
'vmailuser'@'localhost' IDENTIFIED BY 'password123';
Query OK, 0 rows affected (0.00 sec)
I found I made a mistake to run it. I need to revoke the GRANT
