--- 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
--- 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,
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 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
replace [, user] with [, vmailuser]???
Please shed me some light. TIA
B.R.
Stephen Liu
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- Chris <[EMAIL PROTECTED]> wrote:
- snip -
> So you *have* set the root password before.
>
> From your previous emails:
>
> # mysqladmin -u root password yourrootsqlpassword
>
> That set the password to "yourrootsqlpassword".
>
>
>
> If you need to reset it, see documentation:
>
> http
--- Chris <[EMAIL PROTECTED]> wrote:
- snip -
> Try this:
>
> mysqladmin -u root password xyz
>
> That will change your password to 'xyz'.
>
Before received this email I tried;
[EMAIL PROTECTED] ~]# mysqladmin -u root -p
mysqladmin Ver 8.41 Distrib 4.1.20, for redhat-linux-gnu on x86_64
Co
; > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user 'root'@'localhost' (using password:
> YES)'
> > * end *
>
> That is asking for your *old* password.
I did not create any password before.