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 -
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.
-
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
-
@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
-
maybe i can fork it and and the changes for Disabling MySQL Strict Mode
-
@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.