PDA

View Full Version : create a database and add user manually?


Ruth
Thu 12th Apr '01, 12:03am
how can i create a database and add user manually to it?

Mitrofan
Fri 13th Apr '01, 4:01pm
login to mysql as root
./mysql -u root -p

type create database forum;

you have just created database named forum

Then type:

grant all privileges on forum.* to forumuser@localhost
identified by 'secretword' with grant option;

THat's it. You have just created user forumuser and set the password for that user to secretword

Of cause you should use your own name and password for the user.