05- MySQL Database


MySQL database is used in organizing a group of tables. For instance, when you create different tables that shared a common theme you need to group them into one database to manage it easily.



How to create a database?

Creating a database directly through a PHP script do not allow by most web hosts but they require to use the PHP/MySQL administration tools on the web host control panel to create databases.


MySQL Database Example:

  • Server – localhost
  • Database – testdb
  • Table – table
  • Username – useradmin
  • Password – passadmin


Note: In the advanced tutorial, the table may change but everything else will remain the same.


Set the server name(localhost) to a server because all of our scripts are going to be placed on the server where MySQL is located. Correct the url, if the MySQL server was running on a different machine.


Facebook Comments


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.