Installing the MySQL database on Mac OS X

At first we need to download the MySQL Server with the official site. Note that the download version is needed for your hardware platform, for us it's Mac OS X.

After downloading in the Downloads folder will appear file mysql-5.1.37-osx10.5-x86.dmg, which must be assembled by double-clicking. In the window that in turn run the two packages:

1. mysql-5.1.37-osx10-x86.pkg - in fact the server itself;
2. MySQLStartupltem.pkg - set to automatically run the server.

After installation, go to the most important step, to create the database and set up an account administrator.

The first step is run in a terminal server installed:

sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

If the error message does not appear, and the output of sudo ps ax | grep mysql shows the existence of a process that's all right, go next.

Next you need to create aliases for the management console mysql server and administration tools for server mysqladmin, all this in order to enter at startup not the full path to the files:

alias mysql=/usr/local/mysql/bin/mysql

alias mysqladmin=/usr/local/mysql/bin/mysqladmin

Now, most importantly, set an administrator password MySQL-server:

mysqladmin -u root password 'new admin password'

By default the administrator password blank, which is not good, therefore it is better to change, or rather to ask. That's all, the server is up and ready to go.Let us verify this by typing in a terminal mysql-u root-p, then the password prompt to enter an administrator password specified earlier.

On the screen we see the following:

Own MySQL-server on OS X is installed and ready to go.