MySQL main administration commands

gistfile1.sql

-- Change password for user to specific database

-- Create database
create database mydb;

-- Select database
use mydb;

-- Create user
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

-- Grant privileges to database
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost';

-- Change password
SET PASSWORD FOR 'tom'@'localhost' = PASSWORD('foobar');

-- Update privileges
FLUSH PRIVILEGES;