Create MySQL database with userAlexander Konyukov | System administrator / DevOps

Create MySQL database with user

I tired to googling this issues every time I need to create some test instance with MySQL (MariaDB) on Linux ))

CREATE DATABASE dbname;
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost' IDENTIFIED BY 'password';

1 2	CREATE DATABASE dbname; GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost' IDENTIFIED BY 'password';

That is all!