O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required