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.

[mdc773]

@joseph if i showed you the php script would you be able to tell me where i would do the adjustments

[joseph]

Probably not but you need something like https://github.com/donwilson/Wikipedia-Data-Dump-Parser/blob/28457ddddd25931c2d8a3f9daf62accf7f4a05ab/parse.php#L48

	mysql_query("SET SESSION SQL_MODE='NO_AUTO_VALUE_ON_ZERO'");

Try searching like this https://github.com/search?q=sql_mode+php+SESSION&type=code

[mdc773]

@joseph my issues is the the creator of the script says that

"We recommend disabling it at the time of installation to avoid later database errors. Disabling MySQL Strict Mode requires full root permissions for your server."

so me editing the script isn't possible

anyway i can recreate the LAMP-APP with a git request and tell me what to edit and i can launch my own version of it

[mdc773]

maybe i can fork it and and the changes for Disabling MySQL Strict Mode

[joseph]

@mdc773 the Strict Mode can only be set on the global (whole mysql) level or the session/connection level. There is no way to set this at database level.

We cannot enable NO_AUTO_VALUE_ON_ZERO at the global level. Since this change will then apply to all the apps on Cloudron. This will break things (just like having it disabled breaks your app). AFAIK, there is no way to fix this other then fixing the script itself. Unfortunately, otherwise, you have to host this outside Cloudron since it's not compatible.