I’m new with DO and I got a LAMP 16.04 setup.
I’m creating a JavaFX desktop and trying to connect it to the MySQL server.
my.cnf has been edited - added
max_allowed_packet = 1048576.
I also tested it by
show variables like 'max_allowed_packet' in MySQL.
BUT, an error is still showing when I build the app.
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4739923 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.