phpMyAdmin - " mysqli::real_connet():The server requested authentication method unknown to the client [caching_sha2_password]"

-

mysqli::real_connet():The server requested authentication method unknown to the client [caching_sha2_password]
mysqli::real_connet():The server requested authentication method unknown to the client.


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


可參考：

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html?fbclid=IwAR1AyO27q5slXGPyrLilZBL9TZpgkf_VxLdcFWo4EYx4q-E5vfiTRIj9pS0#upgrade-caching-sha2-password


Comments

Post a Comment

Popular posts from this blog

Flutter - "PlatformException(no_fragment_activity, local_auth plugin requires activity to be a FragmentActivity., null)"

-
Image
package co.et.keys import androidx.annotation.NonNull ; import io.flutter.embedding.android.FlutterFragmentActivity import io.flutter.embedding.engine.FlutterEngine import io.flutter.plugins.GeneratedPluginRegistrant class MainActivity: FlutterFragmentActivity() { override fun configureFlutterEngine(@NonNull flutterEngine: FlutterEngine) { GeneratedPluginRegistrant.registerWith(flutterEngine) ; } } <uses-permission android :name ="android.permission.USE_BIOMETRIC" /> refer 1 refer2  
Read more

Dart syntax - initSate,Build,deactive, Dispose

-
 ☝ initSate(){ super.initSate   //放置一旦載入statefulwidget後就不需一直更新的物件。 } 如字面的意思in it sate. 此功能好比statefulwidget 裡面的statelesswidget。   Called only once when the widget is created，只會執行一次，不像build() 一變動就自毀後重建。 ☝Build(BuildContext context) { //放置載入後每次有任何變動就需更新的物件。 }          - Build the widget tree         -A build is triggred every time we use setState() that re-triggre build(). ☝ deactive() {super.deactive // 放置當statefulwight自毀換頁前跟著毀的物件。例如:釋放記憶空間。 } ☝Dispose()          - When the widget/state object is removed.
Read more