mariadb - phpmyadmin add "createdb"  [SOLVED]

Locked
User avatar
kreos
Posts: 7
Joined: Thu 10. Jan 2019, 00:07

mariadb - phpmyadmin add "createdb"

Post by 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) ?
User avatar
Alexander
Keyweb AG
Posts: 3810
Joined: Wed 20. Jan 2016, 02:23

Re: mariadb - phpmyadmin add "createdb"

Post by 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 :)?
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
kreos
Posts: 7
Joined: Thu 10. Jan 2019, 00:07

Re: mariadb - phpmyadmin add "createdb"

Post by 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
Posts: 914
Joined: Fri 15. Apr 2016, 16:11

Re: mariadb - phpmyadmin add "createdb"

Post by nikko »

You can use a prefix, if its possible.
The software said: Requires Win Vista®, 7®, 8® or better. And so I installed Linux.
User avatar
kreos
Posts: 7
Joined: Thu 10. Jan 2019, 00:07

Re: mariadb - phpmyadmin add "createdb"

Post by kreos »

nikko wrote: Fri 11. Jan 2019, 21:56 You can use a prefix, if its possible.
yeah but the panel require a new user and password
User avatar
Tobi
Community Moderator
Posts: 2812
Joined: Thu 5. Jan 2017, 13:24

Re: mariadb - phpmyadmin add "createdb"  [SOLVED]

Post by Tobi »

kreos wrote: Mon 14. Jan 2019, 15:15
nikko wrote: Fri 11. Jan 2019, 21:56 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.
Gruß,
Tobi


-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser
Locked