27.4. MySQL Database

MySQL database is a way of organising a group of tables. If you were going to create a bunch of different tables that shared a common theme, then you would group them into one database to make the management process easier.

27.4.1. Creating Your First Database

Most web hosts do not allow you to create a database directly through a PHP script. Instead they require that you use the PHP/MySQL administration tools on the web host control panel to create these databases. For all of our examples we will be using the following information:

  • Server - localhost.

  • Database - test.

  • Table - example.

  • Username - admin.

  • Password - 1admin.

The server is the name of the server we want to connect to. Because all of our scripts are going to be ...

Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.