A MySQL database is nothing in itself. Rather a MySQL database is a way of organizing a group of tables. If you were going to create a bunch of different tables that shared a common theme, you would group them into one database
to make the management process easier.
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. Create a database and assign a new
user to this database. For all of our beginning examples we will be using the following
- Server - localhost
- Database - test
- Table - example
- Username - admin
- Password - 1admin
Note: The table may change in the advanced lessons, but everything else will remain the same!
The server is the name of the server we want to connect to. Because all of our scripts are going to be placed on the server where MySQL is located the correct address is localhost. If the MySQL server was on a different machine from where the script was running, then you would need to enter the correct url (ask your web host for specifics on this).
Your database, table, username, and password do not have to match ours. If you choose a different set of login information, remember to insert your own information when copying the scripts in this tutorial.
So far, you should have created a new database and assigned a user to it. You should not have created a table yet. If you are up-to-date, then continue the tutorial. We will be making our first table in an upcoming lesson.
Download Tizag.com's MySQL Book
If you would rather download the PDF of this tutorial, check out our
MySQL eBook from the Tizag.com store.
You may also be interested in getting the PHP eBook
Found Something Wrong in this Lesson?
Report a Bug or Comment on This Lesson - Your input is what keeps Tizag improving with time!