By default MySQL only permits connections from the server on which it resides.
Using SSH you need to connect to your server, then need to edit the my.cnf file, generally located in /etc/mysql/my.cnf on Debian/Ubuntu
Under the [mysqld] section alter the “bind-address” line to bind to the public IP address of the server instead of the loop back IP.
1 2 3 4 5 |
[mysqld] datadir=/var/lib/mysql socket=/var/run/mysqld/mysqld.socket bind-address=127.0.0.1 |
Save the file then restart the MySQL service (# /etc/init.d/mysqld restart)
Now using the MySQL admin tool of your choice create your user accounts but specify the host that they will be connecting from. For example if you are creating a user that connects from the IP address 80.65.35.43 the username will be in this format: username@80.65.35.43
Under OS X one of the tools I couldn’t live without is Quicksliver. If your making the switch to Linux there is a comparable app called Katapult that works in much the same way. It is designed for KDE but doesn’t seem to have trouble running under Gnome and others as well.
If your on Ubuntu or another Debian based distro you can install with:
1 2 |
sudo apt-get install katapult |
There are some great new technologies emerging for the Linux desktop, I think that as time goes on we will not only see the usage of Linux as a desktop increasing, but I think it will threaten Windows and OS X, plus the technologies will most likely be much better implemented. After all OS X is based on Unix and Vista leans on heavily on it too.
Take a look at this jaw dropping video showing just what is possible through the use of Beryl and XGL for the Linux desktop.
Ubuntu seems to be shaping up as the go-to distro for running Linux on the desktop. This is a great link outlining how to create screencasts on your Ubuntu desktop using OS tools.