On direcadmin we user numeric usernames, like 10001, 10002 and so one. I think there's something wrong with the syntax of direcadmin user creation scripts because when creating user I get the following error:
Unable to add user 10003 to 10003_lobis. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10003@localhost IDENTIFIED BY 'labai-lobis'' at line 1
Your database has been setup. Use the following values:
As you may have noticed, the database is still created and the user can use the database, but there's no default user for all databases and no ability to view all databases in phpMyAdmin as '10003'
AFAIK, the username in grant should be enclosed by `` and not the '' nor it could be unclosed.
Unable to add user 10003 to 10003_lobis. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10003@localhost IDENTIFIED BY 'labai-lobis'' at line 1
Your database has been setup. Use the following values:
As you may have noticed, the database is still created and the user can use the database, but there's no default user for all databases and no ability to view all databases in phpMyAdmin as '10003'
AFAIK, the username in grant should be enclosed by `` and not the '' nor it could be unclosed.