super admin
-
I am confused on why when i login to /phpmyadmin right!
why doesn't the default user admin have super admin / sounds silly to me
mysql> SHOW GRANTS FOR '88c17d908c346b02'@'%';
+------------------------------------------------------------------------+
| Grants for 88c17d908c346b02@% |
+------------------------------------------------------------------------+
| GRANT USAGE ON . TO88c17d908c346b02
@%
|
| GRANT ALL PRIVILEGES ON88c17d908c346b02
.* TO88c17d908c346b02
@%
|
+------------------------------------------------------------------------+meanwhile when i attempt to change set SET GLOBAL sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
I get this
MySQL said: Documentation
#1227 - Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation