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
Thông Tin

MySQL said: Cannot connect: invalid settings. | mysqli_real_connect(): (HY000/2002): No connection..

July 11, 2020 18 Comments



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/

Xem thêm Bài Viết:

admin

RELATED ARTICLES

Samsung 860 Evo SSD 500 GB Unboxing Install & Comparison to 850 EVO 500 GB

Microsoft SQL Server 2017 Installation – Step By Step Process To Install SQL Server

Querying MS SQL Server: Using STUFF Function (Trans-SQL)

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. Zamara s Posted on July 11, 2020 at 6:12 pm

    not working

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

    man thank you … realy good video with calm and precision

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

    thank you so mach bro

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

    Thanks, its works in my ubuntu

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

    Solves mine , thanks bro

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

    not working for me. its already port 3306

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

    Thank you so much

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

    same error …………

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

    Thanks you.

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

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

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

    Thanks sir you save more

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

    Thanks sir you save more

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

    Thanku it was very helpful

    Reply
  16. 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
  17. Brandon Martínez Posted on July 11, 2020 at 6:12 pm

    Thanks you so much !!

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

    You saved my day bro 🙂

    Reply
LEAVE A COMMENT

Tìm Kiếm
Bài Viết Gần Đây
Lưu Trữ
Copyright @ 2020 By chaoticpharmacology