The mailing list for listmasters using Sympa

[Phil Stracchino <address@concealed>]

On 8/23/21 4:45 PM, Edd Ramer wrote:
> ########################################################################
> # Setup database
> # See
> https://sympa-community.github.io/manual/install/setup-database.html
> <https://sympa-community.github.io/manual/install/setup-database.html>
> ########################################################################
> 
> db_type             mysql
> db_name             sympa
> db_host             localhost
> #db_port
> db_user             sympa
> db_passwd         (hidden from you)
> #db_env
> 
> Mysql results for sympa user:
> mysql -u sympa -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 11
> Server version: 8.0.26 MySQL Community Server - GPL
> 
> Copyright (c) 2000, 2021, Oracle and/or its affiliates.
> 
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
> 
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | sympa              |
> +--------------------+
> 2 rows in set (0.01 sec)
> 
> 
> Thanks,
> Edd


Edd,
It appears you already created the 'sympa' database and user.  What
PERMISSIONS did you grant to the sympa user?  It should have full rights
(ALL PRIVILEGES ON sympa.*).  Don't forget to execute a FLUSH PRIVILEGES
after you grant the permissions.


-- 
  Phil Stracchino
  Babylon Communications
  address@concealed
  address@concealed
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958