We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
SQL Management Required Permissions
SQL Management Required Permissions
Hi,
We’ve set up Vesta on one of our servers and have a query about the database management feature. We’ve set up MySQL on a separate server and are now about to set up a SQL user so Vesta can manage the MySQL instance, create databases, additional users, etc. However, we wanted to confirm what permissions the SQL user requires.
Database and Tables
[ ] Select
[ ] Insert
[ ] Update
[ ] Delete
[ ] References
[ ] Create
[ ] Drop
[ ] Alter
[ ] Index
[ ] Trigger
Views and Procedures
[ ] Create View
[ ] Show View
[ ] Create Routine
[ ] Alter Routine
[ ] Execute
Administration
[ ] Reload
[ ] Shutdown
[ ] Event
[ ] File
[ ] Process
[ ] Super
[ ] Create Temp Table
[ ] Lock Tables
[ ] Show Databases
[ ] Create User
[ ] Grant
We’re conscious of security and only want the essential permissions to be granted to this management user. Your advice would be greatly appreciated.
We’ve set up Vesta on one of our servers and have a query about the database management feature. We’ve set up MySQL on a separate server and are now about to set up a SQL user so Vesta can manage the MySQL instance, create databases, additional users, etc. However, we wanted to confirm what permissions the SQL user requires.
Database and Tables
[ ] Select
[ ] Insert
[ ] Update
[ ] Delete
[ ] References
[ ] Create
[ ] Drop
[ ] Alter
[ ] Index
[ ] Trigger
Views and Procedures
[ ] Create View
[ ] Show View
[ ] Create Routine
[ ] Alter Routine
[ ] Execute
Administration
[ ] Reload
[ ] Shutdown
[ ] Event
[ ] File
[ ] Process
[ ] Super
[ ] Create Temp Table
[ ] Lock Tables
[ ] Show Databases
[ ] Create User
[ ] Grant
We’re conscious of security and only want the essential permissions to be granted to this management user. Your advice would be greatly appreciated.
Re: SQL Management Required Permissions
Each user of your server may need specific permission, so not all users need the same, by default vestacp give grant all permisions for user / database
Or your question is what permisions need vestacp user ?
Vesta need root access.
Or your question is what permisions need vestacp user ?
Vesta need root access.
Re: SQL Management Required Permissions
Hi Skamalse,
My question was about the VestaCP user. I'm highly sceptical about giving Vesta root access, it surely doesn't need that level of access. I'm happy to give Vesta all the permissions it requires but I disagree about giving it control over the whole instance of MySQL.
My question was about the VestaCP user. I'm highly sceptical about giving Vesta root access, it surely doesn't need that level of access. I'm happy to give Vesta all the permissions it requires but I disagree about giving it control over the whole instance of MySQL.
Re: SQL Management Required Permissions
Hi
Vesta use root to connect, but you cat just limit permisions,
So vesta not store nothing in databases, just need permisions to create databases, create users, modify users grants and somehting more like access to databases to do backups., its like grant privileges in all databases, because vesta also need drop databases an remove users permisions.
So just for create users, databases and take backup you give vesta control of your mysql server
Vesta use root to connect, but you cat just limit permisions,
So vesta not store nothing in databases, just need permisions to create databases, create users, modify users grants and somehting more like access to databases to do backups., its like grant privileges in all databases, because vesta also need drop databases an remove users permisions.
So just for create users, databases and take backup you give vesta control of your mysql server