List Server mysql Installation

Install¶

  $ apt-get install mysql-server
  $ chown -R mysql:mysql /usr/local/sympa/db
  $ mysqladmin -u root password 'new-password'

Create Sympa Tables¶

In the source distribution, there is a script folder which holds the mysql
statements which will create the database and tables.

  $ cd /home/sympa/src/sympa-$version/etc/script
  $ mysql --user root -p < create_db.mysql

To set up permissions:

$ mysql --user root -p 
mysql> use sympa;
mysql> grant all on sympa.* to sympa@localhost identified by 'your_password';
mysql> flush privileges;
mysql> quit

Make sure the user and password you set for the sympa database match those in
/etc/sympa.conf

to see if it worked, you can issue these sql commands from within mysql:

$ mysql -u sympa -p sympa
mysql> show tables;
mysql> show columns from user_table;