MySQL 8.0

aeric

aeric

Expert
Licensed User
Longtime User
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

jahswant

Well-Known Member
Licensed User
Longtime User
There’s a more secure password authentication in 8.0+. Also make sure to compile your applications with latest jdbc.
 
aeric

aeric

Expert
Licensed User
Longtime User
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

peacemaker

Expert
Licensed User
Longtime User
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.
 
You must log in or register to reply here.
Top