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.