MariaDB [(none)]> CREATE USER my_user@localhost;

Query OK, 0 rows affected (0.005 sec)

MariaDB [(none)]> GRANT BINLOG REPLAY ON *.* TO my_user@localhost;

Query OK, 0 rows affected (0.004 sec)

MariaDB [(none)]> SHOW GRANTS FOR my_user@localhost;

+-----------------------------------------------------+

| Grants for my_user@localhost                        |

+-----------------------------------------------------+

| GRANT BINLOG REPLAY ON *.* TO `my_user`@`localhost` |

+-----------------------------------------------------+

1 row in set (0.000 sec)

MariaDB [(none)]> SHOW PRIVILEGES;

+--------------------------+---------------------------------------+--------------------------------------------------------------------+

| Privilege                | Context                               | Comment                                                            |

+--------------------------+---------------------------------------+--------------------------------------------------------------------+

| Alter                    | Tables                                | To alter the table                                                 |

| Alter routine            | Functions,Procedures                  | To alter or drop stored functions/procedures                       |

| Create                   | Databases,Tables,Indexes              | To create new databases and tables                                 |

| Create routine           | Databases                             | To use CREATE FUNCTION/PROCEDURE                                   |

| Create temporary tables  | Databases                             | To use CREATE TEMPORARY TABLE                                      |

| Create view              | Tables                                | To create new views                                                |

| Create user              | Server Admin                          | To create new users                                                |

| Delete                   | Tables                                | To delete existing rows                                            |

| Delete history           | Tables                                | To delete versioning table historical rows                         |

| Drop                     | Databases,Tables                      | To drop databases, tables, and views                               |

| Event                    | Server Admin                          | To create, alter, drop and execute events                          |

| Execute                  | Functions,Procedures                  | To execute stored routines                                         |

| File                     | File access on server                 | To read and write files on the server                              |

| Grant option             | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess                |

| Index                    | Tables                                | To create or drop indexes                                          |

| Insert                   | Tables                                | To insert data into tables                                         |

| Lock tables              | Databases                             | To use LOCK TABLES (together with SELECT privilege)                |

| Process                  | Server Admin                          | To view the plain text of currently executing queries              |

| Proxy                    | Server Admin                          | To make proxy user possible                                        |

| References               | Databases,Tables                      | To have references on tables                                       |

| Reload                   | Server Admin                          | To reload or refresh tables, logs and privileges                   |

| Binlog admin             | Server                                | To purge binary logs                                               |

| Binlog monitor           | Server                                | To use SHOW BINLOG STATUS and SHOW BINARY LOG                      |

| Replication master admin | Server                                | To monitor connected slaves                                        |

| Replication slave admin  | Server                                | To start/monitor/stop slave and apply binlog events                |

| Replication slave        | Server Admin                          | To read binary log events from the master                          |

| Select                   | Tables                                | To retrieve rows from table                                        |

| Show databases           | Server Admin                          | To see all databases with SHOW DATABASES                           |

| Show view                | Tables                                | To see views with SHOW CREATE VIEW                                 |

| Shutdown                 | Server Admin                          | To shut down the server                                            |

| Super                    | Server Admin                          | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.                |

| Trigger                  | Tables                                | To use triggers                                                    |

| Create tablespace        | Server Admin                          | To create/alter/drop tablespaces                                   |

| Update                   | Tables                                | To update existing rows                                            |

| Set user                 | Server                                | To create views and stored routines with a different definer       |

| Federated admin          | Server                                | To execute the CREATE SERVER, ALTER SERVER, DROP SERVER statements |

| Connection admin         | Server                                | To bypass connection limits and kill other users' connections      |

| Read_only admin          | Server                                | To perform write operations even if @@read_only=ON                 |

| Usage                    | Server Admin                          | No privileges - allow connect only                                 |

+--------------------------+---------------------------------------+--------------------------------------------------------------------+

39 rows in set (0.008 sec)