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
Before performing the migration, I took preventive measures to change the maximum username length to 20 characters. Additionally, I ensured that database naming used alphanumeric characters only.
Here are the specific test cases I conducted:
Here are the specific test cases I conducted:
- Mass migration from a MySQL server to a MariaDB server:The database user data seemed to transfer, but it is not visible. I suspect the data exists because when I attempt to create the database on the new server (MariaDB), I get an "Internal Error." However, if I create a user/database with a slightly different name (e.g., appending one different character to the previous name), it works successfully.
- Single user migration from Server 1 (MySQL) to Server 2 (MariaDB):I encountered the exact same issue as described in point 1.
- Migration from Server 3 (MariaDB) to Server 2 (MariaDB):This migration proceeded smoothly with no issues.
zEitEr
Super Moderator
You might post here a MySQL server version from which you migrated