How To Create Tables

free web hosting
Open Discussion > CONTRIBUTE > Tutorials

How To Create Tables

Chatz
At the end of this tutorial you should know how to:
1.How to create a database on your sever
2.How to create tables on a mysql database For a script
3.How to confirm your script so that it works with your database

TUTORIAL PART 1

How do we create a database using the cpanel on a server? Well i'll explain it the best way i can.In your cpanel go to yor mysql options.Once in you will easeily see than option to create a database and an option to create a user. Frist go to the create database option and type in the name of the database you would like for example chatzwill be my database.Once you have done that,go into the create user option and again tyape the user name and password you would like for exmaple username:test password:1111.After you have done that go to the add user to database option and add your uer to the database you created.

TUTORIAL PART 2

To create tables on your database for a certain script you have to 1-screach the script for a file named sql example dump.sqlthen 2-dump the sql file in your database.To do this you have to enter your PhpMyAdmin and select your database.After that is done you will have to go into the option that say's import when you inside you will get an option to upload a file that's where you will upload your sql file.After that your tables on your database should be created.

TUTORIAL PART 3

To confirm your script so that it works with the database you'll have to search the script for a file named settings,db,confir,or int.Once you found the file you'll have to edit the dbuser to your databases username example test, note that some servers use this format: YourSeversName_test.Now edit the dbpassword to your databases user password example 1111,note when putting your password you must not use the format: YourSeaversName_1111.Now edit the db to your databases name example chats again you might need to use the format.

So now you should have a working script using a database smile.gif


 

 

 


Reply

lilemi
You have quite a few typos.... You might wanna proofread, even the smallest corrections make a difference. Remember, hit the spacebar after periods and commas... If english isn't your first language I totally understand though.

I'll try it out later though, dont worry! biggrin.gif

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.


*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for create, tables

*MORE FROM TRAP17.COM*
advertisement



How To Create Tables



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE