linux mysql basics

linux: apt install mysql-server
starten wenn nicht gestartet: /etc/init.d/mysql start

mysql -u user

show databases;

SELECT User FROM mysql.user; 


CREATE USER 'da'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'da'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;