- Plesk Onyx for Linux
- Plesk Onyx for Windows
Database user 'jdoe' is created for the subscription
example.com in Plesk > Subscriptios > example.com > Databases > User Management.
How to grant him access rights to a database belonging to the other subscription?
This functionality is not implemented in Plesk. Suggest a new feature at plesk.uservoice.com.
The top-ranked suggestions are likely to be included in the next versions of Plesk.
Alternatively, it is possible to allow access for a database user using the command line:
Note: if you don't have root access to Plesk server via SSH, contact your hosting provider regarding the issue.
Connect to the server via SSH.
cat /etc/psa/.psa.shadowmysqldump -u admin mysql > myqsl
Log into the Plesk database:
# plesk db
Give permissions to access database
database1to the database user
MYSQL_LIN: > GRANT ALL PRIVILEGES ON database1.* TO 'jdoe';Note: replace the database and user names with actual ones in the query above