sql restore

sirfpsycho

Hello, I want to restore sql database from cPanel server to aapanel without changing DB password. Because I don't know where is the database password is stored. So if I restore same database then there will not be any downtime or manual installation.

sirfpsycho

I have restored the sql manually but getting error. Can you please tell me how to fix it?

Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'realtalk_rts1'@'localhost' (using password: YES) in /www/wwwroot/example.com/config.php on line 6

Warning: mysqli::query(): Couldn't fetch mysqli in /www/wwwroot/example.com/config.php on line 15

Warning: mysqli::prepare(): Couldn't fetch mysqli in /www/wwwroot/example.com/mysql_dal.php on line 102

Warning: sqlDAL::readSql(): Couldn't fetch mysqli in /www/wwwroot/example.com/mysql_dal.php on line 103

Warning: mysqli::prepare(): Couldn't fetch mysqli in /www/wwwroot/example.com/mysql_dal.php on line 102

Warning: sqlDAL::readSql(): Couldn't fetch mysqli in /www/wwwroot/example.com/mysql_dal.php on line 103

Warning: mysqli::prepare(): Couldn't fetch mysqli in /www/wwwroot/example.com/mysql_dal.php on line 102

Warning: sqlDAL::readSql(): Couldn't fetch mysqli in /www/wwwroot/example.com/mysql_dal.php on line 103

Warning: mysqli::prepare(): Couldn't fetch mysqli in /www/wwwroot/example.com/mysql_dal.php on line 102

Warning: sqlDAL::readSql(): Couldn't fetch mysqli in /www/wwwroot/example.com/mysql_dal.php on line 103

Soufian

Your password is incorrect.

sirfpsycho

Soufian password is same. I have added same old password which I used on old cpanel server.

pavlus

sirfpsycho

either its really wrong password or your mysql user --> realtalk_rts1 is not set, or this user has no access granted for your database.

sirfpsycho

Help me please @aaPanel_Jose