Or, if you prefer to set up and run your own mysql server, continue with the instructions below...
.my.cnffile in your home directory with information about where you'd like your configuration and data files stored:
[client] socket=/export/home/derek/.mysql.sock [mysqld] datadir=/export/home/derek/mysql socket=/export/home/derek/.mysql.sock
datadirdefined in your
.my.cnffile if it doesn't already exist:
$ cd $ mkdir mysql
$ mysqladmin -u root password 'NEWPASSWORD'
$ mysqld &
/usr/localfor the one you need and run it explicitly if the default isn't what you want:
$ ls -d /usr/local/mysql* /usr/local/mysql /usr/local/mysql-5.0.24a /usr/local/mysql-5.0.37 /usr/local/mysql-5.0.41 /usr/local/mysql-5.0.45 /usr/local/mysql-5.1.35 $ /usr/local/mysql-5.1.35/bin/mysqld &
If you get errors about port 3306 already being bound, someone else is running a MySQL server on that machine on the same port. You'll need to choose a different port. This can be done from the command line when running mysqld:
$ mysqld --port=3307or it can be done from the
[client] socket=/fs/junkfood/bplecs/.mysql.sock [mysqld] datadir=/fs/junkfood/bplecs/mysqld/data socket=/fs/junkfood/bplecs/.mysql.sock port=3307
See also the full MySQL documentation at http://dev.mysql.com/doc/.