how do you create a database?

[grumpy]

I know nothing about mysql. I was under the impression the vbulletin program would create the database for me, but it doesn't. So I have to manually create it. Can anyone tell me now this is done, or point me towards step by step instructions designed for the complete novice?

thanks!

[Mitrofan]

Telnet into your server.

cd /usr/local/mysql/bin
./mysql -u root -p

it will prompt you for password. Enter mySQL root password. YOu should have it or you out of luck. If you don't have the mySQL root user password set yet, you can login without a password then. I've never done that but I think the command would be ./mysql -u root


After loggin in to mySQL enter this:

create database vforum;


Dont forget the ;

Then you will need to create the user to access this database.

Do this:mysql> GRANT ALL PRIVILEGES ON something.* TO bob@localhost
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

User name bob is created, the password some_pass is created, and he can only use database "something"


Then put this database name, the user and password in global configuration file of Vbulletin.