Saesrpg - Cập nhật nhiều tin hay nhất hiện nay
  • Home
  • Máy Tính
  • Điện Thoại
  • Công Nghệ
No Result
View All Result
  • Home
  • Máy Tính
  • Điện Thoại
  • Công Nghệ
No Result
View All Result
Saesrpg - Cập nhật nhiều tin hay nhất hiện nay
No Result
View All Result
Home Giải Trí

Solve mysql_connect() Access Denied For User 'root'@'localhost' (Using Password Yes)

admin by admin
July 3, 2020
in Giải Trí
36
Solve mysql_connect() Access Denied For User 'root'@'localhost' (Using Password Yes)



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://saesrpg.net/

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

Xem thêm Bài Viết:

  • TRÒ CHƠI "XOẮN NÃO" DỄ QUẠO NHẤT VỤ TRỤ | Nabee TV
  • Conversation with foreigners in English | Learn English for all levels
  • Cố Chấp – Về Nơi Đâu (Phần 1) – TraCy Thảo My [ Official Music Video ]
  • Học trực tuyến trên truyền hình MyTV: Giải pháp tối ưu mùa Covid-19
  • Hướng dẫn sử dụng tính năng Điều khiển tivi (Remote Controller) trên MyTV và MyTV Net
Previous Post

2 cách xem mật khẩu (Password) Wifi trên Windows 10

Next Post

Hướng dẫn lắp đặt máy lạnh treo tường đúng kỹ thuật

Next Post
Hướng dẫn lắp đặt máy lạnh treo tường đúng kỹ thuật

Hướng dẫn lắp đặt máy lạnh treo tường đúng kỹ thuật

Comments 36

  1. Roberto Grijalva says:
    2 years ago

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

    Reply
  2. christina clara says:
    2 years ago

    Thankyou!

    Reply
  3. Meshack Koontse says:
    2 years ago

    I loooooove you😊😊😊💯💯🔥🤛

    Reply
  4. abhijit chore says:
    2 years ago

    you saved my day thank you dear

    Reply
  5. Flamur Beqiraj says:
    2 years ago

    This video just saved my life! God bless you…

    Reply
  6. Kanishka Udugoda says:
    2 years ago

    Thank you! Really helpful!! 😀

    Reply
  7. Itzel Melendez says:
    2 years ago

    Thanks is so bit for all you help me

    Reply
  8. Mujeeb Syed says:
    2 years ago

    Thanks a lot for solving my problem

    Reply
  9. Darsh Gupta says:
    2 years ago

    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 says:
    2 years ago

    THANKS SO MUCH

    Reply
  11. Nasiru Adebare says:
    2 years ago

    Thank you so much this really helped me big time

    Reply
  12. Sophiya Baskaran says:
    2 years ago

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

    Reply
  13. oop3 assignment says:
    2 years ago

    Thanks a lot

    Reply
  14. Valerie Vayelle says:
    2 years ago

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

    Reply
  15. Ibrahim Khan says:
    2 years ago

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

    Reply
  16. akshat jain says:
    2 years ago

    Error abhi bhi yhi h

    Reply
  17. Rajat Kulkarni says:
    2 years ago

    Thank you so much

    Reply
  18. Close Range says:
    2 years ago

    THANKYOU SO SO MUCH MAM!

    Reply
  19. Muhammad Usman says:
    2 years ago

    thank you madam you solved my problem

    Reply
  20. Muazzam Khokhar says:
    2 years ago

    Thanks its really work.

    Reply
  21. cabdilaahi mahdi says:
    2 years ago

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

    Reply
  22. Aloistwilight says:
    2 years ago

    me resolvio el problema gracias a este video

    Reply
  23. Kamil Malak says:
    2 years ago

    i love you <3

    Reply
  24. W. Gabriel Henriquez says:
    2 years ago

    GRACIAS means THANK YOU

    Reply
  25. Shazaam ZS says:
    2 years ago

    thanks you jeee

    Reply
  26. Mike says:
    2 years ago

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

    Reply
  27. Boom gard says:
    2 years ago

    it is work, thank you

    Reply
  28. Alvaro Céspedes says:
    2 years ago

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

    Ty.

    Reply
  29. Civil Viking says:
    2 years ago

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

    Reply
  30. Kiobc says:
    2 years ago

    Mil gracias me funciono, merecido like 😀

    Reply
  31. Result Lol says:
    2 years ago

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

    Reply
  32. Juan Rico says:
    2 years ago

    Very, very, very thank you, this really solved my problem… CRACK

    Reply
  33. Silva Muzembe says:
    2 years ago

    thenks for your help

    Reply
  34. KAYVIA TELEVISION says:
    2 years ago

    my files are hosted on a live server….. what do i do?

    Reply
  35. Marc T says:
    2 years ago

    that worked great…thanks

    Reply
  36. Shimul Rahman says:
    2 years ago

    Thank you so much for your good job ! It`s very helpful for me.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Xem Thêm

Galaxy S8 Plus Hàn 2 sim GIÁ SẮP CHẠM ĐÁY !

Galaxy S8 Plus Hàn 2 sim GIÁ SẮP CHẠM ĐÁY !

July 2, 2020
RẺ nhưng cẩn thận. Hướng dẫn test và mua Samsung Galaxy S8, S8 Plus Cũ.

RẺ nhưng cẩn thận. Hướng dẫn test và mua Samsung Galaxy S8, S8 Plus Cũ.

July 2, 2020
Schannel – Trên tay Galaxy S8 tại Việt Nam: Smartphone đẹp nhất hiện nay!

Schannel – Trên tay Galaxy S8 tại Việt Nam: Smartphone đẹp nhất hiện nay!

July 2, 2020
Đừng vội mua Galaxy S8+ Singapore hay S8+ Đài Loan khi bạn chưa xem Clip này, S8 plus Đài Loan

Đừng vội mua Galaxy S8+ Singapore hay S8+ Đài Loan khi bạn chưa xem Clip này, S8 plus Đài Loan

July 2, 2020
AI THỪA TIỀN KHÔNG NÊN XEM, Galaxy S8 Plus Singapore Những lý do khiến bạn nhất định nên mua

AI THỪA TIỀN KHÔNG NÊN XEM, Galaxy S8 Plus Singapore Những lý do khiến bạn nhất định nên mua

July 2, 2020
Tại sao nên mua Samsung Galaxy S8 xách tay hơn hàng chính hãng?

Tại sao nên mua Samsung Galaxy S8 xách tay hơn hàng chính hãng?

July 2, 2020

saesrpg-logo

Saesrpg.net – Cập nhật nhiều tin hay nhất hiện nay, tin ẩm thực với nhiều công thức nấu ăn ngon, tin giải trí âm nhạc, và chuyên mục về công nghệ tổng hợp hay

 

  • Chính Sách Bảo Mật
  • Liên Hệ

© 2022 JNews - Premium WordPress news & magazine theme by Jegtheme.

No Result
View All Result
  • Home
  • Máy Tính
  • Điện Thoại
  • Công Nghệ

© 2022 JNews - Premium WordPress news & magazine theme by Jegtheme.