To create a user and grant all permission to him:
mysql -u rootCREATE USER 'username'@'localhost' IDENTIFIED BY 'password';GRANT ALL PRIVILEGES ON * . * TO 'username'@'localhost';Foo, sometimes, when you are on terminal, its soo lazy to open google chrome from the dock, I just wrote a foolish script that does it:
1 2 3 4 5 6 7 8 9 10 |
#!/bin/bash
args=("$@")
all_terms=${args[0]}
i=1
while [ $i -lt ${#args[@]} ]
do
all_terms=$all_terms+${args[i]}
i=$[$i+1]
done
google-chrome http://www.google.co.uk/#q=$all_terms
|
Well, just copy the above script in a file, chmod +x it, all it as an alias using may be “google” as alias name to your .bashrc and source .bashrc and have fun 
On Openshift PAAS Python, to be able to get data from the Data directory:
file = os.path.join(os.environ["OPENSHIFT_DATA_DIR"],"smallTree.xml")
This is how you can retrive the file from the “data” directory
Sometimes, we have a String which we just want to serialize as an XML element, so to convert it to XML:
1 2 3 4 |
DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder dBuilder = dBuilder.parse(fXmlFile);
Document actualElementXMLResult = dBuilder.parse
(new InputSource(new StringReader("<YourXMLElement>YourXMLElementGoesHere</YourXMLElement>")));
|
I just had a discussion with a friend, always saying that he forgets his password, but today we don’t have to remember our password. We have tools, very good and free that allows us to do easily remember our password and login. I think for mobile, I think you do have a free trail but for Desktop, the usage it free. Some times ago, I was in the same situation, always trying to remember my password. Then, once I saw Avinash using a very nice tool for password management which was LastPass. From then I used it, and its brilliant, Great 
. In Summo, this is what LastPass does, well, from what my usage, thats what I know:
So, why do we need to remember our password when LastPass can do it, it remembers and even enters it for us, well, why do we even pretend to be able to remember our password, sometimes when I see people trying to computer huge calculation by the head, you see its fine, well at least sometimes surprising to see, but why do we need to do things when machines can do them, Wherever we can we automate
I know, Git is great and so is Github, fortunately or unfortunately, for private projects, we have to pay. Well, Github has cost and it needs to run and by coincidence money is needed, so it can’t help. No worries, open source is here, there are number of alternatives out there that can help you to host your own Github-like System. Here are some of them:
In case you know some more alternatives, just drop down a comment, I’ll add them to the list
DBpedia is really fun, the whole of Wikipedia as an ontology, added it is the DBpedia SPARQL endpoint. Here are some examples I went through while learning. Resources lacks so you to make your way though forums specially Stackoverflow, thats how I did it 
Check if a resource exist on Wikipedia
1 2 3 4 |
SELECT DISTINCT * WHERE {
?x <http://dbpedia.org/ontology/country> ?y .
?x rdf:type $z
}
|
Getting the relationship between London and UK
1 2 3 4 |
SELECT ?property
WHERE {
:London ?property :United_Kingdom
}
|
Get Country & Cities
1 2 3 4 5 |
SELECT DISTINCT ?city ?country
WHERE { ?city rdf:type dbpedia-owl:City ;
rdfs:label ?label ;
dbpedia-owl:country ?country
}
|
Getting the type of a subject and a value that can relate themselves between a predicate country
1 2 3 4 5 |
SELECT DISTINCT ?w,?z WHERE {
?x <http://dbpedia.org/ontology/country> ?y .
?x rdf:type ?z .
?x rdf:type ?w
}
|
Getting the name of type of a resource with name Mauritius
1 2 3 4 5 |
SELECT DISTINCT ?label WHERE {
:Mauritius rdf:type ?type .
?type rdfs:label ?label .
FILTER (LANG(?label)='en')
}
|
=============================================
Getting all things of type kingdom
1 2 3 4 5 |
PREFIX wo:<http://purl.org/ontology/wo/>
SELECT DISTINCT *
WHERE {
?subject rdf:type wo:Kingdom
}
|
As I have fun with SPARQL, I’m going to update this page
Ok, I’m currently in a shiit, I’m having to backup my stuffs on my servers and this I need to do it quite frequently. So the issue is:
-Automatically backup frequently(check cron jobs if you want to know)
-Naming Convention to timestamp the folder
So, how do I recognise when a file has been copied? We timestamp the folder using a naming convention say dd.mm.yy.hh.mm.ss(day.month.year.hour.minute.second). We use scp to copy the folder to my server, ensure that your public and private keys are setup so that you can automate it. The key here is the naming convention.
scp -r /path/to/folder server@username.com:/path/to/folder/$(date +\%d.\%m.\%y.\%H.\%M.\%S)
Ok, if you really want to automate the whole stuff:
I was just wandering around to look for some git graphical tools when i came a post on Stackoverflow(See below for the links). That post list some nice graphical tool(showing all branches, commit, tags, merging), I tried creating a somewhat similar project to that shown in the post just to test all that tool, here that are:
This is gitx which i think is only for Mac OSX
I posted this post on LinkedIn and I was pointed towards a very nice tool, SmartGit. I downloaded it and tried it with this scenario, thats the result
On bare git with the command git log --graph --full-history --all --color --pretty=format:"%x1b[31m%h%x09%x1b[32m%d%x1b[0m%x20%s"
info from Stackoverflow:
1. http://stackoverflow.com/questions/3509776/which-git-tool-generated-this-tree-view
2. http://stackoverflow.com/questions/1838873/visualizing-branch-topology-in-git