GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   dont upgrade your mysql server to version 8 yet (https://gfy.com/showthread.php?t=1299481)

freecartoonporn 05-29-2018 11:45 PM

dont upgrade your mysql server to version 8 yet
 
Thank me later.

if you are using it with php

CaptainHowdy 05-30-2018 02:38 PM

Bumpin' the warning . . .

Zeiss 05-30-2018 03:17 PM

What do you mean? What got screwed?

freecartoonporn 05-30-2018 07:24 PM

Quote:

Originally Posted by Zeiss (Post 22278856)
What do you mean? What got screwed?

authentication method.

my knowledge is limited , and maybe upgrade will work with old user accounts.

but i did new install as usual and got 2 issues , which took me a lot of time and trials to make it work.

ref: https://mysqlserverteam.com/mysql-8-...sha2_password/

https://mysqlserverteam.com/upgradin...onsiderations/

https://dev.mysql.com/doc/refman/8.0...d-root-account

Bladewire 05-30-2018 08:47 PM

Jesus fucking Christ!

That means there's holes in it not good

freecartoonporn 05-30-2018 10:43 PM

Quote:

Originally Posted by Bladewire (Post 22278978)
Jesus fucking Christ!

That means there's holes in it not good

they changed default authentication method. and default charset

i can log in to mysql using terminal but cant connect using php .

so either downgrade mysql or change default authentication method e.g.

Code:

default-authentication-plugin=mysql_native_password
character-set-server=utf8

and alter root user using
Code:

ALTER USER 'root'@'localhost'
  IDENTIFIED WITH mysql_native_password
  BY 'password';

ref: https://dev.mysql.com/doc/refman/8.0...d-root-account

until php updates their connector mysql api to use newer authentication method

PornDiscounts-V 05-31-2018 12:34 AM

This is why you don't use the cutting edge.

MFCT 05-31-2018 01:07 AM

It probably means that haxxurz don't know how to hack version 8 yet. So hold off upgrading until they can figure something out. :2 cents: :winkwink:

ghjghj 05-31-2018 02:48 AM

Quote:

Originally Posted by freecartoonporn (Post 22278434)
if you are using it with php

Even workbench isn't working with it.

Klen 05-31-2018 02:54 AM

How do you usually update mysql , over source or over packaging system ?

CurrentlySober 05-31-2018 03:45 AM

i cunt a4d2 upgrade my mysql server to version 8 yet... :(

freecartoonporn 05-31-2018 04:41 AM

Quote:

Originally Posted by KlenTelaris (Post 22279075)
How do you usually update mysql , over source or over packaging system ?

yum update

Bladewire 05-31-2018 04:42 PM

Bump for business :thumbsup

Bladewire 05-31-2018 10:08 PM

Quote:

Originally Posted by PornDiscounts-V (Post 22279042)
This is why you don't use the cutting edge.

:thumbsup

RyuLion 06-01-2018 03:33 PM

Thanks for this warning!!!

Bladewire 06-02-2018 11:36 AM

Quote:

Originally Posted by RyuLion (Post 22280168)
Thanks for this warning!!!

:thumbsup


All times are GMT -7. The time now is 06:41 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc