Installation guide for MySQL
the easiest way to experiment with MySQL and PHP is to buy some space on a common Web page host.
Although you can set up MySQL manually in your home computer, it can be quite difficult for beginners to do so and need some more lessons! If you feel you have any need, or you are just mentally unstable, head to mysql.com for more information on installing MySQL yourself.
MySQL settings in the cpanel
There are many different types of control panels that your shared hosting service provider might have. This tutorial assumes that you are using the most popular, making friends.
First, find the link that allows you to manage MySQL's. In the dating icon the MySQL database is marked. Once you have it, you need to do the following to start using MySQL.
Create a new database
Create a password for a new user
Specify user Database
If you have problems with this step, seek help from your network hosting provider or ask a question at the Tizag forum.
Useful Tool-P hpmyadmin!
Also offers most managed services are phpMyAdmin (you can also install anything you want, as it's open source and free). This tool will allow you to view all MySQL databases, tables and projects, as well as execute SQL queries remotely through a Web browser.
While we will teach how to create databases, tables and all other MySQL tasks through PHP, we encourage you to understand phpmyadmin. This easy to use interface will allow you to do a lot of common tasks with MySQL quickly and easily to save your many beginner headaches and help you understand things in a more intuitive way.