SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = toplayerwins and table_name = permissions and table_type = 'BASE TABLE') code example

Example 1: SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')

ALTER USER 'user'@"localhost" IDENTIFIED WITH mysql_native_password BY 'password'

Example 2: SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')

mysql> FLUSH PRIVILEGES;

Tags:

Sql Example