docs:mysql:install_and

MySQL Install and Setup

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
```
copy the default medium-scale parameter configuration file to the default location of /etc
```
sudo cp /sw/share/mysql/my-medium.cnf /etc/my.cnf
```
edit /etc/my.cnf, under the [mysqld] section, to match the default value for the maximum Apache web server connections.
```
set-variable = max_connections=150
```
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
```