Mark Foster’s Blog

In my previous post I covered setting up/installing MySQL and connecting via MySQL Administrator from a remote host. In this post I will talk about the PostgreSQL equivalent. As a side note, any database system should always be behind a firewall of some kind. Putting up a database server on a public IP using the [...]

There are a few “gotchas” if you are trying to setup MySQL on Linux server, Ubuntu in this case, and connect to it using MySQL Administrator from somewhere else. Here is what worked for me… Install MySQL server and MySQL GUI Tools To install MySQL on a Ubuntu server use: sudo apt-get install mysql-server If [...]