Step 3 — Creating a Dedicated MySQL User and Granting Privileges

mysql -u root -p
CREATE USER 'username'@'host' IDENTIFIED WITH authentication_plugin BY 'password';

or

CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT PRIVILEGE ON database.table TO 'username'@'host';


Revision #2
Created 17 September 2024 10:51:27
Updated 17 September 2024 11:40:59