How To Create a New User and Grant Permissions in MySQL

About MySQL MySQL is an open-source relational database management software (RDBMS) that helps users store, organize, and later retrieve data. How to Create a New User A new user can be created within the MySQL shell, using the following statement: CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; This will create a new user named ‘newuser’ without […]

Read More →

Install PostgreSQL in XAMPP on Windows and integrate phpPgAdmin

Installing postgreSQL Download the postgreSQL installer from EnterpriseDB. Download the postgreSQL 9.2 as you might face frequent logout issue. Run the installer and follow the on-screen instruction. Assuming XAMPP is located in C:\xampp; using the pgSQL installer, install postgreSQL in say C:\xampp\pgsql\9.2 folder. You may skip the Stack Builder section. You will be prompted to set a […]

Read More →

Start a new git repository

Your first instinct, when you start to do something new, should be git init. You’re starting to write a new paper, you’re writing a bit of code to do a computer simulation, you’re mucking around with some new data … anything: think git init. A new repo from scratch Say you’ve just got some data […]

Read More →

Removing blank lines in Dreamweaver

adobe-dreamweaver

Adobe Dreamweaver is a popular web development tool. Here’s a helpful tip to remove blank lines from an html file using Dreamweaver. No need to remove lines manually.   Press CTRL + F. Select “Current document” in “Find in”. Select “Source code” in “Search”. Tick “Use regular expression”. Type “[\r\n]{2,}” in “Find” (without quotes). Type […]

Read More →

Installing Subversion on CentOS

Subversion is a open source version control system (VCS) that makes developevers easier to manage files and directories, and the changes made to them, over time. This allows one to recover older versions of the data or examine the history of how the data changed. It also helps software developers to work together maintaining complete […]

Read More →

Initial Server Setup with CentOS

Some of the steps to make a server more secure, when you first access your virtual private server. Some of them are setting up a new user, providing them with the proper privileges, and configuring SSH. It is not encouraged to use root on a regular basis, and you should set up an alternative user […]

Read More →

How To Install Varnish To Run With Apache On CentOS

How to install Varnish on CentOS Step 1 – Install the latest version of Varnish on CentOS using the following command: 1 sudo yum install varnish How to Configure Varnish to work with Apache Step 1 – Now setup the basic configuration to make Varnish work with Apache. In CentOS and Fedora, Varnish configuration file is located in “/etc/sysconfig/varnish”. […]

Read More →