http://scratchpad.farmsoftstudios.com What We're Thinking About Right Now... Thu, 20 Nov 2008 15:04:03 +0000 http://backend.userland.com/rss092 en Do you need to quickly add a specific user with access to only a certain table? Issue this command as a root or admin user: GRANT ALL ON testdb.* TO 'testuser'@'localhost' IDENTIFIED BY 'pass1'; You can also limit user's privileges to specific ip addresses or domains in case you need to ... http://scratchpad.farmsoftstudios.com/2008/11/web-design/adding-a-user-in-mysql/ Want to know if you have CentOS 4.5 or 5.0? Issue this command: cat /etc/redhat-release That file contains the needed version information. [root@localhost ~]# cat /etc/redhat-release CentOS release 5 (Final) http://scratchpad.farmsoftstudios.com/2008/11/linux/find-the-version-of-centosrhel-without-rebooting/ Need to mount a samba share on your CentOS server from the command line? Create a directory on the root: mkdir /sharename Then mount the share: mount -t cifs //<servername>/<sharename> /sharename if you type df -h you should see that your share is now mounted on the mountpoint that you created earlier. http://scratchpad.farmsoftstudios.com/2008/10/linux/mounting-a-samba-smb-share-in-centos/ Ever needed to connect to the remote console of the machine rather than running through a terminal services session so that you could install certain software, or reset stuck terminal services sessions from a remote location? All you have to do is type /console behind the host in the ... http://scratchpad.farmsoftstudios.com/2008/10/apple-computer/connecting-to-the-remote-windows-console-with-macs-rdp-client/ I wrote a little application that allows you to play music from Pandora right from your dock. It does not take up a tab in your web browser, and it supports playing while minimized, which Safari does not. You can get it here: http://www.farmsoftstudios.com/pandora/ http://scratchpad.farmsoftstudios.com/2008/10/farmsoft-studios/pandora-music-application/ If you like the alternating table backgrounds that are in applications like iTunes, and want them in your web application, there is a simple way to do so in PHP: <table>  <tr class="title">   <td></td>  </tr> <?php $i=0; foreach($row as $r){    if($i&0){$alt=' class="even"';}else{$alt='';}    echo "<tr".$alt.">";    //other table stuff in here    $i++;    echo "</tr>"; } ?> </table> http://scratchpad.farmsoftstudios.com/2008/09/graphic-design/alternating-table-backgrounds-in-php/ These days, I consider the failure to use version control a professional malpractice. I’m also a zealot when it comes to deleting dead code. In fact, I derive quite a bit of enjoyment out of deleting existing code. Unused code, old code, mockups, things that were started and never finished, things that someone thought they needed ... http://scratchpad.farmsoftstudios.com/2008/09/web-design/project-management/ Instead of serving your web design / programming needs in the rolling hills of Wisconsin, we're now available in the Statesville, Mooresville, Charlotte, and greater Piedmont area. Look us up if you get a chance! http://scratchpad.farmsoftstudios.com/2008/09/web-design/weve-moved/ To block an ip address from accessing your linux box, you can use the following iptables rule: iptables -A INPUT -s 222.124.24.131 -j DROP If you just need to block a certain port (i.e. port 22 for SSH), you would do it like so: iptables -A INPUT -s 222.124.24.131 -p tcp --destination-port 22 ... http://scratchpad.farmsoftstudios.com/2008/08/linux/blocking-a-certain-ip-address-with-iptables/ Well, it certainly is not pretty yet, but my blog is now more integrated with my site than before.  I was using K2 as my theme, and I wanted it integrated more into my site's look and feel.  One step at a time as I have a few moments here ... http://scratchpad.farmsoftstudios.com/2008/08/uncategorized/change/