Creating a Database and User

# Step 1: Login to MySQL/MariaDB as root

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

# It will prompt you for your database root password

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';

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

In the example above, your database settings in your .env would look like this:

DB_DATABASE=snipeit
DB_USERNAME=snipe_user
DB_PASSWORD=YOUR_DB_PASSWORD_HERE