super admin

[mdc773]

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 . TO 88c17d908c346b02@% |
| GRANT ALL PRIVILEGES ON 88c17d908c346b02.* TO 88c17d908c346b02@% |
+------------------------------------------------------------------------+

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

[nebulon]

An app does not get its own database (in this case mysql) instance, but an isolated database on the same mysql instance. So apps do not get superadmin credentials, as they would otherwise be able to potentially interfere with databases from other apps.

[joseph]

Not related to your answer but sql_mode can usually be set at the SESSION level by adjusting your php script.