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.
Updated over 5 years ago