English
Magyar
Imagine that frustrating moment when, as you’re launching your new website, all you see on the screen is an “Error establishing a database connection” message. Even the smallest mistake made whilst creating a database in cPanel – be it a forgotten database prefix or incorrect permission settings – can result in hours of unnecessary work. We recognise that the cPanel interface may seem complicated at first, and it’s understandable if you’re worried about incorrect settings that could jeopardise your site’s stability or security.
This detailed guide will show you exactly how to create a MySQL database and an associated user, whilst confidently avoiding the most common connection errors. In our experience, 38 per cent of users get stuck when it comes to assigning user rights correctly, so we’ll walk you through the correct process step by step. We’ll also cover the importance of prefixes, generating secure passwords, and methods for verifying a successful database connection. Our aim is to ensure that by 2026, you’ll be able to manage your hosting platform without any technical hitches, thereby guaranteeing the smooth and fast operation of your website.
What is a MySQL database and why is it essential for your cPanel hosting?
Modern websites are not just a collection of static files. The ‘brain’ and ‘memory’ of your website is the MySQL database, where all dynamic content is stored. This is where blog post texts, user profile data, encrypted passwords and all your site’s unique settings are stored. By 2026, over 92 per cent of websites – including WordPress sites and online shops – will be built on database-driven systems, as this enables fast and flexible content management.
Many people make the mistake of focusing solely on uploading files via FTP. However, this alone is not enough. Whilst images and style sheets (CSS) are treated as files, the actual information is retrieved from the database by the server when a visitor makes a request. The cPanel interface has become indispensable because it provides a graphical interface instead of complex SQL command lines. With its help, the process of creating a database in cPanel becomes straightforward, so you don’t need to be a database administrator to launch your website.
When do you need a new database? Most commonly, when you install a new WordPress site or want to populate a subdomain with its own content. Using separate databases is also crucial from a security perspective. If you’re running multiple projects on a cPanel hosting account, it’s recommended that you assign a separate database to each application, so that any software errors won’t affect your other websites.
How is a database connection established?
Database management consists of three fundamental elements that are closely interlinked. You need a unique database name, which serves as the identifier for the database. You also need to create a database user who is granted permission to read and write data. The third pillar is the password. For security reasons, never use simple phrases. Use cPanel’s built-in password generator, as weak passwords account for 75 per cent of successful brute-force attacks. This three-part system ensures that only the authorised application can access sensitive information.
The importance of prefixes in cPanel
In shared hosting environments, cPanel applies an automatic prefix to all database and username names. This is usually your hosting account username, for example: felhasznalonev_adatbazis. This is not an optional feature, but a mandatory technical requirement. It enables the system to ensure that the thousands of customers on the server cannot create databases with identical names, which would lead to data loss.
When creating a database in cPanel, you must always use the full name in the configuration files. If you omit the prefix, your website will be unable to connect to the server, and you will receive a “Database Connection Error” message. Prefixes also help keep your account organised if, for example, you are managing ten different websites on the same platform, as this makes it immediately clear which database belongs to which account.
Step-by-step guide to creating a cPanel database: The MySQL Database Wizard
Logging into the cPanel interface is the essential first step, which you can access 24 hours a day via domain.hu/cpanel or through the aWh client portal. Based on aWh’s more than 10 years of experience, the quickest and most secure way for users is to use the ‘MySQL Database Wizard’ found in the ‘Databases’ section. This tool guides the user through a logical, step-by-step process, thereby helping to avoid technical oversights or permission errors when creating a cPanel database.
The first step is to choose a name for the database. It is important to note that the system automatically assigns a prefix to the name, which is the same as your cPanel username. For technical reasons, the full name must not exceed 64 characters. Choose a short but distinctive name, particularly if you are running multiple projects on the same hosting account.
The second section covers user creation and setting the security level. In the modern web ecosystem, password strength is non-negotiable. We recommend using the built-in generator, which creates complex strings containing uppercase and lowercase letters, numbers and symbols. A password of at least 16 characters is now a basic requirement for protection against brute-force attacks. Be sure to save your login details in a secure password manager before proceeding.
The third step is to assign privileges. This determines what actions the newly created user can perform on the data. Most popular content management systems, such as WordPress or Joomla, require ‘All Privileges’ to be selected. This enables the installation scripts to create tables, update data and modify the database structure. The official cPanel documentation also recommends this approach for general-purpose websites in order to avoid compatibility issues.
The benefits of using the wizard
Unlike manual configuration, using the wizard ensures that no critical settings are left out of the process. The system automatically connects the new user to the database in the background, which is usually the biggest challenge for beginners. This method is extremely effective for a quick WordPress installation, as it minimises the chance of database connection errors (Error Establishing a Database Connection).
Common pitfalls when using the wizard
The most common mistake is losing the generated password before completing the process. Always use your browser’s password manager or a third-party application to store your details. Using special characters in the database name can also cause problems; use underscores instead of spaces or accented letters. If you’d like further technical details about the control panel, please read on in our cPanel hosting guide. For stable performance, choose an NVMe-based web hosting plan, which enables lightning-fast database operations.
Manual database management and setting up permissions
The wizard is convenient to use, but professional developers often opt for the manual ‘MySQL databases’ menu option. This interface offers greater flexibility if you’re not following the setup steps in a linear fashion. You should click here if you want to assign an existing user to a new database, or if you wish to use the same access credentials for multiple databases. The process of creating a database in cPanel is divided into three separate steps: entering the database name, creating the user, and then linking the two.
This is also where you manage your existing items. If your hosting plan allows it, you can rename databases or check their integrity using the ‘Check Database’ function. Be careful when deleting items; this action cannot be undone, and the data will be destroyed immediately. Always make a backup before making any structural changes to the system.
The cornerstone of security is the principle of ‘least privilege’. This means that a user should only be granted as much power as is absolutely necessary to carry out their tasks. For a simple blog engine, it is unnecessary to grant every possible permission. If an attacker gains access to the configuration file, restricted permissions can prevent them from deleting the entire database or taking control of the server.
Types of permissions in cPanel
When managing permissions, we distinguish between two main groups. The basic operations include SELECT, INSERT, UPDATE and DELETE. These enable data to be read, recorded and modified. These are essential for the day-to-day operation of an average website. If you’re interested in the technical background in more detail, the MySQL database documentation explains how they work in detail.
The more dangerous, structural privileges are DROP, ALTER and INDEX. These can be used to modify the structure of tables or delete their entire contents. Whilst these are useful in a development environment, it is advisable to restrict them on live production sites. In certain cases, such as with external reporting tools, it is advisable to grant only ‘Read Only’ (SELECT) rights, so that the analytics software cannot accidentally cause any damage to the data.
Managing users when using multiple databases
A common mistake is to assign a single MySQL user to all databases. Whilst this may seem convenient, it poses a huge security risk. If one of your websites is hacked, the attacker can access all your other databases using the same login details. When creating a database in cPanel, aim for segregation. Create a unique user and a strong, generated password for each project.
Keep developer and production access separate. Provide developers with restricted databases specific to the test environment. For maximum control and a stable infrastructure, choose one of aWh’s cPanel hosting solutions, where state-of-the-art NVMe storage ensures fast database operations. Structured user management not only enhances security but also improves transparency when running multiple applications on the same account.
How to connect to your new database? Settings and troubleshooting
Once you have successfully created a cPanel database, the next step is to link the data to your website’s content management system. This process usually involves editing a configuration file. For WordPress-based sites, you’ll need to locate the wp-config.php file in the root directory, whilst for Joomla or custom systems, these parameters are often contained in a configuration.php or .env file. You must specify four critical values accurately in the file: the database name, the username, the password and the hostname.
One of the most common mistakes made by beginners is the format of the names. In the cPanel environment, the system automatically adds the hosting account ID as a prefix to the database and user names. If your username is “webshop” and you have named the database “db1”, you must enter the full name “webshop_db1” in the configuration file. For the DB_HOST value, use “localhost” in 99.8 per cent of cases. This tells the system that the database is located on the same physical server as your website’s files, ensuring a lightning-fast and secure connection.
A list of the most common connection errors
- “Access denied for user”: This usually means the password has been entered incorrectly. Another common reason is that, although you have created the user, you have forgotten to assign them to the database via the cPanel interface.
- “Unknown database”: The system cannot find the database. Check that you have used the full name, including the prefix, and that there are no extra spaces in it.
- “Can’t connect to local MySQL server”: If the host name is “localhost” and you still see this message, it may indicate a server-side error. In this case, it’s worth checking your provider’s status page.
Remote MySQL access
In certain cases, you may need to access data from an external location rather than from the web server. This typically occurs when you are using a local development environment (such as XAMPP) but wish to work with the live database, or when you are using external desktop database management software (such as HeidiSQL). For security reasons, cPanel blocks external access by default.
To enable this, you need to add your own IP address to the whitelist in the ‘Remote MySQL’ section of cPanel. Never use the ‘%’ character (which allows all IP addresses), as this poses a serious security risk. If you get stuck on the technical details, visit the aWh Knowledge Base for more detailed guides.
The right configuration is essential for stable operation. If you want to run your website in a modern and fast environment, take a look at our cPanel hosting solutions, where automated systems help with your day-to-day work.
Database maintenance and security on aWh’s servers
Once you have successfully created a cPanel database, the work is not over. To ensure the long-term stability of a website, it is essential to maintain and protect the data on an ongoing basis. Databases are prone to ‘degradation’: deleted records leave empty spaces, and indexes can become fragmented. On the cPanel interface, the ‘Repair’ and ‘Optimise’ functions are available under the ‘MySQL Databases’ menu item. It is recommended that you run these once a month, as they remove unnecessary data fragments, thereby speeding up query execution times.
For us, security isn’t an option – it’s standard. aWh’s infrastructure employs multi-layered protection, but responsible operation also requires user awareness. Although our systems perform automatic backups on a daily basis, you should always create a manual backup before carrying out a major update or installing a plugin. This extra layer of security can save your work in the event of an unexpected error.
phpMyAdmin: The visual editor
phpMyAdmin is the industry-standard tool that allows you to manage databases without in-depth knowledge of the SQL language. With it, you can browse tables directly, edit the contents of cells or run custom queries. Its key features include:
- Manual export: On the ‘Export’ tab, you can download the entire database to your own computer in .sql format.
- Import: Uploading existing SQL dump files, which is crucial during migration or restoration.
- Search & Replace: If your website’s URL changes, you can use this feature to update all links in the database in a matter of seconds.
Why choose aWh’s professional environment?
The process of creating a database in cPanel with us is not only simple, but also technically supported. With over 10 years’ experience behind it, aWh has built an environment where database operations do not cause bottlenecks. Our servers use exclusively NVMe SSD-based storage, capable of read speeds of up to 3,500 MB/s, ensuring that even the most complex SQL queries run at lightning speed.
Automation is our motto: with our JetBackup system, managing backups and point-in-time recovery is child’s play. You don’t need to worry about data loss, as our redundant storage system and daily backup routine guarantee operational reliability. Our customers enjoy 99.9% uptime, whilst state-of-the-art AMD Epyc processors provide the computing power.
Don’t settle for slow and outdated solutions where your database struggles under heavy load. Choose a partner who understands the technological challenges and provides a stable foundation for growth.
Choose lightning-fast cPanel hosting with aWh!
Take your website’s performance to the next level in 2026
A properly configured MySQL environment is the foundation of every modern and dynamic website. The process of creating a database in cPanel using the built-in wizard takes just a few minutes, whilst the precise configuration of permissions and regular maintenance ensure stability in the long term. Database response times directly affect the user experience and search engine optimisation results. This is why the hardware environment in which you run your queries on a day-to-day basis is critical.
With over 10 years’ professional experience, the aWh team supports website owners in their digital development. Our infrastructure is built exclusively on extremely fast NVMe SSD-based servers, ensuring lightning-fast loading times even under heavy load. Should you ever get stuck with the setup or troubleshooting process, our 24/7 expert support team is on hand every minute of the day to provide you with technical assistance.
Choose a technical infrastructure where security and speed are never compromised. Discover aWh’s lightning-fast cPanel hosting plans! Start building on a foundation that can withstand growth and the challenges of the future.
Frequently asked questions about cPanel databases
How many databases can I create in cPanel?
The number of databases you can create depends primarily on the hosting plan you choose. aWh offers flexible limits, so smaller plans typically allow for 5 or 10 databases, whilst larger plans may offer an unlimited number of databases. Always check the current specifications of your plan via the client portal to see the exact quotas.
Why do I need to use a prefix before the database name?
The prefix identifies your unique user account within the shared server environment, where several thousand separate databases may exist simultaneously. This technical prefix, which usually consists of your cPanel username followed by an underscore, prevents name conflicts with databases belonging to other customers that have the same name. When creating a cPanel database, the system automatically adds this to the name for security and system-level distinguishability.
What is the difference between MySQL and MariaDB in cPanel?
From a functional point of view, MySQL and MariaDB are almost identical, but MariaDB often offers faster performance and more modern optimisation algorithms. MariaDB is an open-source fork of MySQL, which is being further developed by the community to improve efficiency. Most CMS systems, such as WordPress or Magento, handle both types perfectly, so switching does not require any code changes.
How can I change my database password?
You can update your database password via the ‘Password Change’ option found in the ‘MySQL Databases’ menu in cPanel, under the list of users. It is important that, after changing your password, you also update the new login details in your website’s configuration file, such as the wp-config.php file. If you forget to do this, your site will be unable to connect to the server and will display an error message to visitors.
Will my data be lost if I delete the database user?
No, the data is not lost when a user is deleted, as the database and the associated user are two separate entities within the system. However, after deletion, the website can no longer connect to the tables, so the site becomes inaccessible. After creating a database via cPanel, always ensure that user permissions are set correctly; otherwise, although the data will remain intact, the system will be unable to read it.
What is the maximum size a MySQL database can be?
The maximum size of a database is primarily limited by the total quota of your hosting plan, but you should avoid using 100 per cent of this quota. To ensure optimal speed and fast backups, it is advisable to keep the size of individual databases below 1 or 2 GB. Tables larger than 2 GB can noticeably slow down queries, which impairs the user experience and increases page load times.
How can I run automated tasks on the database?
For recurring database operations, use the cPanel Cron Jobs feature, which allows you to run scheduled commands. This solution is ideal for automatic cleaning, updating statistics or archiving redundant data. For precise technical settings, read our comprehensive guide to cPanel Cron Jobs, where we explain each step in detail.