HF PanelDocsv1.0.0

MySQL databases

Create MySQL databases and users, set privileges, import and export .sql files, and allow remote connections.

The MySQL databases screen manages your account's MySQL (MariaDB) databases: the databases themselves, the database users that connect to them, what each user may do, and which outside computers may connect. Your website connects with host localhost.

Where: Control Panel › Databases › MySQL databases

MySQL databases screen

The screen has three tabs — Databases, Users & privileges and Remote access — plus links to PostgreSQL and MongoDB. Open HF Studio at the top right opens the database browser in a new tab.

Create a database and user in one step

Quick create makes a database and a user of the same name with all privileges. It is the usual choice for one website, such as a WordPress site.

  1. Open the Databases tab.
  2. Under Quick create, type the rest of the Name after your account prefix, for example shop.
  3. Click Create.

The message at the top shows the database name, the user (the same name), a random 20-character password and the host localhost.

Important: the password is shown only once. Copy it into your website's configuration before you leave the page. You can set a new one later under Users & privileges if you lose it.

Create a database only

  1. Under Database only, type the rest of the Name.
  2. Click Create.
  3. Add one or more users to it on the Users & privileges tab.
Rule Detail
Name your account name, _, then 1–15 lowercase letters, numbers or _
Reserved names some names are reserved; the panel says That name is reserved. Choose another.
Limit MySQL and PostgreSQL databases count together towards your package's database limit

The databases list

The list shows each database's Size and its Users (hover over a user to see its privileges). A database with no users shows no users yet.

Button What it does
Browse opens the database in HF Studio, in a new tab
Export downloads the database as a compressed .sql.gz file named with the database name, date and time
Import uploads a .sql or .sql.gz file (up to 1 GB) into the database. Tables with the same names are replaced.
Delete deletes the database after you type its name to confirm

Import a .sql file

  1. Click Import next to the database.
  2. Choose a .sql or .sql.gz file.
  3. Click Import.

Delete a database

  1. Click Delete next to the database.
  2. Type the database name exactly.
  3. Click Delete.

Warning: all data in the database is lost. Its users stay, so you can delete them separately on the Users & privileges tab.

Users and privileges

Create a database user

  1. Open the Users & privileges tab.
  2. Under New user, type the rest of the User name after your account prefix.
  3. Type a Password, or leave it blank to have one generated.
  4. Click Create user. The password is shown once in the message at the top.

A password must be 8–128 characters and cannot contain quotes ('), backslashes or control characters.

Give a user access to a database

  1. Under Add a user to a database, choose the User and the Database.
  2. Leave All privileges ticked, or untick it and tick the privileges you want. Read (SELECT), Add rows, Change rows and Delete rows are ticked by default.
  3. Click Save privileges.

Saving again for the same user and database replaces the privileges.

Privilege MySQL privilege
Read (SELECT) SELECT
Add rows INSERT
Change rows UPDATE
Delete rows DELETE
Create tables CREATE
Drop tables DROP
Indexes INDEX
Alter tables ALTER
Temporary tables CREATE TEMPORARY TABLES
Lock tables LOCK TABLES
Execute EXECUTE
Create views CREATE VIEW
Show views SHOW VIEW
Create routines CREATE ROUTINE
Alter routines ALTER ROUTINE
Events EVENT
Triggers TRIGGER
References REFERENCES

The users table shows, in Can use, every database a user may use and its privileges (or all privileges). Click the × next to a database to remove the user from it.

Change a user's password or delete a user

  1. Click Manage next to the user.
  2. To change the password, type a New password (blank = generate) and click Set. The new password is shown once — update your website's config file.
  3. To delete the user, click Delete user and confirm.

Remote access

By default only programs on the server can connect. Remote MySQL lets programs on other computers — a desktop database tool or another server — connect on port 3306. Only the addresses you list get through the firewall.

  1. Open the Remote access tab.
  2. In Allowed IP addresses, enter one address per line. You can use ranges such as 198.51.100.0/24 (IPv4 only). The hint shows your current IP address.
  3. Click Save.

Once addresses are saved, the screen shows the Host (the server's IP address and port 3306) and that any of your database users can sign in.

Rule Detail
Addresses up to 20, separated by new lines, spaces or commas
Ranges CIDR ranges are accepted for IPv4; IPv6 addresses must be single addresses
Switch off leave the box empty and click Save

Tip: list only the addresses you need. Every address you add can try to sign in to your databases.