Solve PHPMyAdmin Access Denied for User (Top 2 Methods)

The error: phpmyadmin access denied for user 'root'@'localhost' (using password no) when trying to access phpmyadmin xampp on your local server in a common phpmyadmin xampp error. In this video, I will show you two methods to solve this error and get rid of the phpmyadmin access denied message. Phpmyadmin is a free and open source web-based tool that allows you to manage MySQL and MariaDB databases. It is widely used by web developers and administrators to create, modify, and delete databases, tables, columns, indexes, users, permissions, and more. However, sometimes you may encounter the error phpmyadmin access denied for user 'root'@'localhost' (using password no) when you try to log in to phpmyadmin using the default username and password. This error means that phpmyadmin cannot authenticate the user 'root' with the password 'no' on the localhost server. This can happen due to various reasons, such as incorrect configuration, wrong password, or corrupted files.
In this video, I will guide you through the following steps:
How to modify the config file for phpmyadmin to set the correct user and password for accessing phpmyadmin. This method involves editing the config.inc.php file in the phpmyadmin folder and changing the values of the $cfg['Servers'][$i]['user'] and $cfg['Servers'][$i]['password'] variables to match your MySQL or MariaDB credentials.
How to use skip-grant-tables to change the user password for accessing phpmyadmin. This method involves restarting the MySQL or MariaDB service with the skip-grant-tables option, which allows you to bypass the authentication process and log in as any user without a password.
By the end of this video, you will be able to fix the error phpmyadmin access denied for user 'root'@'localhost' (using password no) and access your phpmyadmin dashboard without any hassle.
If you liked this video, please give it a thumbs up and subscribe to my channel for more videos like this. Also, don't forget to share this video with your friends who might be interested in learning how to fix phpmyadmin access denied error. Thank you for watching and see you in the next video.
Keywords: phpmyadmin access denied for user 'root'@'localhost' (using password no), how to fix phpmyadmin access denied error, phpmyadmin access denied error solution, phpmyadmin access denied error tutorial, phpmyadmin access denied error guide, phpmyadmin access denied error tips, phpmyadmin access denied error tricks, phpmyadmin access denied error review, phpmyadmin access denied error demo, phpmyadmin access denied error configuration, phpmyadmin access denied error setup
🌐 Connect with me:
TikTok: / thecodecity
Twitter: / thecodecity
Instagram: / thecodecity
Website: thecodecity.com
#phpmyadmin #webdevelopment #xampp

[@TheCodeCity]

If this video helped you, considering buying me a coffee so I can continue making free helpful videos: www.buymeacoffee.com/thecodecity
Thank you for watching! 🤜🙏

[@piyalibagani7]

I was so afraid with my created databases.
It really helped me. Thank you so much sir. You helped a lot.

[@TheCodeCity]

My pleasure, glad it helped!

[@ShobhitPandey-h7g]

Thankyou soo much I was troubled from 3 days but your video solve this problem within 3 min. Again Thankyou

[@TheCodeCity]

Glad it helped, thank you for watching :)

[@_kenabey_]

Honestly bro, your video was the only one that helped. Thank you.

[@heyitsmedaisyyy]

Thank youuuu so much😭.
It really helps me hys defense pa naman sa Saturday 😭

[@heyitsmedaisyyy]

Sana pala hindi na lang ako nag dl ng mysql workbench 🙂🤬🤬

[@TheCodeCity]

Glad it helped, thank you for watching :)

[@heyitsmedaisyyy]

@@TheCodeCity no, thank youuu for teaching us!

[@SergioFerreira.]

youre the only that really have solved my problem thx

[@TheCodeCity]

Thank you for watching! glad it helped 🙂

[@royngudeyi]

Cant change the password, error #1290 - The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

[@ejhayrufino3235]

thanks for this sir, the 2nd method works for me 💖💖

[@tech_sheikh27]

You are a life saver. Love from Nigeria ❤

