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';
grant all privileges on wordpress.* to wpuser@localhost identified by 'your-password';
Flush the privileges table for the changes to take effect and then get out of MariaDB shell.
flush privileges;
exit;
https://www.linuxbabe.com/ubuntu/install-wordpress-ubuntu-20-04-nginx-mariadb-php7-4-lemp
sudo chown www-data:www-data /mnt/disks/thuy/wpapp/ -R
stat -c "%U %G" /path/to/file stat -c "%U %G" /mnt/disks/thuy/wpapp