Misc
Source: https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
Open Command Prompt π
With password π
mysql -u root -p
Without password π
sudo mysql
Create Database π
CREATE DATABASE database_name;
Create user and grant all permissions on database π
GRANT ALL PRIVILEGES ON database_name.* TO 'USERNAME'@'HOSTNAME' IDENTIFIED BY "Str0ngDBP@ssw0rd";
Create New User π
CREATE USER 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'Str0ngDBP@ssw0rd';
Rename or change users host address π
RENAME USER 'USERNAME'@'localhost' TO 'USERNAME'@'HOSTNAME';
Flush (Frees memory and makes changes take immediate effect) π
FLUSH PRIVILEGES;
Close sql command prompt π
exit