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 MySQL.com 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.