Setup & Basics of MySQL

Download MySQL: Go to mysql.com, click on "Developer Zone" then click on "MySQL Downloads", then click on "MySQL Community Server" .. or go to https://dev.mysql.com/downloads/mysql/ Click on "Go to Download Page" Select the one labeled Web, for online, or the one without Web in the name for offline installation, ex: mysql-installer-web-community-8.0.17.0.msi You might have to … Continue reading Setup & Basics of MySQL

Advertisements

How to Turn a Photo into a Typeable Font Character

Here's How I took the Image Above and turned it into the typed Characters you see embedded in the Font Below it I started out by changing the Original Image to a 3-color Image Then I Created A duplicate Image, and on the first Image, I Changed the lightest 2 colors to white, and on … Continue reading How to Turn a Photo into a Typeable Font Character

Editing & Posting to your Instagram Accounts from your Desktop

Download & Install BlueStacks Sign in with the Gmail account for your IG Account, don't use your primary Gmail, and don't enter your primary Password. BlueStacks doesn't accept the App Password Codes from Gmail, requiring instead that you enter your complete email password into the app, which is definitely a bad idea You can make … Continue reading Editing & Posting to your Instagram Accounts from your Desktop

Getting rid of Perpetual Viruses in System Volume Information in System Restore

Go to Start>Run and type msconfig. Press enter. When msconfig opens, click the Launch System Restore Button. On the next page, click the System Restore Settings link on the left. Check the box labelled 'Turn off System restore'. Reboot. Go back in and Turn System Restore Back on. A new Restore Point will be created. … Continue reading Getting rid of Perpetual Viruses in System Volume Information in System Restore

Output a List of Folder Contents to a Text File in Windows

From Command Prompt Change the Drive - "F:" Set the directory - "cd " Paste Folder Directory you want to Export the list from, as follows: (the two steps above can be done in reverse order to get the same result) cd F:\"Kalani's Folder\Kalani's Stuff"\ContentsList.txt Use " " around Directory after pasting location from Explorer … Continue reading Output a List of Folder Contents to a Text File in Windows

CMD Syntax & Customization

Enable/Disable Command Extensions for Command Prompt Regedit : Hive: HKEY_CURRENT_USER Key: Software\Microsoft\Command Processor Name: EnableExtensions Type: REG_DWORD Value: 1 enable Value: 0 disable Turn on Quick Edit Right-click the CMD Window Title Bar Select "Properties" Select "Quick Edit Mode" Copy by Highlighting & hitting Enter Paste by right-clicking You can also change the background colors, … Continue reading CMD Syntax & Customization

Converting Text Files From One Encoding or Operating System to Another

Unicode UTF-8 or UTF-16 to ASCII on various platforms LF = Line Feed CR = Carriage Return (FTP will change formats automatically in ASCII mode, but not in binary mode) To convert a Microsoft Windows file to Linux or a classic Macintosh file you subtract. To convert a Linux or a classic Macintosh file to … Continue reading Converting Text Files From One Encoding or Operating System to Another

Adding Control Panel, System Tools, Administrative Tools, & More to Quick Launch

A follow up to my blog about making an Expandable and Categorized Quick Launch, Here's how to add Control Panel, Admin Tools and System Tools Adding Control Panel to Quick Launch: Open My Computer Double-Click on Control Panel Select all Right-Click, select "Create Shortcut" Click "Yes" to place them on the desktop Ctrl+Click all the … Continue reading Adding Control Panel, System Tools, Administrative Tools, & More to Quick Launch

A-Z Index of the Windows CMD command line & Syntax Reference

Syntax Reference Found Here: Syntax Reference add " /?" after each for a list of optional Parameters with syntax type Drive after command followed by Parameter. Ex. sfc /scannow chkdsk c: /r Change to Drive by hitting c: Change root directory via cd then type or paste a directory use " " around paths with … Continue reading A-Z Index of the Windows CMD command line & Syntax Reference

Clearing WPFFontCache in case some menus arent working, etc in Windows

Start > Control Panel > Administrative Tools > Services (or type "services.msc" from the run command box). Stop the "Windows Presentation Foundation Font Cache 3.0.0.0 or 4.0.0.0" service. Delete the cache file: "FontCache3.0.0.0.dat from: WinXP: "C:\Documents and Settings\USER\LocalService\Local Settings\Application Data" Vista/Win7: "C:\Windows\ServiceProfiles\LocalService\AppData\Local" Restart the service, or the machine if needed

No IP Address – RPC Service Not Started – Repair Winsocks – Reinstall TCP/IP in Windows

Step 1: Click Start, and then click Run. In the Open box, type "Cmd" then "Services.msc", and Start all of the RPC, DNS, & DHCP Items and Enable them to Start Automatically - Restart if Changes are made Step 2: Click Start, and then click Run. In the Open box, type "Cmd" then "netsh winsock … Continue reading No IP Address – RPC Service Not Started – Repair Winsocks – Reinstall TCP/IP in Windows

