|
MySQL is the world's most popular open source database software...a relational database management system. The program runs as a server providing multi-user access to a number of databases. MySQL databases are stored in related tables and are typically used for web application development using PHP.Source of information from: mysql.com, wikipedia.org and motive.co.nz
From the information above, you probably got some idea what MySQL is... hopefully!
Anyway, learning how to create MySQL databases will help you gather more information. You will need a cPanel for this tutorial.
1. Log in and find MySQL Databases.
2. See where it says "New Database" and enter a suitable name for it. Then click "Create Database".
3. You should get a page confirming you have created a database like the screenshot below. Now click "Go Back".
4. Now you want to add a user for your database. Fill out an appropriate user for the database. Remember that the user can be used in multiple databases (for future purposes) so you would only probably need to fill this out once. Click on "Create User". Click "Go Back".
5. Scroll down again to find the third section which is called something like: "Add Users To Your Databases". Select your user with correct database and select all check boxes available or click on the "ALL" check box if you have it. Click on "Add User To Database". Click "Go Back".
6. There is an option for you to add a host, but the default is kept to "localhost" so we don't need to change that. If you scroll up now (or down for some), you should see your database settings like the screenshot:
Congratulations! You managed to create a MySQL database. Now you can add the database name, database user, database password and host (default is localhost) to any script that requires a database.
Please link back if I have helped, thank you. If you have any problems, feel free to contact me.
Warning: include() [function.include]: URL file-access is disabled in the server configuration in /home/jijy/public_html/tutorials/coding/mysqldb.php on line 32
Warning: include(http://sugaryparadise.net/footer.php) [function.include]: failed to open stream: no suitable wrapper could be found in /home/jijy/public_html/tutorials/coding/mysqldb.php on line 32
Warning: include() [function.include]: Failed opening 'http://sugaryparadise.net/footer.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/jijy/public_html/tutorials/coding/mysqldb.php on line 32