user@server:~$ mysql -u root -p Enter password:
create database snipeit;
create user snipe_user;
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 4 years ago