Creating a database

[VitalMetrix]

I am trying to create a database without the username_databasename naming convention. Is there any way I can do this?

I would like to use just the database name, without the username, but imagine that I will have to do this through a command prompt, or ??

Any help on this matter would be greatly appreciated.

Regards,
Jaret

[DirectAdmin Support]

Hello,

Yes, it would have to be done through mysql.

cat /usr/local/directadmin/conf/mysql.conf

get the login/pass listed there (need root to do it)

then type:

mysql -uda_admin -ppass
CREATE DATABASE databasename
GRANT ALL PRIVILEGES ON databasename.* TO user@localhost IDENTIFIED BY 'pass'
FLUSH PRIVILEGES
quit


John