command line mysql database import from file (like phpmyadmin export)

mysql_cmd_import_from_sql.txt

mysql -u username -p  -h localhost
# > in sql command line
# Attention!! this will ERASE database from server
# Be sure that you know what are you doing
DROP DATABASE database_name;
CREATE DATABASE database_name;
ALTER DATABASE database_name charset=utf8mb4;

#create user if needed
CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'pwd';
GRANT ALL PRIVILEGES ON database_name.* TO user_name@localhost;

# executes sql command from file (import from phpmyadmin defualt export)
mysql -u username -p database_name < file.sql