View Single Post
Old 05-30-2018, 10:43 PM  
freecartoonporn
Confirmed User
 
freecartoonporn's Avatar
 
Industry Role:
Join Date: Jan 2012
Location: NC
Posts: 7,683
Quote:
Originally Posted by Bladewire View Post
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
freecartoonporn is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote