Create MySQL database without user prefix

PvanEs

Verified User
Joined
Sep 22, 2008
Messages
10
For a user I have to create an database with a specified name. When I create the database in Directadmin, the name of the user is added as an prefix to the database. Is there any possibility to manualy create the database for this user and make it visible on his Directadmin account?
 
No, either visible, or without prefix. But you can try to use a symlink or hardlink. I can not give you any guarantee, that it will work in your case, and that it won't break anything. I did use that way:

Code:
# cd /var/lib/mysql
# ln -s <USERNAME>_blabla blabla

Grant privileges for the user on "new" database with name blabla.
 
Back
Top