August 24, 2020
  • 7:26 am Cách chèn nhạc vào ảnh và video trên Facebook
  • 6:59 am Tóm Tắt The Walking Dead (Xác Sống) | Season 4
  • 6:15 am [Mất gốc Hóa – số 16] – HƯỚNG DẪN CÁCH GỌI TÊN OXIT AXIT – OXIT BAZƠ NHANH THUỘC
  • 5:49 am Cách cài Win từ ổ cứng: cả Win 7/8/8.1 và Win10 (làm mẫu với Win 10)
  • 5:12 am Thủ thuật excel: Cách khóa dữ liệu không cho chỉnh sửa trong excel



This is a very common MySQL problem that is has very few answers out there. I thought I would create a quick video on how you can easily fix this problem.

The Errors that I get are the following:

-“mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.”
-“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.”
-“MySQL said:
Cannot connect: invalid settings.”

The fix is extremely simply, all it takes is going into the my.ini file for mySQL on XAMPP and switching the port setting. Oftentimes the port is set to a different port than it should be.
In my case it was set to port 3308, and so I switched it to the default port for mySQL which is port 3306 and this fixed the problem for me. If you have any questions please let me know, and I will do my best to answer them for you.

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

Xem thêm bài viết khác: https://chaoticpharmacology.com/cong-nghe/

admin

RELATED ARTICLES

18 COMMENTS

  1. andres garcia Posted on July 11, 2020 at 6:12 pm

    Thanks, another hero without the cap…

    Reply
  2. geetha faith Posted on July 11, 2020 at 6:12 pm

    Fixed!!!!! Thank You so Much!!!!!!!

    Reply
  3. Diego Palo Posted on July 11, 2020 at 6:12 pm

    man thank you … realy good video with calm and precision

    Reply
  4. AFB-iT Posted on July 11, 2020 at 6:12 pm

    thank you so mach bro

    Reply
  5. Müller Posted on July 11, 2020 at 6:12 pm

    Thanks, its works in my ubuntu

    Reply
  6. Faysal Shuvo Posted on July 11, 2020 at 6:12 pm

    Solves mine , thanks bro

    Reply
  7. Paulius Gru Posted on July 11, 2020 at 6:12 pm

    not working for me. its already port 3306

    Reply
  8. Weldy Guruh Posted on July 11, 2020 at 6:12 pm

    Thank you so much

    Reply
  9. Under Graduates Posted on July 11, 2020 at 6:12 pm

    same error …………

    Reply
  10. Real Peoples Ratings Posted on July 11, 2020 at 6:12 pm

    Fever Rel… thank you. Excellent, simple, and effective.

    Reply
  11. EQUINOX Posted on July 11, 2020 at 6:12 pm

    Thanks sir you save more

    Reply
  12. EQUINOX Posted on July 11, 2020 at 6:12 pm

    Thanks sir you save more

    Reply
  13. Anamika Kashyap Posted on July 11, 2020 at 6:12 pm

    Thanku it was very helpful

    Reply
  14. afca Posted on July 11, 2020 at 6:12 pm

    You can also change the port for Mysql by clicking on config -> Service and port settings -> mysql

    Reply
  15. Brandon Martínez Posted on July 11, 2020 at 6:12 pm

    Thanks you so much !!

    Reply
  16. King Horus Posted on July 11, 2020 at 6:12 pm

    You saved my day bro 🙂

    Reply
LEAVE A COMMENT