How to make LC Work with mysql 8.0 with configs included

[Vogelj1988]

Hello this release is for people that dont know how to get LC working on mysql 8.0 .This will work with centos 9 stream have not tested it out on any other centos.

Step 1 :

dnf install mysql-server -y

Step 2 :

add this into your mysql-server.cnf under [mysqld]

default-authentication-plugin=mysql_native_password

# Set the SQL mode to strict

sql_mode=""

# The maximum size of one packet or any generated or intermediate string, or any parameter sent by the

# mysql_stmt_send_long_data() C API function.

max_allowed_packet=500M

Step 3 :

systemctl start mysqld.service

Step 4 :

systemctl enable mysqld

Step 5 :

mysql_secure_installation

2

2

[Sickness]

Nice work, just wanted to point out that LC wont benefit from mysql8.0 as the libs/includes are all mysql5, if this is just for compatibility, thats fine but I just wanted to point that out if people think this will improve their db speeds.

[Vogelj1988]

16 hours ago, Sickness said:




Nice work, just wanted to point out that LC wont benefit from mysql8.0 as the libs/includes are all mysql5, if this is just for compatibility, thats fine but I just wanted to point that out if people think this will improve their db speeds.




Thanks. I wanted to use the latest centos for the security and the fixes they have with 8.0

[Nikolee]

Im wondering if anyone has experienced the mysql server has gone away issue, which should be resolved by, setting the max_allowed_packet just higher?

[Reza]

sometimes updates are not just about performance. /index.php?/profile/394-sickness/&do=hovercard" data-mentionid="394" href="/index.php?/profile/394-sickness/" rel="">@Sickness