SSL Integration - Printable Version

SSL Integration - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: SSL Integration (/thread-68750.html)

SSL Integration - k84u - 08-19-2017

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 ..

RE: SSL Integration - InsiteFX - 08-20-2017

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