[@arbazahmed4512]

i accidently lock users in admin panel. by adding this skip-grant-tables helped thank you

[@jeffersondetalo6226]

You saved my work man!!!! Thank youuuuuuuuuuuuuu 😭😭

[@ryanmaharaj9204]

thanks buddy, this fixed my issue , I appreciate it

[@bikkinenipradeep]

It really helped me. Thank you so much , The second method worked fine.

[@TheCodeCity]

You're welcome! glad it helped!

[@mkumsengaung5438]

Thank you so much!! Really appreciate it!

[@TheCodeCity]

You're welcome!

[@riaddjaid7428]

Thank you so much man , it's very helpful.

[@kawsarmobarak4058]

Thanks bro. It does work. U just saved my life

[@ZamanAli-l9o]

i solve this error after watching your video. thanks dear

[@TheCodeCity]

My pleasure, glad it helped!

[@darpanadhikari6376]

Thank you so much, it works in my case

[@jamesosteen982]

ERROR - #1290 - The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement ... you cant reset the password while using skip-grant-tables so how do you reset the password if you don't know it?

[@ChaudharyIntaza]

did you find any solution to this ?

[@ccash4574]

didnt work.

[@ساشامحمد-د8ج]

it is really helped me. Thank you so much

[@TheCodeCity]

Thank you for watching! glad it helped 🙂

[@tahiraleem]

Luckily, I remembered my password. Otherwise "skip-grant-tables" didn't work for me. Thanks

[@Yamishuki]

Bro you the best❤

[@TheCodeCity]

You're welcome! Glad it helped 🙂

[@ClayRavin]

Really needed XAMPP in the video title. Not really applicable for hosted CPanel accounts..

[@noneofyourbusiness2824]

Thank you for guiding

[@TheCodeCity]

Glad it helped! thank you for watching :)

[@hackerstatus8338]

show error why

[@PhanLeThanhTruong]

thank you bro! you are my hero

[@AwesomeBoy-v8j]

Thank you very much!

[@TheCodeCity]

You're welcome!

[@ihsanahmad7650]

Its helpful. Thanks

[@TheCodeCity]

You're welcome! glad it helped :)

[@adeelahmad6506]

Working

[@kunalparmar5801]

thank you

[@rogermillamilla3913]

oh thanks that worked

[@sandrakpradeep3825]

❤❤❤

[@vishwanathshinde3843]

Thanks 👍

[@TheCodeCity]

You're welcome! Glad it helped

[@samhammer2468]

Thank you thank you thank you

[@ChakibStudentHamada]

you saved me thx bro

[@IsratJahan-r3u8e]

thankuuu

[@josephdeso]

Absolutely worked 😂😂😂😂

[@TheCodeCity]

Thank you for watching! glad it helped :)

[@karbonath_]

thanks

[@TheCodeCity]

Glad it helped! thank you for watching :)

[@jonathanmangiringpanggabea4008]

I LOVE U SO MCHHHH

[@TheCodeCity]

You're welcome! Glad it helped 🙂

[@VivekYadav-ii2vl]

Thanks bro❤

[@TheCodeCity]

You're welcome! glad it helped!

[@IanMahetiMbano]

Thank you!!!

[@TheCodeCity]

You're welcome!

[@sh.mh20]

thx

[@TheCodeCity]

You're welcome!

[@patkarsarvesh7376]

thanks bruh

[@TheCodeCity]

Glad it helped!

[@hdndchjsjdj3774]

I love you

[@TheCodeCity]

Glad it helped!

[@unamsani1982]

Thank you so much @thecodecity

[@TheCodeCity]

Glad it helped!

[@vishalshrestha6733]

Thank you!

[@AwesomeBoy-v8j]

Thank you very much!

[@AwesomeBoy-v8j]

Thank you very much!

[@TheCodeCity]

Glad it helped!

[@yomum9404]

Thank u so much!!!