docs:mysql:install_and_setup [hartungdesign.net wiki]

This is an old revision of the document!

copy/create/modify a my.cnf script to /etc/my.cnf, from the share/mysql directory
find and run the msyql_install_db script
change the owner of the MySQL databases and log files to be mysql
```
sudo chown -R mysql:admin /sw/var/mysql
```
start the MySQL daemon:
```
sudo /sw/bin/mysqld_safe --user=mysql &
```
to stop the MySQL daemon:
```
sudo /sw/share/mysql/mysql.server stop
```
notes ouput from running the mysql_install_db script
- To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
- PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands:
```
/sw/bin/mysqladmin -u root password 'new-password'
/sw/bin/mysqladmin -u root -h bill password 'new-password'
See the manual for more instructions.
```
- You can start the MySQL daemon with:
```
cd /sw ; /sw/bin/mysqld_safe &
```
- You can test the MySQL daemon with mysql-test-run.pl
```
cd mysql-test ; perl mysql-test-run.pl
```

MySQL Install and Setup