Using this to set up mysql, creating database + user, and later testing a connection -
sudo mysql -p worked for logging in as root user.
create database our_master_db;
CREATE USER 'our_db_admin'@'%' IDENTIFIED BY 'OurPassword';
GRANT ALL ON our_master_db.* TO 'our_db_admin'@'%';
to export and restore dbs.
date; mysql -h 127.0.0.1 -u our_db_admin -p our_master_db < our_master_db.OldServerdb-2024.15-04-2025.sql; date
No comments:
Post a Comment