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.
vBulletin® v3.8.0 Beta 4, Copyright ©2000-2008, Jelsoft Enterprises Ltd.