Creating a Database and User

Step 1: Login to MySQL/Maria as a root user

user@server:~$ mysql -u root -p
Enter password:

Step 2: Create the Database

create database snipeit;

Step 3: Verify that it was created correctly

show databases;

Step 4: Create the Snipe-IT user

create user snipe_user;

Step 5: Grant privileges while assigning the password

grant all on snipeit.* to 'snipe_user'@'localhost' identified by 'YOUR_DB_PASSWORD_HERE';

*Note: The localhost field usually doesn’t have to be edited, but you can set it to the specific address.