Managing users in MySQL

users.sql

-- start mysql daemon
mysql.server start

-- connect as root
mysql -u root -p

-- create a new limited user
-- [field] = placeholder for your situation
CREATE USER '[username]'@'localhost' IDENTIFIED BY '[password]';
GRANT SELECT, INSERT, UPDATE, ALTER ON *.* TO '[username]'@'localhost';
FLUSH PRIVILEGES;
exit

-- connect using new account
mysql -u [username] -p

-- 3 ways to check current granted permissions
SHOW GRANTS;
SHOW GRANTS FOR CURRENT_USER();
SHOW GRANTS FOR '[username]'@'localhost';