Madisonrep - Báo tin tức với các bài phóng sự video clip độc quyền
  • Home
  • Bất Động Sản
  • Công Nghệ
  • Kinh Doanh
No Result
View All Result
  • Home
  • Bất Động Sản
  • Công Nghệ
  • Kinh Doanh
No Result
View All Result
Madisonrep - Báo tin tức với các bài phóng sự video clip độc quyền
No Result
View All Result

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

admin by admin
January 25, 2020
in Công Nghệ
23
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://madisonrep.org/

Xem Thêm Bài Viết Khác:https://madisonrep.org/cong-nghe

Previous Post

Bà Xã Theo Anh Về Nhà Đi - Truyện Ngôn Tình Lay động trái tim Triệu Người

Next Post

Những bức ảnh hài hước cho bạn tiếng cười sảng khoái - Phần 1

Next Post
Những bức ảnh hài hước cho bạn tiếng cười sảng khoái – Phần 1

Những bức ảnh hài hước cho bạn tiếng cười sảng khoái - Phần 1

Comments 23

  1. Roberto Grijalva says:
    2 years ago

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

    Reply
  2. Muazzam Khokhar says:
    2 years ago

    Thanks its really work.

    Reply
  3. 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
  4. uroborosep07 says:
    2 years ago

    me resolvio el problema gracias a este video

    Reply
  5. Kamil Malak says:
    2 years ago

    i love you <3

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

    GRACIAS means THANK YOU

    Reply
  7. zamroot siyam says:
    2 years ago

    thanks you jeee

    Reply
  8. Mike says:
    2 years ago

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

    Reply
  9. Boom gard says:
    2 years ago

    it is work, thank you

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

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

    Ty.

    Reply
  11. Civil Viking says:
    2 years ago

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

    Reply
  12. Kiobc says:
    2 years ago

    Mil gracias me funciono, merecido like 😀

    Reply
  13. Result Lol says:
    2 years ago

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

    Reply
  14. Juan Rico says:
    2 years ago

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

    Reply
  15. Silva Muzembe says:
    2 years ago

    thenks for your help

    Reply
  16. KAYVIA TELEVISION says:
    2 years ago

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

    Reply
  17. Marc T says:
    2 years ago

    that worked great…thanks

    Reply
  18. Shimul Rahman says:
    2 years ago

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

    Reply
  19. Pratiksha Patnaik says:
    2 years ago

    Thank you. It worked for me

    Reply
  20. Gaurav Choudhary says:
    2 years ago

    Thank you so so much!!

    Reply
  21. JTechpreneur says:
    2 years ago

    Daaamn! After a 2hr hustle online to solve the issue, yours worked perfectly! Thanks

    Reply
  22. atta 2055 says:
    2 years ago

    You Win This From Google Search Engine i had Tried so many searches but i was filed to find but you just solve Our Problem Just In 1 minutes Thanks A lot

    Reply
  23. Marian Alexandru says:
    2 years ago

    After I enter rhe command: UPDATE mysql.user SET Password=PASSWORD('admin123') WHERE User='root'; I get this error in xampp cmd : Table 'user' is marked as crashed and should be repaired. What should I do to get this working?

    Reply

Leave a Reply Cancel reply

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

Xem Thêm

BRG SMART CITY ĐÔNG ANH MỚI NHẤT 2022

BRG SMART CITY ĐÔNG ANH MỚI NHẤT 2022

June 29, 2022
Nên mua chung cư cao tầng hay thấp tầng?

Nên mua chung cư cao tầng hay thấp tầng?

June 23, 2022

Thông tin chi tiết 7 căn hộ ở quận Binh Chanh là người quan tâm nhất Quận Bình Chánh

June 9, 2022
Giá cho thuê nhà riêng tại Hà Nội nguyên căn

Giá cho thuê nhà riêng tại Hà Nội nguyên căn

March 4, 2022
Công viên Cầu Vồng Vinhomes Grand Park được ví như một thiên đường sống

Vì sao gọi công viên Cầu Vồng Vinhomes Grand Park là thiên đường?

May 17, 2021
Thủ tục hợp thức hóa nhà đất Nam Cầu Nguyễn Tri Phương Đà Nẵng là gì?

Thủ tục hợp thức hóa nhà đất Nam Cầu Nguyễn Tri Phương Đà Nẵng là gì?

January 11, 2021
  • Giới Thiệu
  • 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
  • Bất Động Sản
  • Công Nghệ
  • Kinh Doanh

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