Einen Überblick über das Administrationstool KeyHelp der Keyweb AG und dessen Download gibt es auf https://www.keyhelp.de

Dieses Forum soll es interessierten Benutzern ermöglichen, sich über KeyHelp auszutauschen und Hilfe bei Problemen zu finden.

mariadb - phpmyadmin add "createdb"

For questions about the usage of KeyHelp and the configuration of it services.
Antworten
Benutzeravatar
kreos
Beiträge: 3
Registriert: Do 10. Jan 2019, 00:07

mariadb - phpmyadmin add "createdb"

Beitrag von kreos » Do 10. Jan 2019, 00:59

with the is there a way to allow the creation of some (4-5) databases and add them to a single mysql user (mariadb) ?
Benutzeravatar
Alexander
Keyweb AG
Beiträge: 760
Registriert: Mi 20. Jan 2016, 02:23

Re: mariadb - phpmyadmin add "createdb"

Beitrag von Alexander » Do 10. Jan 2019, 11:01

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
**************************************************************
Benutzeravatar
kreos
Beiträge: 3
Registriert: Do 10. Jan 2019, 00:07

Re: mariadb - phpmyadmin add "createdb"

Beitrag von kreos » Fr 11. Jan 2019, 00:24

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
Beiträge: 697
Registriert: Fr 15. Apr 2016, 16:11

Re: mariadb - phpmyadmin add "createdb"

Beitrag von nikko » Fr 11. Jan 2019, 21:56

You can use a prefix, if its possible.
The software said: Requires Win Vista®, 7®, 8® or better. And so I installed Linux.
Benutzeravatar
kreos
Beiträge: 3
Registriert: Do 10. Jan 2019, 00:07

Re: mariadb - phpmyadmin add "createdb"

Beitrag von kreos » Mo 14. Jan 2019, 15:15

nikko hat geschrieben:
Fr 11. Jan 2019, 21:56
You can use a prefix, if its possible.
yeah but the panel require a new user and password
Benutzeravatar
Tobi
Beiträge: 722
Registriert: Do 5. Jan 2017, 13:24

Re: mariadb - phpmyadmin add "createdb"

Beitrag von Tobi » Mo 14. Jan 2019, 18:24

kreos hat geschrieben:
Mo 14. Jan 2019, 15:15
nikko hat geschrieben:
Fr 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



https://wewoco.de
webworkercommunity forum
Antworten

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast