net_buffer_length can't set it
 

Hello,

I try to set net_buffer_length in my.cnf
but no meter what i put in it stays the same

+-------------------+---------+
| Variable_name | Value |
+-------------------+---------+
| net_buffer_length | 1048576 |
+-------------------+---------+


"set" also doesn't work...

mysql> set net_buffer_length=256000000;
ERROR 1621 (HY000): SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value

mysql> set global net_buffer_length=256000000;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show variables like 'net_buffer_length' ;
+-------------------+---------+
| Variable_name | Value |
+-------------------+---------+
| net_buffer_length | 1048576 |
+-------------------+---------+

what i'm doing wrong?

Setting global variable
 

You set a global variable, then you did NOT do:
mysql>show GOLBAL variables like '%net%';

You just did a
mysql>show variables....