-- CREATE
CREATE USER 'tgnrestoreuser'@'localhost' IDENTIFIED BY 'AppleSauceLoveBird2024';
GRANT ALL PRIVILEGES ON tgndbrestored.* TO 'tgnrestoreuser'@'localhost';

-- RESTORE as below

-- DELETE user and database
DROP USER tgnrestoreuser@localhost;
DROP DATABASE tgndbrestored;

zcat 7-tgndb-Sun-db.sql.gz | mysql -uroot -p tgndbrestored