mariadb - phpmyadmin add "createdb" [SOLVED]

[kreos]

with the is there a way to allow the creation of some (4-5) databases and add them to a single mysql user (mariadb) ?

[Alexander]

Hello,

you could do that manually via the mariadb root login and it should - theroetically - work.

Though i would not recommend it:
- because these databases will not be manageable via KeyHelp (never played through this -> unforeseen issues may occur)
- if one login is compromised, all the other databases are compromised too

Whats wrong with giving each Application their own database ?

[kreos]

Hello
my customers use multiple databases on the same web space.
in example one for the site, one for the mailing list, one for e-commerce ecc.
in example:
https://customerwebsite.xx/index.php (website)
https://store.customerwebsite.xx/index.php (store third level)
https://customerswebsite.xx/mailinglist/index.php (mailinglist area)
https://customerswebsite.xx/crm/index.php (crmarea) .... ecc...

it is good to keep all contents divided but on the same profile (one login and pasword) so when the users open phpmyadmin (or navicat) they find all databases together.
I also tried to do it manually but apache freezed and I had to do a lot of work in ssh to solve

[nikko]

You can use a prefix, if its possible.

[kreos]

You can use a prefix, if its possible.

yeah but the panel require a new user and password

[Tobi]

You can use a prefix, if its possible.

yeah but the panel require a new user and password

Nikko ment that you maybe could use a prefix in your application. That's a common way to share one database with different applications.