HostPilotĀ® Control Panel allows to assign the only one login (Owner) to each SQL database.

If you need additional users to access your database you can grant privileges to them using the database Owner credentials.

  1. To do so please create an additional login via the HostPilot > MSSQL\MySQL Server > Logins > Create a New MSSQL\MySQL Server Login section:
  2. Then you need to grant these new login permissions to access the SQL database.

The exact steps to do that depend on database you have:

MSSQL

MySQL

MSSQL

  1. Connect to the database using MSSQL Server Management Studio with the database Owner credentials.
  2. In Object Explorer expand Databases, expand your database node > Security > right-click on Users > select New User.
     
  3. On General page fill User name and Login name fields with the name of the new MSSQL login you created at the first step, assign appropriate schema to new user and press OK button:
  4. On Membership page assign appropriate database role membership for the new user and press OK button.

Then you'll be able to connect to your database using the new database login.

Note: According to SSMS Security and Display Concerns, View Any Database option has been disabled, so that database can be viewed in MSSQL Management Studio only by the database owner. This means that when you are connected to the MSSQL database using additional logins (not using the database owner login), you are unable to view your database in the list of available databases. However, you'll be able to execute queries against this database using 'use database' command:

use DATABASENAME go select * from table1

MySQL

From HostPilot > MySQL Server > Commands page (or from the phpMyAdmin interface), run the following command to grant full access to the specified user:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW,
SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `database_name`.* TO 'additional_login'@'%';

Notes:

  • You should grant access to '%' (all hosts) in order to keep your database accessible for the web server and HostPilot system.
  • You can also restrict access to the database for the additional user and allow only specific operations by running the following command:
    GRANT SELECT, DELETE, UPDATE, INSERT ON <database_name>.* TO '<additinal_user_name>'@'%';