2021-01-28

Setting up MySQL on Ubuntu for development

https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

sudo apt install mysql-server
sudo mysql
CREATE USER 'rootwo'@'localhost' IDENTIFIED BY 'rootwo';
GRANT ALL PRIVILEGES ON * . * TO 'rootwo'@'localhost';
FLUSH PRIVILEGES;

I would also recommend installing Apache and setting up (Adminer)[https://www.adminer.org/] or using something like DataGrip from Jetbrains.