Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 Today 15:07:01

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,856
GitHub

MySQL 9.7 LTS is GA; MySQL 8.0 LTS is EOL soon

blogs.oracle.com/mysql/mysql-9-7-0-lts-is-now-available-expanded-community-capabilities-and-dynamic-data-masking-for-enterprise
dev.mysql.com/doc/relnotes/mysql/9.7/en/

I’ll get it moved up the priority list on the next demo server build, suffice to say it’s ready for public consumption.

MySQL 8.0 LTS goes EOL at the end of April 2026.

Offline

#2 Today 18:10:09

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,856
GitHub

Re: MySQL 9.7 LTS is GA; MySQL 8.0 LTS is EOL soon

I’ll update this thread as my first-pass testing is underway.

Sequel Ace connects as expected

I’m using Sequel Ace 5.1.0, it connected to my Debian 13 server with MySQL 9.7 just fine.

Removed: mysql_native_password

mysql_native_password plugin was deprecated in MySQL 8.0, removed in MySQL 9.7. A successor appears to be caching_sha2_password. The following syntax works for creating a user:

CREATE USER IF NOT EXISTS 'beta_demo'@'127.0.0.1' IDENTIFIED WITH caching_sha2_password BY 'abc123xyz987';

Offline

Board footer

Powered by FluxBB