Skip to main content
Blog|
Knowledge base

MySQL databases

|
Feb 28, 2026|5 min read
KNOWLEDGE BASEMySQL databasesHOSTNEYhostney.comAugust 21, 2023

The MySQL databases page lets you create and manage databases, database users, and external access – all from one place. You’ll find it under Hosting > MySQL databases.

The page has three tabs: Databases, Users, and External users.

Databases tab#

Creating a database

Click Create database to generate a new MySQL database. The only optional field is a label (up to 30 characters) to help you remember what the database is for, like “Production” or “Staging”. The database name itself is auto-generated and uses UTF-8 encoding.

After creation, a banner shows the database name with a copy button. Copy it now if you need it for your application’s configuration.

Database list

The table shows all your databases with these columns:

  • Database – The auto-generated database name
  • Label – Your optional description
  • Users – How many users (local and external) have access
  • Size – Current size and limit (e.g., “12 MB / 500 MB”). Shown in yellow when the database is read-only
  • Status – Either “Active” (green) or “Read-only” (yellow with a lock icon). A database becomes read-only when it exceeds its size limit. Delete some data to unlock it.
  • Created – When the database was created

Database actions

Click the dropdown menu on any database row for these options:

Connection info opens a modal with everything you need to connect:

  • Database name, host (localhost for local connections), external host (for remote connections), and port (3306)
  • A ready-to-copy MySQL command for local connections:  mysql -u USERNAME -p -h localhost dbname
  • A ready-to-copy command for external connections with SSL:  mysql -u USERNAME -p -h hostname --ssl-mode=REQUIRED dbname

Add user lets you assign a local or external user to the database. A dropdown shows all available users not yet assigned. Once assigned, the user can connect to and work with that database.

Assigned users shows everyone who currently has access. You can remove a user’s access by clicking the delete button next to their name.

Change label lets you update the database’s description.

phpMyAdmin creates a secure single sign-on session to phpMyAdmin. Click Create session and you’ll get a 60-second window to click Open phpMyAdmin. The session timer counts down in real time. If it expires, create a new session. This is passwordless authentication – you don’t need to enter credentials.

Delete permanently removes the database and all its data. Type DELETE to confirm. This cannot be undone.

Users tab#

Local users connect to MySQL from within your hosting account – through your website’s code, SSH, or phpMyAdmin.

Creating a user

Click Create user. The only optional field is a label (up to 30 characters). The username and a strong 16-character password are generated automatically.

After creation, a banner shows the username and password with copy buttons. Copy the password now – it’s only shown once and cannot be retrieved later.

User list

The table shows:

  • Username – The auto-generated MySQL username
  • Label – Your optional description
  • Databases – How many databases this user can access
  • Created – When the user was created

User actions

Change label updates the user’s description.

Change password lets you set a new password. You can type one or click the generate button for a random 16-character password. Requirements: at least 16 characters, must include a lowercase letter, an uppercase letter, and a number. Only alphanumeric characters are allowed.

Assigned databases shows which databases the user can access, with the option to remove access.

Delete permanently removes the user and revokes all database access. Type DELETE to confirm.

External users tab#

External users connect to MySQL remotely from outside your server. Every external connection requires SSL and is restricted to specific IP addresses that you define.

Creating an external user

Fill in the form:

  1. Label (optional) – Up to 100 characters, e.g., “Production API server”.
  2. Allowed IP addresses (required) – Enter at least one IP address or CIDR range that this user can connect from. Supported formats:
    • IPv4:  192.168.1.100
    • IPv4 CIDR:  10.0.0.0/24
    • IPv6 and IPv6 CIDR
    Click the + button to add more IPs, or click Insert my IP to automatically fill in your current IP address. Localhost and wildcard addresses are not allowed.
  3. Click Create external user.

After creation, a banner shows the username, password, external host, and allowed IPs. Copy the password immediately – it won’t be shown again.

External user list

The table shows:

  • Username – The auto-generated MySQL username
  • Label – Your optional description
  • Allowed IPs – The first IP address, plus “+ N more” if there are multiple. Hover to see the full list.
  • Databases – How many databases this user can access
  • Created – When the user was created

External user actions

Manage IPs lets you add or remove allowed IP addresses. At least one IP must remain. The same validation rules apply as during creation.

Change label updates the user’s description.

Change password works the same as for local users, with the same 16-character alphanumeric requirements.

Assigned databases shows which databases the user can access, with the option to remove access.

Delete permanently removes the user and all IP-based access rules. Type DELETE to confirm.

Connecting to your database#

From your website’s code

Use the connection details from the Connection info modal. Your application needs:

  • Host:  localhost
  • Port:  3306
  • Database: The database name
  • Username: A local user assigned to the database
  • Password: The user’s password

From phpMyAdmin

Click phpMyAdmin in the database’s dropdown menu. A secure session is created automatically – no credentials needed.

From an external application

Use an external user with the correct IP whitelisted:

  • Host: The external hostname shown in the connection info
  • Port:  3306
  • SSL: Required for all external connections
  • Database: The database name
  • Username: An external user assigned to the database
  • Password: The user’s password

Related articles