MySQL said: Cannot connect: invalid settings. | mysqli_real_connect(): (HY000/2002): No connection..admin 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.”
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.
Xem thêm bài viết khác: https://chaoticpharmacology.com/cong-nghe/
Xem thêm Bài Viết:
- Samsung Galaxy Trend Plus S7580 hard reset
- FPT Shop – Khui hộp Samsung Galaxy Tab 3 V – Tablet tầm trung cho người Việt
- [Review dạo] Đánh giá chi tiết Samsung Galaxy S5 LTE A G906
- HARD RESET S2 HD , E120L , E120K MỞ KHÓA MÀN HÌNH S2HD , HIEU MOBILE
- Tư vấn điện thoại Galaxy Note 5 bây giờ chỉ còn 2 đến 3 triệu liệu có đáng mua không?