Facebook
Twittersezohessen
New Pleskian
How to change there privileges, so that use can create new database ?
-
Please be aware: Kaspersky Anti-Virus has been deprecatedWith the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
-
The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
-
We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.
Issue User can not create new database (Using Multitenancy)
- Thread starter sezohessen
- Start date
-
- Tags
- php laravel tenant
How to change there privileges, so that use can create new database ?
sezohessen
New Pleskian
Because of multitenancy. Each user can have his own store
Why your user can't create a needed database for his own store in his Plesk Control Panel?
sezohessen
New Pleskian
The idea of website is that any use can register and make this own subdomain with this own database. Using multitenant user can has own store to manage, so as Administrator I should see all the databases that created automatically using tenant.
sezohessen
New Pleskian
Also how to access all databases of the website. In Databases section in Plesk I only can see one database like in screen shot.
But in Mysql command when running "Show databases" command , I can see all databases.
But in Mysql command when running "Show databases" command , I can see all databases.
It appears that you are trying to create your own control panel. This won't work with Plesk (or any other modern control panel).
If you are using Plesk then ALL operations such as creation of domains/subdomains, databases, database users, mail accounts etc. _MUST_ be made from Plesk, otherwise Plesk won't know about your modifications.
Think of Plesk like the "master brain" on your server: It holds the "truth" (aka. the master configuration) in its own database and will then configure the services on your server (config files etc.) using this information. Any modification in Plesk will trigger the configuration updates on the server.
This process won't work the other way around: Plesk will not pick up modifications of the configuration that you've made manually or that were created by another script.
However, the key feature of Plesk is exactly what you're trying to do: It allows each of your tenants to configure their own users/databases/subdomains etc.
You are the admin of the server and you create customers. Those customers then can manage their domains from Plesk without any actions from you. Isn't that exactly what you want? So why don't you use this key feature of Plesk? You can even create resellers that in turn will manage their own customers.
Have a look at this, it will explain how all of this works: Customers and Resellers
If you are using Plesk then ALL operations such as creation of domains/subdomains, databases, database users, mail accounts etc. _MUST_ be made from Plesk, otherwise Plesk won't know about your modifications.
Think of Plesk like the "master brain" on your server: It holds the "truth" (aka. the master configuration) in its own database and will then configure the services on your server (config files etc.) using this information. Any modification in Plesk will trigger the configuration updates on the server.
This process won't work the other way around: Plesk will not pick up modifications of the configuration that you've made manually or that were created by another script.
However, the key feature of Plesk is exactly what you're trying to do: It allows each of your tenants to configure their own users/databases/subdomains etc.
You are the admin of the server and you create customers. Those customers then can manage their domains from Plesk without any actions from you. Isn't that exactly what you want? So why don't you use this key feature of Plesk? You can even create resellers that in turn will manage their own customers.
Have a look at this, it will explain how all of this works: Customers and Resellers
