aeric Expert Licensed User Longtime User Sep 20, 2022 #1 Anyone has issue with MySQL 8.0? It seems there is a jump from version 5.x to version 8.x My fingers were itchy. I tried to change the OS in my VPS to other images (Debian 11 and Ubuntu 20.04) and tried to rebuild the server. Apache2 and PHP are fine but MySQL 8 setup seems to change. I can't login with adminer. After hours of troubleshooting, I tried to restore the image and then my VPS is down. After waiting the hosting support to check on it for 16 hours, now they restored my image which is Ubuntu 18.04.
Anyone has issue with MySQL 8.0? It seems there is a jump from version 5.x to version 8.x My fingers were itchy. I tried to change the OS in my VPS to other images (Debian 11 and Ubuntu 20.04) and tried to rebuild the server. Apache2 and PHP are fine but MySQL 8 setup seems to change. I can't login with adminer. After hours of troubleshooting, I tried to restore the image and then my VPS is down. After waiting the hosting support to check on it for 16 hours, now they restored my image which is Ubuntu 18.04.
jahswant Well-Known Member Licensed User Longtime User Sep 20, 2022 #2 There’s a more secure password authentication in 8.0+. Also make sure to compile your applications with latest jdbc.
There’s a more secure password authentication in 8.0+. Also make sure to compile your applications with latest jdbc.
aeric Expert Licensed User Longtime User Sep 20, 2022 #3 jahswant said: There’s a more secure password authentication in 8.0+. Also make sure to compile your applications with latest jdbc. Click to expand... I upgraded the old Ubuntu 18.04 to 20.04 and everything is working without any modification. The only thing is adminer cannot find php-mysql and I just fixed it with a single command. Bash: sudo apt-get install php-mysql p/s: all the while I am using mysql-connector-java-8.0.29
jahswant said: There’s a more secure password authentication in 8.0+. Also make sure to compile your applications with latest jdbc. Click to expand... I upgraded the old Ubuntu 18.04 to 20.04 and everything is working without any modification. The only thing is adminer cannot find php-mysql and I just fixed it with a single command. Bash: sudo apt-get install php-mysql p/s: all the while I am using mysql-connector-java-8.0.29
peacemaker Expert Licensed User Longtime User Sep 20, 2022 #4 I remember otherwise that only MySQL 8 was OK comparing to latest MariaDB - some PHP-datagrid engine has trouble with a table update in Maria.
I remember otherwise that only MySQL 8 was OK comparing to latest MariaDB - some PHP-datagrid engine has trouble with a table update in Maria.
rabbitBUSH Well-Known Member Licensed User Longtime User Sep 20, 2022 #5 aeric said: It seems there is a jump from version 5.x to version 8.x Click to expand... nope my host provider was using version 7.4 until recently . . .
aeric said: It seems there is a jump from version 5.x to version 8.x Click to expand... nope my host provider was using version 7.4 until recently . . .
aeric Expert Licensed User Longtime User Sep 21, 2022 #6 rabbitBUSH said: nope my host provider was using version 7.4 until recently . . . Click to expand... No issue with shared hosting but with VPS we are installing the softwares and configure them on our own. Last edited: Sep 21, 2022
rabbitBUSH said: nope my host provider was using version 7.4 until recently . . . Click to expand... No issue with shared hosting but with VPS we are installing the softwares and configure them on our own.
rabbitBUSH Well-Known Member Licensed User Longtime User Sep 21, 2022 #7 Ah - wait - you're correct - PHP - mixed up the twins.
