Installation 5

set your password. The command line client can connect whichever password method you

use.

If you accidentally set a password using  password()  instead of  old_password() , you will

need to use the command line instructions to reset the password for that CocoaMySQL user.

Create a database

In the Custom Query tab, type  create database D

ATABASE

N

AME

 . This will create a new,

empty database. If you refresh the Databases menu or type  show databases  you will see

your new database in the list of databases.

Create a database called  music .

Create a working user

You do not want to work as root for normal usage. If you make a mistake as root, you can

destroy not only your entire database but every database on the system. You want to limit the

damage a typo can do.

grant alter, create, delete, drop, index, insert, select, update on

D

ATABASE

N

AME

.* to U

SER

@localhost identified by "P

ASSWORD

"

For  DatabaseName, specify the same database that you just created. For User, specify the

username  you  wish  to  use  to  connect  normally.  Your  username  should  not  contain  any

spaces  or  other  non alphanumeric  characters.  Your  password  can  (and  probably  should)

contain special characters.

grant alter, create, delete, drop, index, insert, select, update on 

MUSIC

.* to

U

SER

@localhost identified by "P

ASSWORD

"

This will allow you to connect but only from  localhost , which is the same computer the

server is on. Since we are installing this test server on our workstations, this will allow us to

connect only from our workstation.