sha2_password

[serge_girard]

How to connect to mySQL- caching_sha2_password ?

Serge

[franco]

I am not sure what you are looking for.
I have found when using Microsoft Edge, after going in, in the top right corner is a red and green flag.
If you click it a copilot box will be a bottom of screen.
You can ask in that box any question about anything including programing questions.
Like
How to create a menu in c# language.
How to create a menu in hmg language.
How to connect to mySQL- caching_sha2_password ? in hmg language.
Most answers you get are quite accurate.

[serge_girard]

Thanks Franco,

I wil try with CHATgpt

Serge

[franco]

You can ask it in language you like.
It will create code for you in any language.
Ask it .... create menu in hmg language or ..... create menu in gui language.
It will create the code for you which you can compile with a build.bat

It will give you an explanation plus the code. You do not need CHATgpt I don`t think.

if you ask it
connect to mySQL- caching_sha2_password ? in hmg language.

CREATE USER 'yourusername'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpassword';
GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost';
FLUSH PRIVILEGES;

[serge_girard]

From chatgpt:

Code: Select all

#include "hmg.ch"
REQUEST HB_MYSQL

FUNCTION Main()
    LOCAL oMySql, cHost, cUser, cPassword, cDatabase, nPort

    cHost := "127.0.0.1"  // MySQL server host
    cUser := "your_username"  // MySQL username
    cPassword := "your_password"  // MySQL password
    cDatabase := "your_database"  // MySQL database name
    nPort := 3306  // MySQL server port

    oMySql := hb_MySQLInit()

    IF oMySql == NIL
        MsgInfo("Failed to initialize MySQL client")
        RETURN NIL
    ENDIF

    IF hb_MySQLConnect(oMySql, cHost, cUser, cPassword, cDatabase, nPort)
        MsgInfo("Connection successful!")
        // Perform database operations here
        hb_MySQLClose(oMySql)
    ELSE
        MsgInfo("Failed to connect: " + hb_MySQLError(oMySql))
    ENDIF

    RETURN NIL

Can't find hb_MySQL* function at the moment, tomorrow perhaps...

S