InkStitch - Tin tổng hợp Bất Động Sản, Công Nghệ, Giải Trí đầy đủ nhất
  • Trang Chủ
  • Công Nghệ
No Result
View All Result
  • Trang Chủ
  • Công Nghệ
No Result
View All Result
InkStitch - Tin tổng hợp Bất Động Sản, Công Nghệ, Giải Trí đầy đủ nhất
No Result
View All Result

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

admin by admin
February 3, 2020
in Công Nghệ
0
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://inkstitch.net/

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

Tags: Youtube
Previous Post

Dịch vụ Guest Post HapoDigital có gì?

Next Post

Tài khoản VIP Zing mp3, Zing Tv, nhaccuatui miễn phí (Vip Trọn đời)

Next Post
Tài khoản VIP Zing mp3, Zing Tv,  nhaccuatui miễn phí (Vip Trọn đời)

Tài khoản VIP Zing mp3, Zing Tv, nhaccuatui miễn phí (Vip Trọn đời)

Leave a Reply Cancel reply

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

Về Chúng Tôi

ink stitch

Tin tổng hợp Bất Động Sản, Công Nghệ, Kinh Doanh, Giải Trí, Làm Đẹp đầy đủ nhất ở Ink Stitch. Đặc biệt chúng tôi có chuyên mục tin hot cập nhật những xu thế tin nổi bật nhất từng giờ

  • Giới Thiệu
  • Liên Hệ
  • Chính Sách Bảo Mật

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

No Result
View All Result
  • Trang Chủ
  • Công Nghệ

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