mysqli_connect(): (HY000/2002): Connection refused

Hi, I am new to Macbook. I am trying to setup localhost php & mysql in my Macbook but failed to connect to my localhost mysql database. Can anyone help me?

Error Code:

Database connection:

$con=mysqli_connect("127.0.0.1","root","","my_db");

Posted on Sep 24, 2021 7:10 AM

Similar questions

MYSQL websites connecting to database. Have mysql installed with phpMyAdmin, Mysql is running and can log in via of localhost, 127.0.0.1 and via of domain name through phpMyadmin, however website cannot access database, have researched this problem for days without success.
447 6
Trouble setting up local server In the Terminal I was testing the Apache server for connection, but it returned the following data. I'm not sure how or where to set the 'ServerName' directive globally? Is it possible that someone could guide me? I'm working on a Macbook Air OS Big Sur 11.7.1. I have installed XAMPP server and in the dashboard it shows an ip address and the green light is on indicating it is running, under NETWORK the mySQL, ProFTPD and Apache has been enabled and also have green lights beside each. I have setup the localhost and when tested it returns stating that "it Works". apachectl configtest AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using Davids-MacBook-Air.local. Set the 'ServerName' directive globally to suppress this message Syntax OK
4734 4
using (Setting up a local web server on macOS 10.14 “Mojave”) I followed the steps posted by "etresoft" on my MacBook Pro running macOS Mojave Version 10.14.6, but the configuration failed! $ apachectl configtest AH00557: httpd: apr_sockaddr_info_get() failed for KAPAMACT3B5HTD5 AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1. Set the 'ServerName' directive globally to suppress this message (2)No such file or directory: AH02291: Cannot access directory '/private/var/log/apache2/' for main error log AH00014: Configuration check failed p2725316 at KAPAMACT3B5HTD5 in /etc/apache2
1930 4

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

mysqli_connect(): (HY000/2002): Connection refused

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up