We Exist to Provide 100% 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 require more than a few lessons! So if you’re ready and you think that you got what it takes , go over to for more information on installing MySQL by yourself.



Setting up MySQL in cpanel

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


First thing that you need to do, is find 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

Check Your Domain Ranking

Leave a Reply

Your email address will not be published. Required fields are marked * © 2016 Frontier Theme

Subscribe For Latest Updates

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