Page 1 of 1
Newb Question - How to setup database
Posted: Sat Dec 09, 2006 3:06 am
by FrankieB
I have no idea what I'm doing. I can get to my control panel and to phpmyadmin but from there I am clueless.
Can someone give me a retard step by step on how to do this?
Thanks.
Re: Newb Question - How to setup database
Posted: Sat Dec 09, 2006 4:44 am
by jmcgin51
Depending on how your host's servers are setup, you may or may not have permissions to create a database. Typically, if they run MySQL in desktop mode, you can create dbs, but if they run in server mode, you can't. (At least this is what my host tells me.)
Assuming you have rights to create a db, go to your phpmyadmin homepage.
In the "Create New Database" field, type in the name of your desired db, then click "Create". That's it. An empty database has been created. You can now go to this database by selecting it from the Database dropdown menu in the left side of your phpMyAdmin page. Additional users can be created - I think on the Admin tab - again, you may or may not have permission to do this. If you're running your own server, you should have all rights. If you're running on a hosted site, you may not.
Server IP info is listed at the top of the screen. That, along with the username, password, and db name are all you need for the CMSMS install db setup.