O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

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

Chapter 4. First Steps

Having seen the overall layout of phpMyAdmin's panel, we are ready to create a database, our first table, insert some data in it, and browse it. These first steps are intentionally simple, but they will give you the foundation on which more complex operations are achieved later. Moreover, at the end of the chapter, we will have at our disposition, the two basic tables on which the remaining of the exercises are based.

Database creation

Before creating a table, we must ensure that we have a database for which the MySQL server's administrator has given us the CREATE privilege. Various possibilities exist:

  • The administrator has already created a database for us, and we see its name in the left panel; we don't have the right to ...

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