lddatabase.connectmysql show error message

Martmen 46 Reputation points
2023-01-02T05:00:35.213+00:00

Hello
this is the error message:
LDDataBase.ConnectMySQL : Client does not support authentication protocol requested by server; consider upgrading MySQL client

this is the program:
server = "localhost"
user = "root"
password = "xxxxxx"
database = "mydb"

MyDB = LDDataBase.ConnectMySQL(server, user, password, database)

Please help me.

happy new year
Martmen

Small BASIC
Small BASIC
A programming language created by Microsoft that serves a stepping stone for beginners from block-based coding languages to more complex text-based languages.
277 questions
0 comments No comments
{count} votes

Accepted answer
  1. JimmySalian-2011 41,926 Reputation points
    2023-01-02T06:02:25.55+00:00

    Hi,

    I have removed the password, do not share the credentials out on the forum.

    Btw can you check this page and follow the recommended steps for this issue?

    Hope this helps.
    JS

    ==
    Please Accept the answer if the information helped you. This will help us and others in the community as well.


1 additional answer

Sort by: Most helpful
  1. Scout 136 Reputation points
    2023-01-02T16:20:19.567+00:00

    So far no problems with MySQL

    275485-demo-8-0-16.jpg

    I am using version 8.0.16:

    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 15
    Server version: 8.0.16 MySQL Community Server - GPL

    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql>

    The latest version is 8.0.31

    0 comments No comments