A database user is a login account that allows a website or application to connect to a MySQL database.
The database user controls access to the database and determines what the website is allowed to do with the data.
Most database-driven websites need a database, a database user, and a database password to work correctly.
Why Does a Website Need a Database User?
A website needs a database user so it can connect to the database securely.
For example, a WordPress website needs to connect to its database to load:
- Pages
- Blog posts
- Users
- Settings
- Menus
- Plugin settings
- Theme settings
- Products and orders, if using WooCommerce
The website uses the database username and password to access this information.
Database Name vs Database User
The database name and database user are not always the same thing.
The database name is the name of the database where information is stored.
The database user is the login account that is allowed to access the database.
For example:
Database name: username_wp123
Database user: username_wpuser
The exact names depend on how the database was created.
What Is a Database Password?
A database password is the password used by the database user.
The website needs the correct database password to connect to the database.
If the database password is changed in DirectAdmin but not updated in the website configuration file, the website may stop working.
For WordPress, database connection details are usually stored in:
wp-config.php
What Are Database Permissions?
Database permissions control what the database user is allowed to do.
Depending on the permissions, a database user may be able to:
- Read data
- Add data
- Update data
- Delete data
- Create tables
- Drop tables
- Manage database structure
Most websites need the correct permissions to work properly.
Can One Database User Access More Than One Database?
Depending on the hosting setup, a database user may be assigned to one or more databases.
For security and organization, it is usually better to use the correct database user for the correct website database.
Avoid sharing database users across unrelated websites unless there is a clear reason.
What Happens If the Database User Is Wrong?
If the database user is incorrect, the website may not be able to connect to the database.
This can cause errors such as:
- Error establishing a database connection
- Database connection failed
- Access denied for user
- Website showing a blank page
- Application installation errors
What Happens If the Database Password Is Wrong?
If the database password is wrong, the website cannot log into the database.
This can happen if:
- The database password was changed
- The website configuration file was not updated
- The wrong password was entered during installation
- A migration used incorrect database details
- A backup was restored with old settings
Step 1 – Log Into DirectAdmin
Open your browser and visit: https://cp.yourdomain.co.za (Replace yourdomain.co.za with your own domain name.)
Enter your DirectAdmin username and password.
Click: Log In
Step 2 – Open MySQL Management
Once you are logged into DirectAdmin, open the database area.
Click: Account Manager
Then click: Databases
From here, you can view databases and database users.
Step 3 – Check the Database and User
Look for the database you want to check.
Locate: Database name, example: username_wp123
Check which database user is assigned to that database.
The available options and wording may differ depending on the DirectAdmin version.
Database Users and WordPress
For WordPress websites, the database user details are stored in the wp-config.php file.
Common WordPress database settings include:
DB_NAME
DB_USER
DB_PASSWORD
DB_HOST
These values tell WordPress which database to use and how to connect to it.
Do not change these values unless you know the correct database details.
Important Notes
Please keep the following in mind:
- A database user allows a website to connect to a database.
- The database name and database user may be different.
- Changing the database password can break a website if the website configuration is not updated.
- Database permissions affect what the website can do.
- Keep database passwords secure.
- Do not share database login details unless necessary.
When Should I Contact HostworX Support?
Contact HostworX Support if:
- Your website cannot connect to the database.
- You are unsure which database user belongs to your website.
- You changed a database password and the website stopped working.
- You need help checking database permissions.
- You see an “Access denied for user” error.
- You are moving a website and need help with database details.
Conclusion
A database user is the login account that allows your website to connect to a MySQL database.
The correct database name, database user, password, and permissions are needed for the website to work.
Always handle database users and passwords carefully, as incorrect changes can cause database connection errors.
