MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:February 15 2000 3:40pm
Subject:Re: how to show grants ?
View as plain text  
kev writes:
 > Hi,
 > 
 > I'm reading about authorisation in the manual.
 > I've got to this bit:
 > 
 > 
 > Do mysql -u root. If you granted a connection without asking password,
 > then this is bad.
 >               Use command SHOW GRANTS and check who is having access and
 > to what.
 > 
 > 
 > So I've connected as root, but when I type show grants (tried both upper
 > and lower case), I get this error message:
 > 
 > ERROR 1064: You have an error in your SQL syntax near 'GRANTS' at line 1
 > 
 > 
 > 
 > What am I doing wrong?
 > 
 > thanks,
 > 
 > - Kev
 > 

Hi!

SHOW GRANTS FOR user@host is available since 3.23.4 !

Regards,

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped     |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
how to show grants ?kev15 Feb
  • Re: how to show grants ?sinisa15 Feb