Solved: mysql Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist

Ran into a mysql issue at work today after an unplanned power outage took the server down. The error was "Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist" everytime we tried to start mysql. Looked like the system tables were gone. The fix; We recreated the system tables in the mysql data directory using mysql_install_db. mysql_install_db –user=mysql –ldata=/mysql-data/location Restart mysql and you should be good to go.

2013-09-19 · 1 min · Danesh Manoharan

How to control your TV volume using the Astro B.yond remote control

Can you control you TV volume from your Astro B.yond remote control? I could turn on/off my TV using my Astro remote, but the volume needed a few extra steps to get working. Make sure you can turn on/off your TV from your Astro remote. Follow my guide if you can’t. Make sure your Astro decoder volume is full and your TV volume is low. Press the OK and Vol+(volume up) button together until the indicator blinks twice. Press the Vol+(volume up) button. If your volume increases the everything went well.

2013-09-18 · 1 min · Danesh Manoharan

How to control your TV with your Astro B.yond remote control

Finally configured my B.yond remote to control my TV. There are are 2 ways to configure your remote. Method 1: Hold down the tv(power) and power buttons together until the indicator blinks twice. Refer to the table below and key in the 4 digit number that represents your TV brand. If the code was valid the indicator will blink twice again. Press the tv(power) button, if your TV turns off then the code worked else repeat the steps and try another code from the table. Method 2: ...

2013-09-17 · 1 min · Danesh Manoharan

How to manually add RSS feeds to Feedly

Feedly recently removed its minibar option and it’s been a pain adding new feeds since. My work around is to use Google’s “[RSS Subscription Extension][1]” and manually add the feeds in. Install the extension. Browse to your site of choice. If the extension finds a valid RSS feed an icon will show up in your URL bar, click on it. Select the “manage” option from the dropdown and “add”. Give it a name and use the URL below. “%s” in the end represents the feed URL and is automatically understood by the extension. ...

2013-09-15 · 1 min · Danesh Manoharan

Windows 7 god mode

Today I stumbled onto Window’s secret “god mode”. Well, it’s basically a special folder containing all system settings. Create a new folder and call it “GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}”. The folder icon will change to the control panel icon if it worked. Open the folder and enjoy your new god like windows power 😀 The code: GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

2013-09-14 · 1 min · Danesh Manoharan