Databases

Databases are the foundation for dynamic websites — WordPress, e-shops, forums, and applications. CoreSynth supports MySQL and PostgreSQL.

Overview

Creating a Database

Step 1 — New database

1. Log in to the control panel
2. Go to Databases → Create Database
3. Select type: MySQL or PostgreSQL
4. Enter database name
5. Set password (or let it generate automatically)
6. Click Create

Step 2 — Credentials

After creation, you will receive:

Note: Host is always localhost. Never use external IP or hostname.

Managing Databases

PhpMyAdmin (MySQL)

Access via panel → Databases → PhpMyAdmin.

Features:

• Browse tables
• Run SQL queries
• Export/import data
• User management

PhpPgAdmin (PostgreSQL)

Access via panel → Databases → PhpPgAdmin.

Features:

• Table management
• SQL editor
• Export/import
• Schema management

Changing Password

Warning: After changing password, you must update configuration of all applications using the database (e.g., WordPress config, e-shop).

1. Go to Databases → Manage Databases
2. Select database → Change Password
3. Enter new password
4. Save

Remember to update wp-config.php or similar configuration file of your application.

Database Backup

Export via PhpMyAdmin

1. Log in to PhpMyAdmin
2. Select database in left panel
3. Click Export in top menu
4. Choose format (recommended: SQL)
5. Click Go

Restore from backup

1. In PhpMyAdmin select target database
2. Click Import
3. Select backup file (.sql)
4. Click Go

Remote Access

By default, database is accessible only from the webhosting server (localhost).

Enabling remote access

Warning: Remote access may pose a security risk. Enable only for trusted IP addresses.

1. Go to Databases → Manage Databases
2. Select database → Remote Access
3. Add allowed IP addresses
4. Save changes

Connection will then be possible from allowed IPs:

<?php
$host = 'localhost';
$dbname = 'your_database';
$user = 'your_username';
$password = 'your_password';
 
try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
    echo "Connected successfully";
} catch (PDOException $e) {
    echo "Connection error: " . $e->getMessage();
}
?>

Connection Limits

Exceeding the limit will cause Too many connections error.

Deleting a Database

Warning: Deleting a database is irreversible. All data will be permanently removed. Create a backup before deleting.

1. Go to Databases → Manage Databases
2. Select database → Delete
3. Confirm deletion

Troubleshooting

Connection error

Cause: Incorrect credentials or host.

Solution:

1. Verify host is localhost
2. Check database name, user, and password
3. Verify application uses correct port (MySQL: 3306, PostgreSQL: 5432)

Too many connections

Cause: Connection limit exceeded.

Solution:

1. Wait for active connections to finish
2. Optimize application — close connections after use
3. Consider upgrading to a higher package

Disk quota exceeded

Cause: Database consumed all allocated storage.

Solution:

1. Check disk usage in panel
2. Delete unnecessary data or tables
3. Optimize database (PhpMyAdmin → Operations → Optimize tables)

Next Steps

• Web Hosting — Full hosting overview
• FTP — File uploads
• Domains — Domain management
• DNS — DNS settings

Need help? Open a support ticket  or ask Alex in your dashboard.