How to Create and Manage MySQL Databases via phpMyAdmin

Database Management

A step-by-step guide to setting up MySQL databases, importing SQL dumps, and obtaining database credentials in VistaPanel.

🎥 Video Tutorial

Watch this video to learn how to create MySQL databases and access phpMyAdmin in your hosting control panel:

📌 Overview

Dynamic applications like WordPress, custom PHP scripts, and forums require a MySQL Database to store posts, user profiles, and site settings. On Scynr Free Hosting, databases are managed through VistaPanel and phpMyAdmin.

💡 System Prefix Notice: To ensure security on shared hosting servers, all database names and database usernames are automatically prefixed with your account ID (e.g., epiz_12345678_dbname).

1. Creating a New MySQL Database

1. Log in to your VistaPanel at http://cpanel.host.scynr.xyz.

2. Scroll down to the Databases section and click on MySQL Databases.

3. Under Create a New Database, enter a short database name into the input field.

4. Click Create Database.

🔑 Your Database Credentials:

• MySQL Hostname: Displayed on the MySQL Databases page (e.g., sqlXXX.scynr.xyz). *(Do NOT use `localhost`)*.

• Database Name: The full string including prefix (e.g., epiz_12345678_mydb).

• MySQL Username: Your main VistaPanel account ID (e.g., epiz_12345678).

• MySQL Password: Your main VistaPanel account password.

2. Importing SQL Files via phpMyAdmin

If you are transferring a site or installing a custom script, follow these steps to import an existing .sql database file:

1. In VistaPanel, go to Databases $\rightarrow$ phpMyAdmin.

2. Find your newly created database in the list and click Connect / Admin beside it.

3. Inside phpMyAdmin, click the Import tab at the top menu bar.

4. Click Choose File and select your .sql file from your computer.

5. Scroll down and click the Go button to run the import process.

🎉 Import Complete: A green notification banner will display showing the total number of SQL queries successfully executed.

❓ Troubleshooting Connection Errors

Why does my PHP script show "Error Connecting to Database"?

This usually occurs when using `localhost` as the database host instead of the specific MySQL server hostname provided inside VistaPanel (e.g., `sql123.host.scynr.xyz`). Always copy the exact MySQL Hostname listed on your **MySQL Databases** dashboard page.

What is the max import file size limit in phpMyAdmin?

The web-based phpMyAdmin import upload limit is 10 MB. For larger database files, compress your database into a `.zip` or `.gz` archive before uploading, or split the `.sql` file into smaller parts.

Database Import Failing?

If you receive SQL syntax errors or execution timeouts during import, open a ticket for technician assistance.

Contact Database Support