MySQL Users and Privileges

# Create MySQL Password
# change 'newpassword' to your new password
sudo mysql -uroot
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword';
quit

mysql -uroot -p

# Create user with privileges
CREATE USER 'jon'@'localhost' IDENTIFIED BY 'jonspassword';
CREATE DATABASE IF NOT EXISTS jonsdb;
GRANT SELECT, UPDATE, DELETE, INSERT ON jonsdb.* TO 'jon'@'localhost';