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 access your databases from a different host.
GRANT ALL ON *.* TO 'testuser'@'remote.farmsoftstudios.com' IDENTIFIED BY 'pass1';
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)
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.
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/
