Creating a news portal based on PHP / MySQL 1. º Step - Creating and preparing the database (MySQL) Start by creating a database dedicated to this tutorial. For example, named news if you are already in the MySQL client, type the following: create database news; Therefore, open the database created: use news; Now is to create a table to record their stories. You can follow the example below, superprático: CREATE TABLE news ( id int (5) NOT NULL auto_increment, name char (30) NOT NULL, surname char (30) NOT NULL, city char (50) NOT NULL, state char (2) NOT NULL, email char (80), date date NOT N