Hi i would like to create a database but i do not know how. Could some one please show me how.

Well lets do this a couple of ways:
ONE With a script like the below PHP script:

If you copy the above code even with the comments and assign the proper values for the host, databasename, username, and password it will connect to the database and create a database named testdb. Now let try method

TWO

Go to the cPanel like below



Then after you click the MySQL Icon you will see this:



So there you go how to create a data base with or without a cPanel using script and without using a script by using the cPanel, the choice is yours.

Very nice script...I say the same thing...

MySql is a free and very easy to use, easy to understand web-based database. The latest version is very user friendly, and you can even export your data as excel, edit it, and reinsert it into the database very easily, if you are more comfortable using that format. It is very well documented and I believe it has a support forum community as well. However, you'd need to know how to code it, write queries.

My overall suggestion to you is this. Search tHotscripts.com, sourceforge.net, etc. for a free script that does what you need your database to do (like drive an address book, website, customer database, blah blah). Basically, search for a PHP script and download it. And if you can spend a few bucks (between 20USD and up), you can find commercial scripts which tend to be much better written, efficient and visually appealing. This will give you a front-end to display your data and work with the database, possibly even an admin side so that even the most inexperienced computer user can use the software.

how about adding attributes into the database? What script can I use?

like what kind of atributes? if you want to add a table (where you store info) do this:



for instance:

Your database is mostly an area where you are going to store cata that will change over time and need frequent updates or even new data altogether, but in order for it to be of any value it must have as little a one table that contains some sort of structure.

Take for example you want a database that holds all your household items with serial numer if they have such , a description of the itms, other attributes of the item such as cose, or its appraised value and so on and this database has all this stuff so in the event that you have a disaster or theft you can bring up the information and let the insurance company and police (if it were a theft or robbery.

You would need a table that had such fields as item, color, description, phptograph if any, serial number if any, cost or value, and so on. So you have tables for each of these and the data type needs to be defined within the table.

So you name a database lets say mystuff (use the SQL query CREATE DATABASE 'mystuff' ), then it would have a table which you use to store your stuff kinda like:


CREATE TABLE 'inventory' (
'itemNumber' INT (4) AUTO_INCREMENT,
'item' VARCHAR (40) NOT NULL,
'value' VARCHAR (15),
'color' VARCHAR (10) ,
'description' VARCHAR (255),
'serialnumber' VARCHAR(50),
'date_aquired' DATE,
PRIMARY KEY (itemNumber))

of course this is just a made up example but I thinkyou should be able to get the idea, your real database might have hundreds of tables, but you need to figure out what all you want in a database and then set them all up, you might want to try a search for MySQL tutorials or SQL tutorials and learn a little about just what you want a database to do for your circumstances.

To make a database you need a ftp. After you have a ftp please look for the install. Open the install and fill in the required info. After you do that start the database and see if it is working. If it is not working then please post for further help. This works for appace and if you need help with something else PLEASE tell me right away I am really good with this.

That's not true - FTP doesn't have anything to do with the database, unless you're uploading the actual mysql binaries to your account for upgrades. To create a database, phpMyAdmin is sufficient, or if you're a power user - you have to use the command-line client of MySQL from your shell. Once again, whether it's apache or some other httpd, I've never heard of FTP being used to create databases... That's certainly a first. Try not to spread around disinformation like this.

i've noticed that at least for me, phpmyadmin cannot create new databases, I have to use the other MYSQL script in cpanel. However, if I made a database and dropped it, phpmyadmin can recreate it. Dunno why, or if this is an issue for anyone, but it's slightly annoying to me.

~Viz

I thought I could add something positive here, but you guys got me beat, hands down!