Technology Insights

Create MySQL User With mysqladmin

When setting up a server or group of servers for the first time you may find yourself wanting to create MySQL users without having to login to MySQL. It would make sense for the mysqladmin command to offer this functionality but it does not. Instead you can create the MySQL user with the mysql command as shown in the below example performed on a server running Ubuntu Linux 12.04  also known as Precise Pangolin.

Technology Insights

Create Zen Cart MySQL Database And MySQL User

I always forget specific MySQL syntax including creating a MySQL user and granting that user specific access only via localhost to a specific database. So when I install Zen Cart I always end up looking how to do this via the MySQL documentation. Below are simple instructions on how to create a MySQL database using mysqladmin, create a MySQL user, and grant permission to the created database to the created MySQL user.

Technology Insights

Generate A GPG Key To Sign RPM Packages Created Using rpmbuild On CentOS Linux

I have been playing around with building RPM packages today on CentOS because I needed to upgrade curl and the latest version available on CentOS didn’t have the features I needed to use. One of the things that had come h up during the RPM build process and the RPM package installation process using yum was the fact that your RPM packages should be signed. Signing RPM packages gives them some validity and will allow others to install them without having to modify their yum.conf file. Below I describe how to generate a GPG key to be used to sign RPM packages created using the rpmbuild command. First below is a message that will be received when attempting to install unsigned packages using yum with the default yum configuration.

Technology Insights

Create a SVN Repository, Then Import a SVN Repo Into The New SVN Repo

The below describes creating a SVN repository from a CentOS Linux shell followed by importing a SVN repository dump into the newly created repository. This can be useful for many reasons including moving servers or even just moving the location of an SVN repo.

If you don’t have subversion installed go ahead and do so now. The below command can be issued from the shell of a CentOS Linux server using yum to install subversion.

Technology Insights

SQLite3 GUI For Windows XP, Install SQLite On Windows

I was attempting to view the contents of what I thought was a SQLite3 database file so I needed a GUI of some sort to do so. Anyhow first I decided to install SQLite. Once I did this and created a test database to make sure to SQLite GUI was working I finally decided the file I was trying to open was not a SQLite3 database file.

Install/Run SQLite: