Task List

• create user
• create database
• grant access to database
• reload

Create User

# mysql mysql

> insert into user values ('localhost', 'dbusername', password('dbpasswd'), 
'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');

> insert into user values ('hostname', 'dbusername', password('dbpasswd'), 
'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');

Create Database

# mysqladmin create dbname

Grant Access

# mysql mysql

> insert into db values ('localhost', 'dbname', 'dbusername', 
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

> insert into db values ('hostname', 'dbname', 'dbusername', 
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

Reload

# mysqladmin reload