mysqldump - Mysql max_allowed_packet -

i'm having troubles setting mysql (mariadb running on centos7) when issue

 show global variables variable_name = 'max_allowed_packet'; 

the response

 +--------------------+---------+  | variable_name      | value   |  +--------------------+---------+  | max_allowed_packet | 1048576 |  +--------------------+---------+  1 row in set (0.00 sec)      

witch means 1m. need leave permanently value @ 5m or bigger tried editing file /etc/my.cnf adding

[mysqldump] max_allowed_packet=16m 

so remained this.

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # disabling symbolic-links recommended prevent assorted security risks symbolic-links=0 # settings user , group ignored when systemd used. # if need run mysqld under different user or group, # customize systemd unit file mariadb according # instructions in http://fedoraproject.org/wiki/systemd [mysqldump] max_allowed_packet=16m  [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid # # include files config directory # !includedir /etc/my.cnf.d 

but after restarting server looks max_allowed_packet = 1048576 suggestion please?. in advance.

i solve particular problem.

we talking droplet in digitalocean. after doplet creation followed tutorial , issued "yum install mariadb" (or may mariadb-server, not sure). seemed ignoring configuration in /etc/my.cnf tried fedora droplet. able install mysql oracle yum repository. fine. talk problem on fedora in question (or may submit ticket).

what did visit mariadb official site , following instructions arrived page. https://downloads.mariadb.org/mariadb/repositories/#mirror=edatel&distro=centos&distro_release=centos7-amd64--centos7&version=10.0 setting official mariadb resppository , issuing "yum install mariadb" seemed fix problem.

thats now. thank reading.