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.
[SOLVED] Adding DB will NOT add mysql user :/ Topic is solved
[SOLVED] Adding DB will NOT add mysql user :/
When a user (not admin) is adding a database (mysql), no user will be added.
The database will be created, but not the user!
It seems to be since release -19 oder maybe -18.
When adding a database, system.log says (change real entries with mydb or "...") :
However, it's not working correctly for me.
The database will be created, but not the user!
It seems to be since release -19 oder maybe -18.
When adding a database, system.log says (change real entries with mydb or "...") :
It's missing the v-add-database-user, or v-change-database-user.2018-02-22 13:53:24 v-add-database 'mydb' 'mydb' 'mydb' '******' 'mysql' 'localhost' 'utf8'
2018-02-22 13:54:53 v-change-database-password '...' '...' '******'
However, it's not working correctly for me.
Last edited by TheNewOne on Thu Feb 22, 2018 1:20 pm, edited 1 time in total.
Re: Adding DB will NOT add mysql user :/
Ok, worked it out:
VestaCP made a mysql update (from 5.5 to 5.6), but the mysql-user table was kinda crashed. In phpMyAdmin an error came up like "expecting 43 users, found 42" or something.
I just ran "mysql_update" (without any further params) on console, wait 1-2min and done - it worked again.
@Vesta Support: Please ensure you start "mysql_upgrade" und ... well, upgrades :)
VestaCP made a mysql update (from 5.5 to 5.6), but the mysql-user table was kinda crashed. In phpMyAdmin an error came up like "expecting 43 users, found 42" or something.
I just ran "mysql_update" (without any further params) on console, wait 1-2min and done - it worked again.
@Vesta Support: Please ensure you start "mysql_upgrade" und ... well, upgrades :)