Yesterday, I migrated a client’s dedicated server from Server A (using MySQL) to Server B (using MariaDB). Both servers are using DirectAdmin.However, an issue occurred where the database users from Server A were not detected on Server B. As a result, the database users do not appear in the “Database Users” list on Server B, and no database user is linked to the corresponding website database. This causes database connection errors because the user is not recognized.When trying to create a new database user using the same username as on Server A, it results in an internal error. This suggests that the database user data already exists or was copied during the migration, but it does not appear in the database user list in the DirectAdmin panel.How can this issue be fixed?
User Database missing after migrate from Mysql to Mariadb
- Thread starter waragham
- Start date
zEitEr
Super Moderator
Hello,
Whenever an user with the same name exists in DB it will be shown in Directadmin. What MariaDB version do you run? And what kind of a directadmin license you deal with: legacy or monthly?
Whenever an user with the same name exists in DB it will be shown in Directadmin. What MariaDB version do you run? And what kind of a directadmin license you deal with: legacy or monthly?
zEitEr
Super Moderator
the only one reason comes to my mind: either the username is too long or it contains not allowed chars