mysql installation

digital ocean is the best : https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04

sudo apt update

sudo apt install mysql-server

sudo systemctl start mysql.service

sudo mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

exit mysql :

exit

mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;

sudo mysql_secure_installation

CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

to grant a single privilege to a user for a database's table :

GRANT PRIVILEGE ON database.table TO 'username'@'localhost';

to grant all privileges for all databases to a user :

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;