Vesta 2.0 is coming soon! See our progress update: https://vestacp.com/docs/vesta-2-update
[SOLVED] Adding DB will NOT add mysql user :/
[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 :)