Dont know if this is the best place to put this. But I am new to vps and I am looking to install a forum for one of my sites. The thing is the site is not running through cpanel so I cant simply use the admin tool through cpanel to create the databases. What I have access through virtuosso is their ssh tool. So if someone knows the commands to use for this please let me know. If anyone wants to help with this pm me and we can work out a prise for the service.
Free Webmin control panel would have made it easy. Though there are tutes for common mysql commands, currently I'm unable to link to some.
I think it is better to hire someone to create such things for you. Any mistake can cause your database crashing down
First login to your mysql console using command: #mysql -u root -p you will have to enter your password next, hit return (enter) after you have given your password next, create the database by using command (replace [databasename] with name of the new database: create database [databasename]; hit return next create and attach a new user to your database by using command, replace [database] with the name of the database you just created, [databaseusername] with a name you want for the user, [host] with host (usually localhost), [password] with password you want to use: grant all on [databasename].* to [databaseusername]@[host] identified by '[password]'; hit return exit from mysql by typing: exit
Yep...thats the way. But I guess if you had installed free webmin on your vps, it'd have been really good. The vps support team does that for free generally.
Well .. to create it directly from console you can use the other MYSQL provided binaries like: mysqladmin mysqldump etc