Databases, create a database

In this section you can create the database necessary for your site.

How to create a database:

· Username

Specify the desired database name. The name looks like this: login_name ( login is your hosting panel login, name is any name). The database name and the login used to connect to it are the same. For example, if the database name is login_name , then the database user will be login_name .

· Password

Specify the password you will use to connect to the database.

· Encoding

Be careful in this section - you need to select the database encoding that is required for your site (engine), for example, for WordPress you need UTF-8, and for DLE - windows-1251 (cp1251)

Below the database creation form, there is a list of already created databases (if you have created them before), as well as the main login, which you can use to connect to any of your databases.

! Do not use the main login to connect the site to the database.

· MySQL user

· Database

The name of the database this login can connect to. As you can see, Any is listed next to the primary login.

· Database server

A server for connecting to your website's database, if the site is hosted on the same server where the database is created. For external connections, the server's IP address is used (indicated on the hosting panel's main page).

· Access to the database

Database access status: Local — means the database can only be connected to from the same server where it was created; Any — external connections are possible.

· Settings

Clicking the Edit button opens a page for editing the database. More on that below.

· Action

Login allows you to access phpMyAdmin for this database without entering a password. This method only allows you to log into one database; you cannot log into multiple databases simultaneously.

Delete - delete the database.