August 26, 2020
  • 7:24 am Kerala has a rich tradition of Folklore
  • 7:21 am Kerala Folklore Akademi, an independent center for cultural affairs, was established on 28 june 1995
  • 1:22 pm CÁCH MUA GAME BẢN QUYỀN RẺ VÀ UY TÍN NHẤT 2017
  • 12:59 pm Bé Bảo An – Ba Ơi " Nhạc thiếu nhi hay nhất "
  • 12:03 pm TOP 10 MANHWA YOU NEED TO READING 2020 NEW WEBTOON)| TOP 10 SIÊU PHẨM MANHWA KHÔNG THỂ BỎ QUA



Troubleshoot the Error “Access denied for user ‘root’@’localhost’ (using password: Yes)”
Cannot connect: invalid settings.
mysqli_real_connect(): (HY000/1045): Access denied for user
‘root’@’localhost’ (using password: YES)

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.
Retry to connect.

so let’s start.
First of all, make sure that the XAMPp server is running if it is not running, start the server.
open xampp control panel go to MySQL config – click and open my.ini
now here we are going to paste command in skip section
copy and paste the same command

skip-grant-tables=TRUE

Save and close the file. restart MySQL and refresh localhost/phpmyadmin and here its solved this is just 1st step.
But it’s not resolved 100% yet we need one more setting.

If you have lost the password of your MySQL.

To change the MySQL/MariaDB root password, follow these steps:
Open your Windows command prompt by clicking the “Shell” button in the XAMPP control panel.

Again go to xampp control panel access shell and here just enter the command.

mysql -u root -p

Then it will directly login into your MariaDB.
If a password has already been previously set and you’d like to change it to a new one, you can use the following syntax:

UPDATE mysql.user SET Password=PASSWORD(‘222′) WHERE User=’root’;

Replace this root with your new password so
here we have changed our php MySQL password successfully.

Now we need to update the password into config.ini.php in xampp so open your xampp folder go to the file edit and into password enter a password which you have set in the shell. save and close.

Now open the my.ini file and delete the skip command which we have pasted in 1st step.save and close. Refresh your localhost.

from now you never face such error again while login into phpmyadmin.
———————————————————————–
Here are important steps that must be followed carefully & Commands used in this video.

skip-grant-tables=TRUE
mysql -u root -p
UPDATE mysql.user SET Password=PASSWORD(‘222′) WHERE User=’root’;

Make sure to restart mysql after any changes.
Don’t forget to removing the inserted line and restart mysql again.
======================================================

Nguồn: https://keralafolkloreakademy.com/

Xem thêm bài viết khác: https://keralafolkloreakademy.com/giai-tri/

admin

RELATED ARTICLES

31 COMMENTS

  1. Roberto Grijalva Posted on July 4, 2020 at 10:22 am

    La conexion al realizar consultas es lento, alguna manera para poder aumentar la velocidad?

    Reply
  2. christina clara Posted on July 4, 2020 at 10:22 am

    Thankyou!

    Reply
  3. Meshack Koontse Posted on July 4, 2020 at 10:22 am

    I loooooove you😊😊😊💯💯🔥🤛

    Reply
  4. abhijit chore Posted on July 4, 2020 at 10:22 am

    you saved my day thank you dear

    Reply
  5. Flamur Beqiraj Posted on July 4, 2020 at 10:22 am

    This video just saved my life! God bless you…

    Reply
  6. Kanishka Udugoda Posted on July 4, 2020 at 10:22 am

    Thank you! Really helpful!! 😀

    Reply
  7. Itzel Melendez Posted on July 4, 2020 at 10:22 am

    Thanks is so bit for all you help me

    Reply
  8. Mujeeb Syed Posted on July 4, 2020 at 10:22 am

    Thanks a lot for solving my problem

    Reply
  9. Darsh Gupta Posted on July 4, 2020 at 10:22 am

    Thank you SOOOOOO much! This solved my problem! I even bookmarked this to my browser so that I can use it when I want! Please don't delete this video EVER!

    Reply
  10. Kaddi Ismail Posted on July 4, 2020 at 10:22 am

    THANKS SO MUCH

    Reply
  11. Nasiru Adebare Posted on July 4, 2020 at 10:22 am

    Thank you so much this really helped me big time

    Reply
  12. Sophiya Baskaran Posted on July 4, 2020 at 10:22 am

    Thank you for the video. It help me very much 🙂

    Reply
  13. oop3 assignment Posted on July 4, 2020 at 10:22 am

    Thanks a lot

    Reply
  14. Valerie Vayelle Posted on July 4, 2020 at 10:22 am

    i don't have the my.ini file what do i do?

    Reply
  15. Ibrahim Khan Posted on July 4, 2020 at 10:22 am

    I am getting the error in command prompt. ERROR 1348 (HY000): Column 'Password' is not updatable.

    Reply
  16. akshat jain Posted on July 4, 2020 at 10:22 am

    Error abhi bhi yhi h

    Reply
  17. Rajat Kulkarni Posted on July 4, 2020 at 10:22 am

    Thank you so much

    Reply
  18. Close Range Posted on July 4, 2020 at 10:22 am

    THANKYOU SO SO MUCH MAM!

    Reply
  19. Muhammad Usman Posted on July 4, 2020 at 10:22 am

    thank you madam you solved my problem

    Reply
  20. Muazzam Khokhar Posted on July 4, 2020 at 10:22 am

    Thanks its really work.

    Reply
  21. cabdilaahi mahdi Posted on July 4, 2020 at 10:22 am

    thnx it helps me tomorrow is my project exam and i forget the xampp password it help me more love

    Reply
  22. Aloistwilight Posted on July 4, 2020 at 10:22 am

    me resolvio el problema gracias a este video

    Reply
  23. Kamil Malak Posted on July 4, 2020 at 10:22 am

    i love you <3

    Reply
  24. W. Gabriel Henriquez Posted on July 4, 2020 at 10:22 am

    GRACIAS means THANK YOU

    Reply
  25. Shazaam ZS Posted on July 4, 2020 at 10:22 am

    thanks you jeee

    Reply
  26. Mike Posted on July 4, 2020 at 10:22 am

    I'm having the issue on a live server. How do I handle it?
    Thanks for replying.

    Reply
  27. Boom gard Posted on July 4, 2020 at 10:22 am

    it is work, thank you

    Reply
  28. Alvaro Céspedes Posted on July 4, 2020 at 10:22 am

    Gracias, en efecto al probar skip-grant-tables=TRUE, funciono.

    Ty.

    Reply
  29. Civil Viking Posted on July 4, 2020 at 10:22 am

    Thank the good lord, the only REAL solution on the internet.

    Reply
  30. Kiobc Posted on July 4, 2020 at 10:22 am

    Mil gracias me funciono, merecido like 😀

    Reply
  31. Result Lol Posted on July 4, 2020 at 10:22 am

    ERROR 1348 (HY000): Column 'Password' is not updatable , help please

    Reply
LEAVE A COMMENT