Mysql db limit crossed - 500 users

Community Support
1

I was getting Error: mysql host EMPTY_DB_HOST doesn't exist on running the command v-add-database, upon further investigation I found that the MAX_DB = USED_DB which is 500 by default.

However, the number, of users in the system is only about 200+, so my question is why is this list not cleaning when i remove a user (location - /usr/local/hestia/conf/mysql.conf)

HOST='localhost' USER='root' PASSWORD='4BCXCrXmq3bSQLBs' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='..............

also, what should I do, shall I manually remove users from this file?

2

You should be able to increase it MAX_DB=‘500’

It might be a bug

3

May be its a bug, need to find out where this might be happening. We generally don’t delete the database seperately, we simply delete a user when we want to remove a user and its associated resources.