Save the file and exit, afterwards restart the mysql service like so: $ sudo systemctl start rvice Look for the line below and comment it out using the # character: bind-address = 127.0.0.1 If all the above commands run successfully, but you still see the error, open the mysql config file. Therefore use the -P option to specify the port you see from the output above while accessing the database server: $ mysql -u username -p -h host_address -P portģ.

-p – shows PID and name of the program owning the socket.

-n – enables display of numerical addresses.

If you still get the same error, then determine the port (default is 3306) on which the mysql daemon is listening by running the netstat command. If there is no output from the previous command, start the mysql service as follows: $ sudo systemctl start rviceĪfter starting mysql service, try to access the database server: $ mysql -u username -p -h host_addressĢ.

-A – activates selection of all processes.

Once there is connectivity, use the ps command below which shows information about a selection of the active processes, together with a pipe and grep command, to check that the mysql daemon is running on your system. If database server is on a remote machine, then try to test the client-server connectivity using ping command, for instance: $ ping server_ip_address Below are the essential steps to deal with it.ġ.

Mysql 10038