https://linuxize.com/post/how-to-create-mysql-user-accounts-and-grant-privileges/ Before you Begin We are assuming that you already have MySQL or MariaDB server installed on your system. All commands are executed inside the MySQL shell as root or administrative user. The minimum privileges required to create user accounts and define their privileges is CREATE USER and GRANT . To access the MySQL shell type the following command and enter your MySQL root user password when prompted: mysql -u root -p If you have MySQL version 5.7 or later that uses the auth_socket plugin login as root by typing: sudo mysql Create a new MySQL User Account A user account in MySQL consists of two parts: user name and host name. To create a new MySQL user account, run the following command: CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'user_password'; Replace newuser with the new user name, and user_password with the user password. In...