Archive for the ‘Tutorials’ Category
2008
12.13
Tags: bug reports, gecko, google, hotmail, khtml, problem solution, safari, target, version, windows
Posted in Software, Tutorials | 5 Comments »
UPDATE: The fix will cause inability to read mails.
I couldn’t let go of Google Chrome, so I checked bug reports and I found a temporary fix to the problem. For my future reference until Chrome devs fix the issue, here’s what needs to be done:
- Right Click on the Google Chrome shortcut (Desktop or whereever you place it).
- Left Click on Properties.
- On the Target box, add the following line at the end:
--user-agent="Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Version/3.1 Safari/525.19"
Therefore, if you are running Chrome in Windows, your target should look like:
C:\path\to\chrome.exe --user-agent="Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Version/3.1 Safari/525.19"
Close all instances of Chrome and open the browser again using the shorcut prepared above.
2008
12.10
Tags: annoying pop malware removal, anti virus, clean registry, computer, downloads, google, hijackthis, internet usage, malwares, netizen, safe mode, smitfraudfix, Software
Posted in Software, Tutorials | 5 Comments »
Since my thought (for an entry) escaped me, I’ll post a simple malware removal tutorial.
A few years ago, we called them annoying pop-ups and now we call them MALWARE. Virus is no longer trendy because it does not rake in revenue; malware does because it mostly contains advertising.
If you are a careless netizen and clicking on any pop-up that may appear in front of you, then you are the best malware victim. IT administrators should block all sites except for the ones that the company would need if their users do not abide by the usage policy. In the office, we are too scared to even use Google because internet usage is strictly prohibited unless needed and we can’t hardly slack because there’s too much work to be done.
One night I was victimized by a malware in my home PC. The site I used to frequent had a hidden malware injector through PDF. I’ve been removing malwares for others, so I’ll share the secret with everyone.
- Download Hijackthis & SmitFraudFix (Google them)
- Install Hijackthis.
- Add an exception in your AntiVirus (add both softwares above).
- Run Hijackthis & fix processes you don’t recognize.
- Restart your computer in Safe Mode.
- Run SmitFraudFix (option 2) and clean registry when prompted.
- Restart your computer in Normal Mode.
- Done!
2008
10.28
Tags: alice, Eee PC, localhost, privilege
Posted in Commands | No Comments »
To create a database and give a user privilege to that database:
mysql> CREATE DATABASE temp;
mysql> GRANT ALL PRIVILEGES ON temp.* TO 'bob'@'EEEPC'
-> IDENTIFIED BY 'alice'
-> WITH GRANT OPTION;
The privilege is full for Bob for all tables contained in the database called temp. Here, I explicitly defined the user’s host. That means Bob can only access the server if he used my Eee-PC. Even local access for Bob is not allowed because I did not add ‘bob’@'localhost’ in the GRANT command.
2008
10.28
Tags: spreadsheet
Posted in Tutorials | No Comments »
Given a cell Name containing two (2) words: First Name & Last Name in the format FIRST[:space:]LAST. We need to create a cell for the first name & another cell for the last name. If we are given hundreds of rows of names, a quicker way should be found. With the use of formula, we can easily extract the names in 2 minutes.
Let’s say that the FULLNAME is in ColumnA, we need to fill ColumnB=FirstName & ColumnC=LastName:
B1 = LEFT( TRIM(A1), FIND( " ", TRIM(A1) ) - 1)
C1 = RIGHT( A1, LEN(A1) - LEN(B1) - 1 )
2008
10.28
Tags: cli, execution, gui client, guis, queries, script, script file, source path, sql script
Posted in Commands | No Comments »
Given you have no GUI client for MySQL, executing multiple CREATE/INSERT/UPDATE queries using the CLI would be troublesome. So preparing a valid SQL script file is advisable. This command also works for dump files run for recovery or duplication.
mysql> source /path/to/source.sql;
2008
10.24
Posted in Commands, Tutorials | No Comments »
To log command executions & results from MySQL CLI to an output file:
mysql > \T output.txt
mysql > DESCRIBE table;
mysql > \t
2008
08.20
Tags: access, actiontec modem, amount of traffic, bit client, bridge, continuation, dgl, downloads, excellent service, fios, gamers, internet access, KDrama, longing, modem, network, router, routing table, service areas, signs, throughput, torrent, traffic, verizon
Posted in Hardware, Tutorials | 1 Comment »
I have had Verizon FiOS for more than a year now and as the service areas continue to grow, with the technology’s excellent service, I’m sure a lot have signed up for it. If Verizon provides you with an Actiontec modem/router then let me advice you to purchase another router because Actiontec will drive you crazy in the long run. I have 10mbps/3mbps down/up throughput and I download a lot as in I average 1GB/day (that’s a modest number). They aren’t illegal downloads per sé because they are distributed openly (KDrama). If I have more than 3 huge files in my μTorrent (or any other bittorrent client), others in my network wouldn’t have Internet access. That’s because I have NAT running and the routing table in Actiontec is not enough to handle huge amount of traffic. Therefore, overloaded packets are dropped giving my users nil resource. (more…)