Admin restore complete but no database user

M

maiijarb

Verified User
Joined
Nov 8, 2006
Messages
65
Hello,

Normally when restoring the backup is complete. The website will now work.
But this time when visit the website it show Error establishing a database connection (Wordpress website)

MySQL Management > Database
Database Number of Users Download Backup Size Select
zzztest_wp1 1 Download .gz .sql 2.12 MB

User Modify Password Privileges Select
zzztest_wp1 modify password modify privileges

Displays correct results but no database user

When modify password
Error Updating User
Details
That user doesn't exist

Create New Database User The website can be used normally.

Is this problem only for the old OS?
I'm still using CentOS 7 with DirectAdmin (lastest version)

Thank you.
 
This shouldn't give any problem. Database and database user should be restored perfectly if the backup was correctly.
Centos 7 is not old yet... ;)

Is this a user backup or reseller backup or admin backup which is restored?
 
I try admin backup and user backup got the same results.
there is a list of databases. But it doesn't work. I need to create a database with the same name and password. The website can be used normally.

2023-09-03_10-31-57.png
 
maiijarb said:
I need to create a database with the same name and password.
Click to expand...
No you don't really need the exact same. You can also use a different databasename and password, you just have to adjust it in the wp-config.php file.

In this case, click on your zzztest_wp1 database and you will see the username. Is there a username visible?
It's probably zzztest_someting and it should have a password.

If you know the password, then go to the public_html of the site and change the wp_config.php with the current username and databasename (zzztest_wp1) and password and things should work.

Or was the backup you made also exactly the same like zzztest_wp1? Because I can't imagine. I've done various admin and reseller backups last week without problems. Also on Centos 7.

Do you have the latest DA version? And which mysql version? And which WP version?

Are you doing backup and restore on the same server, or backup on another and restore on a newer?
 
Apache 2.4.57
DirectAdmin 1.652
Exim 4.96-58-g4e9ed49f8
MySQL 5.7.43
Named 9.11.4
sshd
dovecot 2.3.20 (80a5ac675d)
pure-ftpd 1.0.51
Php 7.2.34 Installed
Php 5.6.40 Installed (php2)
Php 7.3.33 Installed (php3)
Php 8.1.22 Installed (php4)

Wordpress 6.3.1 install via installatron, I make admin backup user zzztest then deleted account and restore on the same server
there is a list of database but it doesn't exist. It's good that there aren't many users. But I've never encountered symptoms like this.
 
Hmmz... it might also be caused by installatron. I rather use manual installation just to be sure it's not a plugin causing the issue.

If you click on the database, does the user exists?

Does the same happen if you do a manual installation of Wordpress and then backup and restore? So we can exclude Installatron as cause?
 
I try to manual installation of Wordpress at user website and make admin backup then deleted account
and admin restore gave the same result with database connection

This problem seems to occur when restoring backups for a new user.

If I delete the account The database will also be deleted. when admin restoring the backup is done.
The website will not work. due to a problem connecting to the database

If WordPress website changes theme then make admin backup and restore. The website still works normally.
 
Hmmz... that seems odd. I suggest sending in a ticket since this only happens on new users as you say.
I didn't encounter an issue like this yet.
 
You must log in or register to reply here.
Back
Top