docs:mysql:install_and_setup [hartungdesign.net wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

===== MySQL Install and Setup =====

===== Installation =====
FIXME

===== Initial Setup =====
  * find and run the msyql_install_db script
  * change the owner of the MySQL databases and log files to be mysql<code>
sudo chown -R mysql:admin /sw/var/mysql
</code>
  * copy the default medium-scale parameter configuration file to the default location of /etc<code>
sudo cp /sw/share/mysql/my-medium.cnf /etc/my.cnf
</code>
  * edit /etc/my.cnf, under the [mysqld] section, to match the default value for the maximum Apache web server connections.<code>
set-variable = max_connections=150
</code>
  * start the MySQL daemon:<code>
sudo /sw/bin/mysqld_safe --user=mysql &
</code>
  * to stop the MySQL daemon:<code>
sudo /sw/share/mysql/mysql.server stop
</code>
  * 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:<code>
/sw/bin/mysqladmin -u root password 'new-password'
/sw/bin/mysqladmin -u root -h bill password 'new-password'
See the manual for more instructions.
</code>
    * You can start the MySQL daemon with:<code>
cd /sw ; /sw/bin/mysqld_safe &
</code>
    * You can test the MySQL daemon with mysql-test-run.pl<code>
cd mysql-test ; perl mysql-test-run.pl
</code>