General

Can’t Connet To MySQL Server

Avatar Written by Arief Fajar Nursyamsu · 28 sec read > 512 views

I just finished to install an Ubuntu Server for office work. It will act as intranet web server and information system database. I used Apache (of course plus PHP) for web server and MySQL as database server.

Installation run well and I could browse MySQL database from phpMyAdmin. I added user who can connect remotely (anyhost) but I didn’t test it. The next day he complained me because he can not connect to MySQL due to an error (Error code: 2003).

If you can not connet to MySQL server as non root users either locally or remotely, it can be solved by editing MySQL configuration file (my.cnf) and comment out the following command:

skip_networking

bind-address = 127.0.0.1

* comment out means that you need to add # before commands.

Restart MySQL server to make it work.

That’s all.

Written by Arief Fajar Nursyamsu
A blogger and now managing a SOHO company selling educational toys. I also run web development and content writing business. Blog and internet marketing as well as SEO are what I am doing a lot. Profile

One Reply to “Can’t Connet To MySQL Server”

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

This site uses Akismet to reduce spam. Learn how your comment data is processed.