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…
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…
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 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…
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…
Easily create or drop a database via the psql CLI using the below syntax. Create a PostgreSQL Database: Just modify the database_name to the name you prefer for your new database. bash create database database_name
If you are having issues dropping a postgres database the issue is more than likely that a user is accessing the database you are attempting to drop. There isn’t technically a way to force drop the postgres database however there are steps you can take to prevent others from accessing the database and if needed…
Creating multiple cacti graphs using the same script is really easy. It took me a minute to realize it but if your script input values then you can just click the “Create Graph” drop down and create multiple of any graph you have configured. See the two images below that show how to do this…