[k84u]

Hello! can someone help me ? im having a issues after i integrated the SSL in our website

i got this error

Severity: Warning
Message: mysqli::real_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)
Filename: mysqli/mysqli_driver.php
Line Number: 161
below is line161 code

Code:

    if ($mysqli->real_connect($hostname, $this->username, $this->password, $this->database, $port, $socket, $client_flags))
        {
            // Prior to version 5.7.3, MySQL silently downgrades to an unencrypted connection if SSL setup fails
            if (
                ($client_flags & MYSQLI_CLIENT_SSL)
                && version_compare($mysqli->client_info, '5.7.3', '<=')
                && empty($mysqli->query("SHOW STATUS LIKE 'ssl_cipher'")->fetch_object()->Value)
            )
            {
                $mysqli->close();
                $message = 'MySQLi was configured for an SSL connection, but got an unencrypted connection instead!';
                log_message('error', $message);
                return ($this->db->db_debug) ? $this->db->display_error($message, '', TRUE) : FALSE;
            }

            return $mysqli;
        }

        return FALSE;
    }

 i dont know if its the ssl or what. please help me ..

[InsiteFX]

This is stating that your password is incorrect.

This could also be that you have not setup your MySQL Access Rights.

This is for a Windows 10 system, change the paths to match your MySQL install.
For other systems SEE: The MySQL Documentation.

To change your password on a Windows system for MySQL do the following:

1) Create a text file C:\xampp\mysql\bin\mysql-init.txt and add this to it.

Code:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('New_Password');

2) Create a new text file C:\xampp\mysql\bin\mtsql-start.txt

Code:

C:\xampp\mysql\bin\mysqld --init-file=C:\\xampp\mysql\mysql-init.txt

You need to run mysql-start.txt from a command line prompt.


Read: (HY000/1045): Access denied for user root