StarDomain
Databases (MySQL / phpMyAdmin)

How to Manage MySQL Databases

By the StarDomain teamPublished 3 min read
Knowledge base article
Contents (3 sections)

Most web applications, including WordPress, store their content in a MySQL database. This guide shows how to create and work with databases on StarDomain hosting.

Key takeaways

Container Hosting: create databases in the Databases tab. The password is shown once, so copy it straight away. There is no phpMyAdmin and no remote access. DirectAdmin hosting: use MySQL Management, with phpMyAdmin for browsing, importing and exporting.

1. Container Hosting

  1. Open your container
    in the client area and go to the Databases tab.
  2. Choose New Database.
    Start the name with a letter and use only lowercase letters, digits and underscores.
  3. Copy the password now.
    Each database gets its own user and a generated password, shown once. If you lose it, the only fix is to delete the database and create a new one.
  4. Use the full name shown.
    The panel adds your container's prefix to the name you typed.

Connect from your site with host localhost. Databases can only be reached from inside your own container: there is no phpMyAdmin and no remote MySQL access. To browse or edit data, you can upload a tool such as Adminer to public_html, use it, then remove it. Your databases are included in the daily backups. More detail is in MySQL Databases.

2. DirectAdmin hosting

  1. Log in to DirectAdmin
    and open MySQL Management.
  2. Create a new database.
    Enter the database name, a username and a strong password. DirectAdmin creates the database and the user together.
  3. Use phpMyAdmin
    from the same page to browse tables, run SQL, and import or export.

See Creating and Managing MySQL Databases in DirectAdmin and Using phpMyAdmin in DirectAdmin.

3. Good habits

  • Export before big changes. Deleting a database cannot be undone.
  • Use a unique, strong password for each database user.
  • Remove databases and users you no longer need.
Is phpMyAdmin available on Container Hosting?

No. Databases are reachable only from your own container. You can upload a tool such as Adminer temporarily, or restore a backup on your own computer.

I lost the database password on Container Hosting. Can I see it again?

No, it is shown only once. Delete the database and create a new one, after making sure you have a backup of its data.

Are my databases backed up?

On Container Hosting, yes, daily, and you can restore a single database from the Backups tab. DirectAdmin hosting is backed up weekly.

Was this article helpful?

Your answer helps us decide what to improve next.

Still need help? Open a support ticket and our team will reply.

Prefer an app? Add this site to your home screen.Get the app
Need Help?
New TicketTrack TicketKnowledge BaseContact Us
How to Manage MySQL Databases