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?
Create MySQL database without user prefix
- Thread starter PvanEs
- Start date
zEitEr
Super Moderator
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:
Grant privileges for the user on "new" database with name blabla.
Code:
# cd /var/lib/mysql
# ln -s <USERNAME>_blabla blablaGrant privileges for the user on "new" database with name blabla.