Quickly create a ROOT privileged user in MySQL 8

MySQL 8 no longer creates users on grants. So you must first create the user then grant them access to individual databases. It’s now a 3 step process! Note the grants below are WAY too much for a production server.

The first line creates the user in the MySQL users table, the second line grants this user privileges on ALL databases on this server, and the 3rd line allows the user to login remotely using a normal password.

TLDR (just do this);

CREATE USER 'jschmoe'@'%' IDENTIFIED BY 'Password1'; 
GRANT ALL PRIVILEGES ON *.* TO 'jschmoe'@'%'; 
ALTER USER 'jschmoe'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Password1';