ITSourceCode.com

Free Source Code and Tutorials

Custom Search

02- MySQL Setup

MySQL setup guide

Purchasing some space on a shared web host is the easiest way to experiment MySQL and PHP. However, you can set up MySQL manually on your personal computer at home. Beginners would find this difficult to do and it requires more than a few lessons! So if you’re ready and you think that you got what it takes, go over to MySQL.com for more information on installing MySQL by yourself.

 

 

MySQL Setup in panel

Shared hosting provider has different types of a control panel. Since CPanel is the most popular hosting provider, this tutorial assumes that you are using it.

 

The first thing that you need to do, finds the link that would allow you to administer MySQL. In this CPanel, the icon is named MySQL Databases. Once you get there, do the following before you can start using MySQL.

  • Create a new database
  • Create a new user with password
  • Assign the user to the database

 

 

Helpful tool – phpMyAdmin!

PHPMyAdmin is an open source and free hosting provider that you can install anywhere you want. This allows you to view all the MySQL database, tables, entries, and you can also perform SQL queries through a web browser.

Even though in this tutorial, you will learn how to create databases, tables, and all other MySQL tasks through PHP, we still encourage you to know more about phpMyAdmin. It’s a user-friendly interface because this allows you to do a lot of common MySQL tasks easily and quickly.

Facebook Comments
(Visited 14 times, 1 visits today)
Share this

Check Your Domain Ranking

Leave a Reply

Your email address will not be published. Required fields are marked *

ITSourceCode.com © 2016 Frontier Theme

Subscribe For Latest Updates

Signup for our newsletter and get notified when we publish new articles for free!




%d bloggers like this: