Creating a Database and User

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

ssh

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

Step 2: Create the Database

mysql

create database snipeit;

Step 3: Verify that it was created correctly

MySQL

show databases;

Step 4: Create the Snipe-IT user

MySQL

create user snipe_user;

Step 5: Grant privileges while assigning the password

MySQL

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.