0

When i connect to my databse via phpmyadmin everything works fine and it shows me the data. When i am on my server i can see all data and work with it.

But when i try to connect to my server i'm getting this error:

com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (4.739.923 > 65.535). You can change this value on the server by setting the 'max_allowed_packet' variable.

im getting the max allowed packet size here:


Database changed
MariaDB [selforder]> SELECT @@max_allowed_packet;
+----------------------+
| @@max_allowed_packet |
+----------------------+
|            536870912 |
+----------------------+
1 row in set (0.00 sec)

and i changed my file nano /root/.my.cnf to this:

[mysqld]
max_allowed_packet=536870912

but i still get this error;

Bill Karwin
  • 538,548
  • 86
  • 673
  • 828
kaeptenlook
  • 27
  • 7
  • Given you're using MariaDB and not MySQL, have you tried using the MariaDB Connector/J instead of MySQL Connector/J? I'm not sure if it will make a difference, but as both database systems are diverging, it might be better to use the driver specifically built for you database system. – Mark Rotteveel Apr 05 '20 at 07:14

1 Answers1

0

not really an answer but my problem was, that i installed multiple versions of mysql, i completly reinstalled my system

kaeptenlook
  • 27
  • 7