MySQL & phpMyAdmin

Databases store your website's dynamic content — WordPress posts, WooCommerce orders, user accounts, and more. Hoststack.pro includes MySQL databases with phpMyAdmin on every plan.

Create a database and user

1. Log in to cPanel and go to Databases → MySQL Databases.
2. Under Create New Database, enter a name (e.g. mysite) and click Create Database. The full name will be cpaneluser_mysite.
3. Scroll to MySQL Users → Add New User. Enter a username and a strong password. Click Create User.
4. Under Add User to Database, select your new user and database, click Add.
5. On the privileges page, tick All Privileges and click Make Changes.

Note the database name, username, and password — you'll need them when configuring your application (e.g. WordPress wp-config.php).

phpMyAdmin — manage your database visually

1. In cPanel, go to Databases → phpMyAdmin.
2. Select your database from the left panel.
3. Browse tables, run SQL queries, and manage your data.

Import a database (SQL dump)

1. Open phpMyAdmin and select your database.
2. Click the Import tab at the top.
3. Click Choose File and select your .sql file.
4. Set character set to utf8mb4 and click Import.

For large databases (>50 MB), the upload may time out. Use SSH or ask support to import the file directly from the server.

Export a database (backup)

1. Open phpMyAdmin and select your database.
2. Click the Export tab.
3. Choose Quick format (SQL) and click Export.
4. Save the .sql file to your computer.

Database connection settings

Use these when configuring your application's database connection:

Remote database access

To connect to your database from an external tool (TablePlus, Sequel Pro, DBeaver):

1. In cPanel, go to Databases → Remote MySQL.
2. Add your local IP address (find it at whatismyip.com).
3. Connect using your server hostname (not localhost), port 3306, and your database credentials.