Kelvin's tech-box
  • Home
  • About
By Kelvin Li in linux — May 3, 2012

Enable the remote connection to the MySQL DB on Ubuntu Server

Create a MySQL user
mysql> GRANT ALL PRIVILEGES ON remote.* TO remote@"%" IDENTIFIED BY "remotepwd";

Change the /etc/mysql/my.cnf
disable the bind-address = 127.0.0.1

Restart the DB
sudo /etc/init.d/mysql restart

Done.

Previous issue

How to use the SSH in the proxy env

Next issue

Start service automatically on linux server

Kelvin's tech-box © 2025
Powered by Ghost