Mysql Getting Started: mysql database

The MySQL database does not have its own. On the contrary, MySQL databases are a group of tables that are organized. If you create many different tables and share a common topic, you will combine them into a database to make the management process easier. MySQL database
MySQL database does not have its own. On the contrary, MySQL databases are a group of tables that are organized. If you create many different tables and share a common topic, you will combine them into a database to make the management process easier.


Create your first database
Most network hosts do not allow you to create a database directly using PHP scripts. Instead, they need you to use PHP/MySQL management tools to build these databases on the control panel of the hosts on the network. Create a database and specify a new user for the database. Starting with all our examples, we will use the following materials:

Server: localhost
Database-test
Table-explame
Use-admin
Password-1 admin
Note: The table may change with advanced experience, but everything will remain unchanged!

The server is the name of the server. We want to connect to it. Because all our scripts should be placed on the MySQL server and the correct address is the local host. If the MySQL server runs scripts from different machines, you need to enter the correct URL (here is the details of your web host ).

Your database, table, user name, and password do not match ours. If you select a set of different logon information, remember to copy the script when you insert your own information.

Status check
So far, you have created a new database and specified a user for it. You should not create a table. If you are the latest student, continue the tutorial. We will explain an upcoming lesson in our first table.