Page 1 of 1

[SOLVED] Adding DB will NOT add mysql user :/

Posted: Thu Feb 22, 2018 1:06 pm
by TheNewOne
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 "...") :
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 '...' '...' '******'
It's missing the v-add-database-user, or v-change-database-user.

However, it's not working correctly for me.

Re: Adding DB will NOT add mysql user :/

Posted: Thu Feb 22, 2018 1:19 pm
by TheNewOne
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 :)