HOWTO : Create a normal user on MySQL and MariaDB

Using a root account on the web applications as user is risky. It is more secure to create a normal user for the web applications.



Step 1 :



mysqladmin -u samiux -p create mydatabase



*where samiux is the normal username and mydatabase is the name of the database of the web applications



Step 2 :



mysql -u root -p



Step 3 :



GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON mydatabase.* TO 'samiux'@'localhost' IDENTIFIED BY 'mypassword';



*where mypassword is the password of the user samiux



That's all! See you.