Creating the database · TMKAN

Legal Center

License Terms

Service Plans

What's new

Creating the database

An empty database and its user in hPanel, cPanel or another panel, and what to type in the wizard.

The system keeps its records in a database on your hosting: create an empty one once, and the wizard fills it.

Before you start

Give each copy of TMKAN a new, empty database of its own, and never share it with another website: the wizard may delete that site’s tables.

In hPanel (Hostinger)

Open your website (Websites › Manage site), then Databases › Management.

Under Create a New MySQL Database And Database User, type a database name, a user name and a password, and press Create.

The new database form in hPanel

In List of Current MySQL Databases And Users, copy both full names, with the prefix hPanel adds, such as u123456789_.

The full names, with their prefix

In cPanel

Open MySQL® Database Wizard.

Type a name in New Database and press Next Step.

Type a Username and a password, and press Create User.

Tick ALL PRIVILEGES and press Next Step.

ALL PRIVILEGES ticked in cPanel

Copy both full names: cPanel may add your account name before them.

On another panel

Create a new database and a user with all privileges on it. Not sure how? Ask your host for exactly that.

What you type in the wizard

Wizard fieldWhat to type

Server Address (Host)localhost

Database NameThe full database name

UsernameThe full user name

PasswordThe user’s password

If the wizard cannot connect

If…Do…

It does not connect through localhostType 127.0.0.1 instead.

It says “The user name or the password is wrong.”Check both, with their prefix.

It says “This user may not reach this database.”Give the user all privileges (in cPanel, step 4).