The main function of the database is the storage and processing of information. SQL or Structured Query Language translates to "structured query language". Without databases, the normal functioning of sites is impossible, since it is in them that all the necessary information is stored for the operation of forum engines, online stores and other network resources.
Instructions
Step 1
To create a database, you must be hosting with php support. Log into the control panel of your resource, find the "Database Management" option. You may have it called something different, so look for menu bars related to databases.
Step 2
Having opened the window for managing databases, find the button "New database" ("Create database", etc.). Enter the name of the database you need to create. Please note that the name of the username is usually entered in the name of the database. For example, if the username is elvin, and the database is designed to work with the forum, then it may be called elvin_forum. Here the name forum is entered for convenience only, it can be anything else instead. For example, elvin_data, elvin_db1, etc.
Step 3
Specify the database type MySQL. If you need to create an additional user for this database, check the appropriate option, specify the username and password. Click the "Create" button, the database and user account will be created. You can add new users and assign them the necessary rights - for example, the ability to edit the database, update, delete files, etc. To do this, you must check the appropriate boxes in the user profile settings. If the user is a site administrator, then you can simply check the box next to the all line - that is, give all the rights.
Step 4
To work with databases, a special program is most often used - phpMyAdmin. With its help, you can administer databases remotely, through a regular browser. Thanks to phpMyAdmin, even a person with a rather poor knowledge of MySQL can work with databases. The program has detailed documentation that makes it easy to understand the use of this program. You can see the Russian translation of the documentation here:
