A PHP Error was encountered Severity - A Database Error Occurred Unable to connect to your database server.

Message: mysqli::real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

A PHP Error was encountered

Severity: Warning

Message: mysqli::real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

Filename: mysqli/mysqli_driver.php

Line Number: 203

A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: C:/xampp/htdocs/himel-web/system/database/DB_driver.php

Line Number: 436


Welcome to phpMyAdmin

Error

MySQL said: Documentation

Cannot connect: invalid settings.

mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

The connection for the controller as defined in your configuration failed.

mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username, and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Solution:

It's a commonly experienced error. It's due to a crash of the User table in the MySQL database. The solution is simple. Just follow the below step.

1. Open the XAMPP control panel

2. Click MySQL > Config > my.ini

3. Add the below line under [mysqld] tag 

skip-grant-tables

4. Save my.ini 

5. Restart the MySQL server by pressing the STOP and START button 

6. Now visit http://localhost/phpmyadmin/ or http://127.0.0.1/phpmyadmin/

Sharecodepoint

Sharecodepoint is the junction where every essential thing is shared for college students in the well-defined packets of codes. We are focused on providing you the best material package like Question papers, MCQ'S, and one NIGHT STUDY MATERIAL. facebook twitter youtube instagram

Post a Comment

Previous Post Next Post

Contact Form