numeric mysql users

inner

New member
Joined
May 19, 2005
Messages
1
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.
 
inner said:
AFAIK, the username in grant should be enclosed by `` and not the '' nor it could be unclosed.

I think that has already been fixed.

What Operating System and version of DirectAdmin are you running? You might contact DirectAdmin about this issue.
Does it work you you mix the usernames aphanumerically?
 
Back
Top