[Solved]Error:Host ‘localhost’ is not allowed to connect to this MariaDB server Error on XAMPP MySQL

In this tutorial I will show you how to solve "Host ‘localhost’ is not allowed to connect to this MariaDB server" Database error
Solution: You have to change the my.ini MySQL database config file to solve the problem.
Step1: Click on Config Button beside the MySQL database from XAMPP control panel.
Step2: Open my.ini file to change the MySQL configuration file.
Step3: Under [mysqld] add the following command and save the my.ini file.
Step4: Restart MySQL database.
Step5: Click to Admin button beside MySQL database to open phpMyAdmin
Step6: Now you will see the problem is solved.

[@AlanJaen-ej7qg]

Tutorial is still helps in 2024. Thk!

[@ivanviktorov]

This tutorial is still helps in 2024

[@lizm3276]

Oh my gosh thanks a lot! I can finally sleep lol this whole "not allowed to connect to the MySQL" did not let me sleep for days now haha

[@cseschools]

Thank you

[@fabianrossini4315]

thank you, after four years it helped me a lot!

[@carlosjavierr10]

Thankyou!!! you are the best my friend :D

[@mike4two983]

thank you so much 2024 and still works u are the best

[@dbc7914]

I was very sad but you really saved my life, love u so much!

[@cseschools]

Thank you

[@balendra4792]

my server also started working brother thank you from the 💖💖💖 bottom of my heart ❤️❤️❤️

[@cseschools]

Welcome

[@ARMJX]

TYSM

[@chrasc]

Excelente aportación, muchas gracias

[@Blackheart_Nation]

Thank you so much this helped me out more then you can possible imagine.

[@cseschools]

I'm so glad!

[@haroldrengifo6012]

That not helped me out to solve my problem, still showing the error: null, message from server: "Host '181.42.17.155' is not allowed to connect to this MySQL server" Any advice?

[@omar-234-f]

tutorial still helps in 2025

[@chinmayeemajhi1068]

My server is also working, thank you sir

[@osamamohamed5793]

really thank you for your hard work for us ^_^ ❤❤

[@faizalleviansyah4897]

THANK YOU SOO MUCH MAN REALLY HELPFULL, it works btw in 2024

[@jamshaidkhanniazi8281]

Worked ❤

[@divept]

Thank you for everything, you are the greatest
❤❤❤❤

[@cseschools]

You are welcome

[@shaund0]

Fixed my issue, thank you!

[@cseschools]

Glad it helped!

thank youuuuuuuuuuuuuuuu!!❤❤❤❤❤❤❤❤

[@cseschools]

You are welcome

[@zubeyir2911]

thx its still working

[@DouglasFernandoNabingerdaCunha]

Great advice, thank you

[@tamersd2006]

thank you man it was make me crazy

[@cseschools]

Always welcome

[@Anillata25thanniversary2k23]

Thanksss alottt it really helped us in project

[@cseschools]

Glad it helped

[@legendkillerlk8136]

Thanks for the help dude

[@haikalsyhri5327]

thank ❤❤

[@charlesmbuvip]

This is not solving the issues but rather disables mysql security without addressing the underlying issue.

[@sastyinkaroly]

THANX A LOT OF LOT! :)

[@OJOKSTEVEN-c3q]

Thanks alot it helped me

[@cseschools]

Glad it helped

[@cseschools]

Glad it helped

[@shamilqaragozov3412]

thank you

[@cseschools]

You're welcome

[@andresfire3777]

Mano eres un crack me ayudaste gracias

[@a.ihsanyksl7716]

Thanks bro!

[@beignet6944]

good man.

[@arindiazsuarez9361]

if it worked, thank you very much friends greetings

[@cseschools]

I solved my problem this way. Hope it will aslo work for you.

[@sebastianparias1962]

thanks very much

[@HindiKahaniya24-e4p]

Thank you ☺️

[@cseschools]

You’re welcome 😊

[@maurya.5193]

Muchas Gracias..............;)

[@cseschools]

You are welcome

[@bhaktibhosale3427]

Thank you sir

[@cseschools]

Welcome

[@h_32_sakshimishra5]

thanks, dude:)

[@cseschools]

Happy to help

[@sebastiangrandes]

Muchas gracias!

[@cseschools]

:)

[@exsitewebsolution6803]

love you

[@renato64811]

👏👏👏👏

[@generalgamer8273]

tankeo brow

[@cseschools]

You are most welcome

[@BISWAJYOTIROUT]

Thanks

[@mrunknown2887]

thanks a lot bro

[@cseschools]

Always welcome

[@Josue-m9x]

gracias

[@nneyen1764]

THANKSSSSSSSSSS

[@Natthacha_Saengow]

Thank You

[@cseschools]

You're welcome

[@Jimmy_Neutron]

Life saver

[@satisfyingvideos1005]

greet

[@cseschools]

Thank you

[@aspakhala4429]

thanks bro

[@cseschools]

Welcome

[@allan1831]

skip-grant-tables

[@stephy95]

Thank you so much, this fixed the problem so quickly 🥹

[@lichwy]

Fixed my issue, thank you!

[@JeffJessy]

thank you

[@cseschools]

You're welcome