MySQL installation for use with Midgard should be as normal. Simply configure MySQL as you would normally and things ought to work out fine. Below are the installation steps we followed on our test set up.
We chose to specify a user and group for the MySQL server to run as, to avoid having the MySQL server run as the UNIX superuser.
# [groupadd <mysqlgroup>] # [useradd -g <mysqlgroup> <mysqluser>] $ cd mysql-3.23.28-gamma (directory containing MySQL source) $ ./configure [--prefix=/usr/local/mysql] [--with-mysqld-user=<mysqluser>] $ make # make install # ./scripts/mysql_install_db # [chown -R <mysqluser>.<mysqlgroup> /usr/local/mysql] # /usr/local/mysql/bin/safe_mysqld [--user=<mysqluser>] & |
At this point it will be a good idea to change the admin password for your MySQL server admin user (root). The MySQL server adminuser has no relationship with the UNIX superuser.
# /usr/local/mysql/bin/mysqladmin -u root password <adminpassword> # /usr/local/mysql/bin/mysqladmin -u root -h <hostname> password <adminpassword> |