+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: General Releases (https://lckb.dev/forum/forumdisplay.php?fid=127)
+----- Forum: General Server Releases (https://lckb.dev/forum/forumdisplay.php?fid=212)
+----- Thread: How to make LC Work with mysql 8.0 with configs included (/showthread.php?tid=4932)
- Vogelj1988 - 06-11-2022
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 - 06-11-2022
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 - 06-12-2022
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 - 06-14-2022
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 - 03-03-2023
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