grokman

MySQL Collation & Case Sensitivity or Insensitivity

When using MySQL (or most any DB really), it’s a good idea to understand about collation: the implications, the defaults, and how to change it. Collation determines how data is sorted and compared in the database. Its essentially a set of rules for the DB to follow when making decisions on said sort and comparison. …

MySQL Collation & Case Sensitivity or Insensitivity Read More »

MySQL List Users Command – How to Show / List All Users in MySQL / MariaDB

In order to list all the configured DB users in a MySQL or MariaDB, you must be logged in as an administrator: /home/grokman grokman@li598-26% sudo mysql -u root -p Then you can issue the command to list all the DB users: select user, Super_priv from mysql.user; So, it should go something like this: Other user …

MySQL List Users Command – How to Show / List All Users in MySQL / MariaDB Read More »

Check Engine Light Troubleshooting: Honda Element DTC P0498 P0135

Description Troubleshooting a check engine light on a 2007 Honda Element. The diagnostic trouble codes (DTCs) are pulled with a Bluetooth OBD2 scanner and app, and then an in-depth diagnostic process to track down the root cause is demonstrated. P0498 and P0135 codes appeared at the same time and are shown to ultimately be false …

Check Engine Light Troubleshooting: Honda Element DTC P0498 P0135 Read More »

How to Download & Install Git on Windows 10

  Description A tutorial and how-to demonstration of a download and installation of Git on Windows 10 64 bit. All install options are discussed in some detail in a step-by step fashion. The Bash shell, MinTTY, and MinGW 64 bit are briefly discussed & the configuration / install options are considered.  This particular Git version …

How to Download & Install Git on Windows 10 Read More »