This is intended for Linux, Unix, OS X users who use SSH to connect to a remote server and tire of repeatedly entering their password. (This works really well for subversion users for instance.) In this short post we’ll create a public key and add this key to your server’s list of good guys. Just be careful, anyone who could access your ~/.ssh directory could copy this file and use it to do the same. Be smart!

(more…)

I’ve been using GoDaddy’s Dedicated Hosting since they first released it (I was working there at the time, so I had it for something very close to free). I recently upgraded to a better server for less money and have spent a lot of time getting things tweaked and optimized for my needs. For those playing at home this is what my server looks like:

• Operating System: Red Hat Fedora Core 6
• Processor: Intel Pentium 4 - 3.0 GHz
• RAM: 2 GB
• Total Disk Space: 120 GB
• Control Panel Type: Plesk
• Plesk Domains: 30
• Power Pack: Deluxe

(more…)

I like to keep the default settings of only letting localhost access the databases for the most part. From a SSH session you can enable access to a particular user from a particular IP in order to use programs like Navicat or enable access from another file server.

1. First connect to your server via SSH.
2. Then launch mysql by typing the following:

    

   mysql -u admin -p

    

3. Now we will grant access to the desired ip address:

    

   GRANT ALL PRIVILEGES ON *.* TO user@ipaddress IDENTIFIED BY "password"

    

4. Now just reload the server’s privileges:

    

   FLUSH PRIVILEGES;

    

5. You can now connect to your database from your ip address with the user and password specified!

Now, let’s say that you’re feeling adventurous and you want to grant privileges to yourself from any IP address (not advisable). Just use the wildcard statement (”%”) in place of the ip address.

For more info on the GRANT syntax.