"Rosario": Restore a MySQL database

[KarthikKota2003]

Why does this scenario - "Rosario": Restore a MySQL database not accept a different solution ?

Here is my approach :

I have killed and started the mysql server with a new sql file that changes the root users password through ALTER query

ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('new_password');

I have restarted the mysql service and started mariadb as well. I can connect to mariadb console safely and see the main database. Initially like any real-world scenario i have thought that the database might itself be corrupted so i dropped it and created a new database and restored it.

And yes, i have ofcourse corrected the backup.sql file.

After restoring it using the sql script i could see the solution table. But this is showing as incorrect in the solution part.

Help me understand if I am doing it in the wrong way or is it the issue on the solution side ?

[fduran]

hello @KarthikKota2003 , the check.sh script (that "Check my solution" button calls) tries to connect to the db and verify that the table exists. So if you properly restored the table then perhaps the connection string or query are not working (eg: table with a different name, table not in the same db name).

[KarthikKota2003]

Hi @fduran , Where is this connection string that you are talking about ? I dont think the table or table name is the issue here.

Now, i dont know if solution table should have any data, i dont see any rows in the table.

[fduran]

@KarthikKota2003 sorry had the wrong link, see the db credentials in the check.sh script

[KarthikKota2003]

@fduran I just checked the check.sh script, it does not have any mention of password, all it checks for is if the table exists under root user which should ideally return OK.

[fduran]

@KarthikKota2003 sorry not credentials but username and database name. Test checks for this returning 0 sudo mysql -u"$MYSQL_USER" -e "USE $DATABASE; DESCRIBE $TABLE;" ; both statements must be true, so if it's not true for you then one of the two statements (connect to the db or table "solution" exists) must be failing.