Select a MySQL Database on Linux via Command Line

Pre-Flight Check

  • These instructions are intended for selecting a MySQL database on Linux via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.

Continue reading “Select a MySQL Database on Linux via Command Line”

Create a MySQL Database on Linux via Command Line

Pre-Flight Check

  • These instructions are intended for creating a MySQL database on Linux via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.

Continue reading “Create a MySQL Database on Linux via Command Line”

Change a Password for MySQL on Linux via Command Line

Pre-Flight Check
  • These instructions are intended for setting the password for all MySQL users named root on Linux via the command line. However, they can also be followed to change the password for any MySQL user.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.

Continue reading “Change a Password for MySQL on Linux via Command Line”

Install Dogecoin Wallet on CentOS

Dogecoin (Ɖ) is one of the many opensource cryptocurrencies that has penetrated the post-Bitcoin marketplace. As of February 2014, Dogecoin rates fifth (5th) in market capitalization among Bitcoin, Litecoin, and all other cryptocurrencies (source). This particular coin’s name is based on the “doge” meme, a slang term for “dog”.

Dogecoin is a fork of LiteCoin (presently third in market capitalization) and is based on the scrypt cryptographic algorithm, instead of being SHA-2-based like Bitcoin. The fact that Dogecoin is scrypt-based means that you can still actually mine Dogecoin with your Graphics Card or CPU (or Liquid Web server).

Without further delay… to the moon!

Continue reading “Install Dogecoin Wallet on CentOS”

How To Install MongoDB on CentOS 6

MongoDB is a NoSQL database intended for storing large amounts of data in document-oriented storage with dynamic schemas. NoSQL refers to a database with a data model other than the tabular format used in relational databases such as MySQL, PostgreSQL, and Microsoft SQL. MongoDB features include: full index support, replication, high availability, and auto-sharding.

Pre-Flight Check
  • These instructions are intended for installing MongoDB on a single CentOS 6 node.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.

Continue reading “How To Install MongoDB on CentOS 6”

How To Install Cassandra on CentOS 6

Apache Cassandra is a NoSQL database intended for storing large amounts of data in a decentralized, highly available cluster. NoSQL refers to a database with a data model other than the tabular relations used in relational databases such as MySQL, PostgreSQL, and Microsoft SQL.

Pre-Flight Check
  • These instructions are intended for installing Cassandra 2 on a single CentOS 6 node.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.4 server, and I’ll be logged in as root.
  • You may be able to skip to Step #2 if you already have a stable version of Java 7 (preferably the Oracle/Sun JVM). Check to see if your server already has Java installed by running the following command: java -version
  • Continue reading “How To Install Cassandra on CentOS 6”