SQL: Import dump to mysql with pv

-- By default, mysql-server initially provides a 'root'@'localhost' user for managing the server locally:
sudo mysql -u root

-- Create additional MySQL user:
CREATE USER 'username'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';

-- Socket-based authentication (empty pw - CARE!):
CREATE USER 'username'@'localhost' IDENTIFIED WITH auth_socket;

-- Create the database (necessary for some dumps):
CREATE DATABASE invitrodb_v4_3;

-- Allow the new user to manage it:
GRANT ALL PRIVILEGES ON invitrodb_v4_3.* TO 'username'@'localhost';

-- Import is perfomred by a shell command, so:
exit;

-- Import database from bash:
mysql -u username -p invitrodb_v4_3 < invitrodb_v4_3.sql

-- Better still, use pipe viewer to monitor progress (apt insta;ll pv):
pv invitrodb_v4_3.sql | mysql -u username -p invitrodb_v4_3