[prev in list] [next in list] [prev in thread] [next in thread] 

List:       serusers
Subject:    [SR-Users] mysql create user and grant privileges
From:       Daniel-Constantin Mierla <miconda () gmail ! com>
Date:       2019-10-22 9:00:49
Message-ID: 6c82faa1-3ab0-1edb-a1f7-bf1efdbe846b () gmail ! com
[Download RAW message or body]

Hello,

the mysql server version 8 is no longer supporting creating the user and
granting privileges in the same statement, they have to be separate. I
checked the mariadb specs and they seem to support also the separate
creation of user and granting privileges in two statements.

I pushed the changes in kamdbctl to master branch via commit:

   -
https://github.com/kamailio/kamailio/commit/c0879add55bef77703f2259f224b4a1f954cd8bf

The reason I am writing here is to see if anyone is aware of some (old)
versions of mariadb or mysql servers that do not support the creation
and grant in two steps. If yes, then we can add a config option in
kamctlrc to do one or the other variants. But for now I did it only with
the new style, as it seems to be supported everywhere by latest
versions, to avoid unnecessary option to keep also the old style.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat


_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic