Solved database connection issue

[Steven92]

Using UniServer Zero XV, ZNote ACC, and TFS 1.2, trying to run a private server but at "establishing database connection", the window just closes.

I did a command prompt and found out that it was:

>> Establishing database connection...
MySQL Error Message: Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.


> ERROR: Failed to connect to database.
>> No services running. The server is NOT online.

some of my config.php from www folder:

// Path to server folder without "\" (or "/") at the end, ex: C:\Users\Username\Documents\GitHub\forgottenserver
    $config['server_path'] = 'C:\StevarooServer3';


    // ------------------------ \\
    // MYSQL CONNECTION DETAILS \\
    // ------------------------ \\


    // phpmyadmin username for OT server: (DONT USE "root" if you are hosting to public).
    $config['sqlUser'] = 'root';


    // phpmyadmin password for OT server:
    $config['sqlPassword'] = 'root';


    // The database name to connect to. (This is usually same as username).
    $config['sqlDatabase'] = 'tfsog';


    // Hostname is usually localhost or 127.0.0.1.
    $config['sqlHost'] = 'localhost';

some of my config.lua from TFS:

-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "root"
mysqlDatabase = "tfsog"
mysqlPort = 3306
mysqlSock = ""
--passwordType = "sha1"

Any help is greatly appreciated!

EDIT -- Started looking around more and found this fix to the issue, although it is not tibia related. Running in windows, I just did the fix in the PHPmyadmin SQL prompt and it worked!