Tutorials
Creating a MySQL Database

Most scripts require the use of a MySQL Database. You will have to set one up yourself if you need it. If you are hosted, ask your host to set one up for you.

+ What is a MySQL Database?
· MySQL is a server program which allows information to be stored and retrieved using SQL.For the simple SQL statements that are typical of web based content mySQL is the fastest of the SQL servers. To put it simple, scripts store their information in the database engine so it can 'grab' the data it has stored within it quickly.

+ So, how do I set one up?
First, you must log into your Cpanel. You MUST have access to this in order to create it. Which goes back to why you must ask your host to do it if you are hosted.
Look for a MySQL Icon. It should look something like this:



Click that and it should take you to a page we will call the MySQL admin. Scroll down on that page and look for something like this:



This is where you will first be creating the database. Type in what you want your database name to be and click Add Db.

Go back to the MySQL admin page and look for something like this:



This is where the username and password for your database will be created. Type in what you want your databaseusername and password to be. It is a good idea to make the username the same as what you named your database so there is no confusion. Don't forget what you made your password either! Click add user and you should be brought to a "Success!" Screen. After you see this, make your way back to the MySQL Admin.

Finally, scroll down to the drop down menu:



Select the database and User that you made and click Add user to Database. You're done!


Questions? Submit them here!

Back | Home | Forward


Navigation


Welcome
Welcome to Hello-Love.net, my personal place on the net for posting my daily rants, sharing my thoughts, and ideas. Take a look around, you might find something you like. I make an effort to validate my pages for both CSS and HTML, but my site is most optimized for Firefox, so if you're an IE user, beware! You have a chance of seeing errors around the site!


My Quilt AIM: ItsAmbrosity MSN: xamberlums@hotmail.com  Email me! Myspace: Youngxatheart  LastFM: ItsAmbrosity Flickr: ItsAmbrosity
online | Visitors
Since March '07



Webcams

AmberCam PetCam



Calendar

September 2008
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
2930EC



Loved


Hostees
Bonnie

Affiliates
Amber
Amberlynn
Angie
Ashhh
Brandy
Christina
Cory
Daniel
Erin
Jenny
Jessica
Kate
Kilanda
Lisa
Meesh
Paris

More Links / Apply

I recently did an Affie check! If you're removed from this list, be sure to check under "More Links" to see if your link was moved to there. If not, you can still reapply!




Statistics
Posts: 87
Comments: 413
Categories:
Last Post: Hiatus Until Mid-September
Last Commenter: Charley
Last Modified: August 10, 2008 @ 8:47 pm (GMT -6)




Twitter


Disclaimer
Everything found here is copyrighted by me unless otherwise stated. If it belongs to you, just simply email me using the form above, and you will be properly credited. If you don't like it here, pleasy kindly click the in the top right corner of your screen. Do NOT direct link! That is considered bandwidth theft, which is a crime, and it's easy to get caught! Confused? Read me.

Powered by Wordpress    CSS Valid    HTML Valid    RSS Feed    Linux Server    Bookmark Me!

Too Cool for IE





Admin

This stuff is not for you!
IPs are LOGGED!
CPanel . Wordpress . MyQuilt