Creating a database

V

VitalMetrix

Verified User
Joined
Feb 5, 2004
Messages
9
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
 
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:
Code: 
mysql -uda_admin -p[b]pass[/b]
CREATE DATABASE [b]databasename[/b]
GRANT ALL PRIVILEGES ON [b]databasename[/b].* TO [b]user[/b]@localhost IDENTIFIED BY '[b]pass[/b]'
FLUSH PRIVILEGES
quit

John
 
You must log in or register to reply here.
Back
Top