Пользователи

  <users>
       <!-- If user name was not specified, 'default' user is used. -->
       <default>
           <password></password>
           <networks>
               <ip>::/0</ip>
           </networks>

           <!-- Settings profile for user. -->
           <profile>default</profile>

           <!-- Quota for user. -->
           <quota>default</quota>
           <grants>
               <query>GRANT SHOW ON *.*</query>
               <query>GRANT CREATE ON *.* WITH GRANT OPTION</query>
               <query>GRANT CREATE USER ON *.*</query>
               <query>GRANT ALTER USER ON *.*</query>
               <query>GRANT SELECT ON system.*</query>
               <query>GRANT ALL ON *.* WITH GRANT OPTION</query>
           </grants>
           <!-- User can create other users and grant rights to them. -->
           <!-- <access_management>1</access_management> -->
       </default>
   <!-- Quotas. -->
   </users>

CREATE USER user1 HOST IP  '0.0.0.0/24' IDENTIFIED WITH sha256_password BY 'Yd64';
alter USER user1 HOST IP  '0.0.0.0/0' IDENTIFIED WITH sha256_password BY 'fgYd64';

GRANT ALL ON *.* TO user1 WITH GRANT OPTION;
GRANT ALL ON pushme_analytics.* TO user1 WITH GRANT OPTION;