Knowledge Base
cPanel mein MySQL Database Banayein aur SQL Import Kaise Karein
از Pakish Support Team5 منٹ پڑھنے کا وقتcPanel
شیئر اور AI
یہ مفید لگا؟
اپنی ٹیم کے ساتھ شیئر کریں یا اپنے AI اسسٹنٹ سے دوسری رائے لیں۔
Knowledge Base
یہ مفید لگا؟
اپنی ٹیم کے ساتھ شیئر کریں یا اپنے AI اسسٹنٹ سے دوسری رائے لیں۔
خلاصہ
AI اور سرچ citation کے لیے Pakish Group (Pakish.NET) کا خلاصہ۔
Create MySQL databases in cPanel through Database Wizard or Manage My Databases — never create cPanel-managed databases directly inside phpMyAdmin. Add a database user, assign ALL PRIVILEGES on that database only, then open phpMyAdmin to import your .sql file. Use the full prefixed database name and username in wp-config.php or your application settings.
See the cPanel beginner's guide. WordPress troubleshooting: known WordPress bugs.
wp-config.php with full prefixed credentials| Item | Details |
|---|---|
| Backup | Export existing database if replacing data |
| SQL file | .sql dump from source site |
| Credentials | Note database name, user, password |
Create or confirm a usable backup first. Availability and limits may vary by hosting plan or server configuration.
| Tool | Best for | |---|---| | Database Wizard | Step-by-step first database + user setup | | Manage My Databases | Creating additional databases, users, and privilege edits |
Both create properly prefixed cPanel-managed databases.
wpdb) → Next Stepusername_wpdbOn shared hosting, cPanel prefixes names:
cpuser_mydbcpuser_mydbuserAlways use the full prefixed values in application configuration.
.sql dumpIf import fails due to size limits, split the file or contact support about limits.
Also consider JetBackup 5 for server-side snapshots.
For WordPress, also try plugins like WP-DBManager or hosting tools before manual repair.
WordPress wp-config.php:
define('DB_NAME', 'username_database_name');
define('DB_USER', 'username_database_user');
define('DB_PASSWORD', 'your_password');
define('DB_HOST', 'localhost');Back up wp-config.php via File Manager before editing.
| Error | Fix | |---|---| | Access denied for user | Wrong password or user not added to database | | Unknown database | Typo in prefixed database name | | #1044 — cannot create database | Create DB in cPanel, not phpMyAdmin | | Import too large | Split SQL; check upload limits | | #1273 — unknown collation | Export from compatible MySQL version |
wp-config.php if credentials changed incorrectlyContact support for remote database hosts, import size limits, corrupted tables that will not repair, or migration assistance. See managed WordPress migration guide or /support.
No. Create databases and users through cPanel Database Wizard or Manage My Databases. phpMyAdmin is for managing data inside databases that cPanel already created.
cPanel adds your account username as a prefix to database and user names for isolation on shared servers. Use the full prefixed name in wp-config.php and application settings.
Assign ALL PRIVILEGES for a dedicated WordPress database user on that database only. Never grant global privileges beyond what the application needs.
Split large SQL files, use command-line import via SSH if available, or compress the SQL file. Upload limits may vary by hosting plan or server configuration.
Open phpMyAdmin, select the database, click Export, choose Quick method and SQL format, then download the file. Store it off-site before imports or schema changes.
Migrate with confidence on managed WordPress hosting — staging, backups, and database support included.