Setting up a database...

CannonBallGuy

I've just downloaded a small CMS and I need to setup a database...
The instuctios are:

1)
create database CMS;
2)
GRANT ALL PRIVILEGES ON cms.* to cms_admin IDENTIFIED BY 'cms_admin' with grant option;
3)


USE CMS;

CREATE TABLE cms_t_users
(UserID VARCHAR(20) NOT NULL,
Password VARCHAR(20),
UserName VARCHAR(50),
EMail VARCHAR(50),
AdminUser CHAR(1),
Active CHAR(1),
PRIMARY KEY (UserID));

CREATE TABLE cms_t_menus (
ID MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
Title VARCHAR(255),
HyperLink VARCHAR(255),
DisplaySequence MEDIUMINT UNSIGNED,
Active CHAR(1),
PRIMARY KEY (id)
);

INSERT INTO cms_t_users(UserID,UserName,Password,AdminUser,Email,Active) VALUES('ADMIN','admin','admin','Y','admin','Y')

But I really do not know how to even start to make a mySQL database (except on CPanel)...

Can someone give me a very easy, simple list of instructions on how to do this, or maybe someone would be willing to do it for me? Please?

tntcheats

You'll have to use PHPMyAdmin for this, as it entails creating a table.

However the creation of the database can be done, I believe, in Cpanel.

Disclaimer: I don't really know how to use PHPMyAdmin, so you'll probably have to Google it.

tony

if you have phpmyaddmin your laughing its not that hard i made my 1st 1 last night and it wasmuch easier than i was expecting

CannonBallGuy

Awww crap.
I think I have worked out how to do it with phpmyadmin etc, but I have to make the db on cpanel first and it keeps putting "cbg_" infront of the db name and the db user name.

tony

yea mine puts synergy_ before it
it tells you though its gonna do that when you set it up, its not that big a problem its probably so that if you have more than 1 domain on your account its easier for you to sort them out

Python

thats because it always puts your account username infront of the db, just live with it.

in cpanel go to mysql databases and scroll down. type in a database name and click add db.

then create a user further down the page. once done you have to assign that user to the database by selecting it from a dropdown manu and then selecting the database. make sure the box is ticked on all for full permission.



to execute the sql statements open up phpmyadmin, select your database from the left hand side and then click on query. copy and paste that code into the box and submit. it should then say whether its been executed succesfully or not.

you will probably have to open up the cms's config file and change the db's name and password to match yours


hope i helped

CannonBallGuy

Yeah, thnx python but I new how o do all that, but I was hoping there would be some simple way around it putting cbg_ infront of everything so I didn't have to edit the code...

Aww well.
Thanks anyways guys!

pfgannon

May I ask which CMS it is?

tntcheats

Most CMSs just have a config file that it allows you to change the database name.

CannonBallGuy

You guys wouldn't know it.
A small thing from hotscripts called "Free CMS" or something... lol.

tntcheats

Free CMS.. I saw that while browsing through earlier today..
didn't look into it, really, though.

CannonBallGuy

All I really wnat is something that gives the user a form.
They shoose a .swf file to upload, enter the name, wherter its a game or movie and the dimensions, then a new page is created in the game or movie section with the title of the name they gave, showing the movie and a comments box and a "Rate this Game/Movie out of 5" thing at the bottom...
Like newgrounds.com...