Home

Welcome to the magento-configurable-simple wiki! https://linuxize.com/post/how-to-manage-mysql-databases-and-users-from-the-command-line/

CREATE USER 'database_user'@'localhost' IDENTIFIED BY 'user_password'; CREATE USER IF NOT EXISTS 'database_user'@'localhost' IDENTIFIED BY 'user_password';

mysql --version ALTER USER 'database_user'@'localhost' IDENTIFIED BY 'new_password';

SELECT user, host FROM mysql.user;

GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost';