mysql database and usernames with double underscore

freakie

Verified User
Joined
Jan 16, 2006
Messages
68
Location
Apeldoorn, Netherlands
I im running a centos 7 server with mariadb 10.3

I have a customer which has one database with this number of users : -1

The other databases of the customer are shown correctly.

This is the database:

cust_rrm_2019

the usernames from the user table:
localhost | cust_rrm_2019

the entries in the db table:

localhost | cust\_rrm_2019 | cust_rrm_2019

When adding a user no error is shown, but nothing is addedd

Does anyonone have a clue or solution

I have this in directadmin.conf :
allow_db_underscore=1
 

Zhenyapan

Verified User
Joined
Feb 23, 2018
Messages
1,054
Location
UA
if there is only ONE problem DB - just make backup, check it, remove DB and user, recreate DB, restore from backup.
 
Top