Classic Shell

Classic Shell makes your Windows Vista/7/8/10 work with a very customizable classic start menu that is very powerful and has limitless possibilities. I've imported quite a few of my web tutorial on it here to my blog, as a preventative measure, you can find them in the Classic Shell Category You can download it here: … Continue reading Classic Shell

Pinning a Drive to Start Menu in Windows 7

To Enable: Create a New Text Document & open it Paste the Following Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Folder\ShellEx\ContextMenuHandlers\{a2a9545d-a0c2-42b4-9708-a0b2badd77c8}] @="" Save & Rename it: EnableDrivePin.reg (with "hide extension for known file types" disabled in Tools > Folder Options > View) Double-click to run it Go to a drive you cant normally pin to the start … Continue reading Pinning a Drive to Start Menu in Windows 7

Useful Windows Mods & Apps

QTTabsbar Compatibility: Win XP through Win 10 Price: Freeware Link: http://qttabbar.wikidot.com Description: QTTabs bars primary function is to add tabs to windows explorer, making it easier to manage sessions with multiple tabs. QTTabs bar also has a variety of other customization features. In addition to the default settings, I set the following on these tabs: Tab New Tab Location … Continue reading Useful Windows Mods & Apps

How to Create your own Custom Icons & .ICO Files

To Make your own Custom Icons:  - You can use a graphics program like GIMP or Photoshop to create your graphic PNG file You can also import an existing Icon for editing, as such: Extract the Icon from the DLL or EXE file first,as described here: http://classicshell.net/forum/viewtopic.php?f=5&t=302 Then import it to your graphics program and edit … Continue reading How to Create your own Custom Icons & .ICO Files

Replace “Programs” with “Program Launcher” in your Start Menu

. This one is more of a 'fix' until we can get multiple columns displayed for pinned items, and/or linking to multiple folders** _______________________________________________________ Step 1 - Create the Folder: Right-Click Start Orb & select "Settings" Click "All Settings" and go to the "Customize Start Menu" tab In the Right Column, scroll down & double-click … Continue reading Replace “Programs” with “Program Launcher” in your Start Menu

Add “Shutdown Timer” menu Item to your Start Menu – Classic Shell

Here is how to created the above Shutdown Timer Menu for the Classic Shell Start Menu: (I do this mostly because I like to listen to music as I leave the house or fall asleep..) **UPDATED to include an implementation of Shellexecute.exe, added to create Method 1.. Method 2 is without ShellExecute.exe, and linking to … Continue reading Add “Shutdown Timer” menu Item to your Start Menu – Classic Shell

Icon Harvesting from your Computer, for Menu Customization

Most of the Common System Icons are found in the following 2 .DLL files: C:\Windows\System32\imageres.dll C:\Windows\System32\shell32.dll Here's how to get all of the Icons from your computer into one folder, to help you in customizing Classic Shell & Classic Explorer: Download Resources Extract, from Nirsoft here: Resources Extract Run the File Where it says "Filename/Wildcard" put … Continue reading Icon Harvesting from your Computer, for Menu Customization

Add .RTF to ‘New’ Context Menu in Windows 7/10

Be Logged in as an Administrator Open a file explorer window & type %SystemRoot% & hit enter (or browse to C:/Windows) Create a New Folder named: ShellNew Open Wordpad.exe  - in Start Menu>All Programs>Accessories, or Run > Wordpad Hit Save & Save the Blank Document to your Desktop as "Document.rtf" Copy that Document.rtf and paste … Continue reading Add .RTF to ‘New’ Context Menu in Windows 7/10

Deleting Trusted, Untrusted, or Fraudulent Certificates in Win7

Some programs install "Trusted" certificates on your computer that work inside Office applications, etc, that are malicious, and cannot be removed from within the program itself. To delete unwanted Fraudulent or Unwanted Certificates: Hit Start, and click in the search box Type "certmgr.msc" and hit Enter Browse to the category you want, like "trusted", "untrusted" … Continue reading Deleting Trusted, Untrusted, or Fraudulent Certificates in Win7

Cannot Open PDF in Adobe Acrobat – “The File is Damaged and Could Not Be Repaired”

Quick Solution if you need to copy & select Text:Open the PDF with the free SumatraPDF, and Copy and Paste Content from SumatraPDF as needed. Emergency Save of Multi-Language Text:Open the PDF in SumatraPDF, hit Ctrl+A > Ctrl+C > Open MS Word > Ctrl+P > Let Process > Ctrl + S Quick Solution if you … Continue reading Cannot Open PDF in Adobe Acrobat – “The File is Damaged and Could Not Be Repaired”