6 Installation

The  .*  in Databasename.* means that we have access to every table in that database.

The privileges we're allowing this user are to alter tables, create tables, delete records, drop

tables, index columns, insert records, and update records.

Finally, we need to set this user up with an old style password.

set password for U

SER

@localhost = old_password("P

ASSWORD

")

Now that you have a user created, go ahead and quit using root. In CocoaMySQL, close the

window. From the command line, type  quit  and press return.

Turn on  your firewall

Until you need some other computer to be able to access your MySQL database, you should

make sure that no one outside your computer can access it. Make sure that your firewall is

turned on, and make sure that it is not allowing entry by port 3306. On Mac OS X, this is

easy: go to your System Preferences, into the Sharing preference, start the firewall on the

firewall tab, and make sure that the Allow list does not contain 3306.