Articles, commentary, and related writing filed under this topic.
Want to know when something new is published about terminal ? Enter your email address below and choose how often you would like to be notified.
We will send you a confirmation email. Your subscription does not become active until you confirm it.
If you are getting ready to set up a new server to host websites, you will inevitably run into the classic debate: Nginx or Apache? Both are incredible pieces of open-source software that power the vast majority of the internet, but they take very differe
Read More
If you use Linux for web development, programming, or server administration, you may be wondering whether OpenAI's Codex can work directly from your Linux terminal. The answer is yes.
Read More
If you are using OpenClaude for agentic terminal coding, connecting it to premium cloud APIs like Anthropic or OpenAI can quickly rack up token costs. Even worse, misconfigured API keys or unsupported models often throw frustrating 400 Bad Request errors.
Read More
Codex is more than a code generator—it is a hands-on development assistant that works directly within your project files. This guide provides a complete, practical reference for installing Codex, navigating your local environment, and using it ef
Read More
Whether you want to protect a private image, file, video, this is the best and easiest way to do it! Hands down, check it out!
Read More
Learn to craft a seamless login and logout experience with PHP, MySQL, and Bootstrap. From setting up your server to implementing session security, this tutorial will guide you through every step to create a user-friendly and secure authentication system.
Read More
This is advanced programming lesson 2. WOW this is diving deep into the world of programming with PHP, Bootstrap, AJAX, MYSQL and more. Remember that you can always comment on these posts if you need me to clarify anything. I look forward to hearing from
Read More
Advanced programming tutorials in PHP. Set up the server and install your VS Code and get ready for the ride. Learn to develop applications. In this series you will learn how to assemble several different programming techniques to create advanced applicat
Read More
Are you ready to dive into the world of video editing? Olive Video Editor is your gateway to creating stunning visuals with its user-friendly interface and powerful features. Whether you're a beginner or a seasoned pro, this open-source editor offers ever
Read More
This tutorial will show how to go from cPanel to ISPConfig. The best part about ISPConfig is that it's free, while cPanel charges.
Read More
There are times when you might have a database connection error. If you are on the Ubuntu system on Amazon hosting then run this command. sudo service mysql or try this sudo /etc/init.d/mysql start
Read More
In order to access your the mysql part in your terminal you will enter something like this. Access monitor: mysql -u [username] -p; (will prompt for password)
Read More
In order to show all databases in your terminal enter the following code. show databases;
Read More
If you're a developer working with databases, you're probably familiar with MySQL - an open-source relational database management system. While there are many ways to access a MySQL database, one of the most straightforward methods is through the MySQL te
Read More
If you want to create a new database in terminal enter the following command. create database [database];
Read More
You can select a database to work with by entering the following command in terminal. use [database];
Read More
If you want to know what database that you are in you can use this terminal command. select database();
Read More
If you want to see the tables in the database use this command. show tables;
Read More
To show the table structure in terminal use this code. describe [table];
Read More
To see all indexes on a table enter this code. show index from [table];
Read More
To create a new table with columns use this command. CREATE TABLE [table] ([column] VARCHAR(120), [another-column] DATETIME);
Read More
If you're working with a MySQL database, you may find that you need to add a new column to a table. Fortunately, adding a column to a MySQL table is a straightforward process that we will do using the MySQL terminal command. Here's how:
Read More
To insert a record use this command in terminal. Customize the values. INSERT INTO [table] ([column], [column]) VALUES ('[value]', [value]');
Read More
For date time input use this function. NOW()
Read More
To select record in terminal for mysql use this command. Change the value of table and take out the brackets. SELECT * FROM [table];
Read More
To explain records use this command. Take out brackets and replace table with your table name. EXPLAIN SELECT * FROM [table];
Read More
To export a database use this command in terminal. mysqldump -u [username] -p [database] > db_backup.sql If that does not work for you then you may have created a user in cPanel or some other website management application. You may have to use the --no-ta
Read More
To import a database dump use this command. mysql -u [username] -p -h localhost [database] < db_backup.sql
Read More
To select parts of records use this command. SELECT [column], [another-column] FROM [table];
Read More
To count records enter this command. Take out square brackets and replace names accordingly. SELECT COUNT([column]) FROM [table];
Read More
To count and select group records in terminal use this command. SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column];
Read More
To select specific records in terminal use this code. SELECT * FROM [table] WHERE [column] = [value];
Read More
To find records containing something use this command. SELECT * FROM [table] WHERE [column] LIKE '%[value]%';
Read More
To find something that starts with a certain string use this code. SELECT * FROM [table] WHERE [column] LIKE '[value]%';
Read More
To find records that start and end with a certain value use this command. SELECT * FROM [table] WHERE [column] LIKE '[val_ue]';
Read More
To select a range use this code. Take out the brackets and replace the values. SELECT * FROM [table] WHERE [column] BETWEEN [value1] and [value2];
Read More
To select with a customer order and limit the results use this command. SELECT * FROM [table] WHERE [column] ORDER BY [column] ASC LIMIT [value];
Read More
To update a record you can use this command. UPDATE [table] SET [column] = '[updated-value]' WHERE [column] = [value];
Read More
To delete records in mysql use this terminal command. DELETE FROM [table] WHERE [column] = [value];
Read More
For Custom Column Output Names Terminal MySQL, when selecting data from a table using the SELECT statement, you can customize the output column names. This can be useful when the column names in the table are not descriptive enough or when you want to for
Read More
Installing fonts on Ubuntu is a lot easier than installing it on other Operating Systems. I personally prefer importing all the fonts into a hidden fonts folder to save time. If you have any issues please be sure to comment below.
Read More
In this tutorial, I will show you how to install Linux Mint and create a bootable flash drive. You can do this install a couple different ways, but I recommend backing up your current computer either way. Recently I created a tutorial on how to back up yo
Read More
To synchronize Google Drive with Linux Mint, follow the steps below. This is a straightforward task and even if you're technically challenged, as some say, you will get through this with no problems. I did not leave out any steps, and I created this so th
Read More
There are times when you need to find the largest files in your Linux Terminal. Here are a list of commands that you can use to find out what is bloating your website. Remember that every web page that you have should not load any more than 2 MB maximum.
Read More
One of the most important things that you can do is back up your website. There are 2 different kinds of backups for WordPress. We will discuss the easy way then the more thorough way through your cPanel.
Read More
I have spoke about clearing your browser cache in previous articles but if you are still having problems seeing changes on your website there is one more thing that you may want to try if things are still quirky. That would be flushing the DNS cache on yo
Read More
If you are just getting started with Amazon web hosting services you may feel lost. First of all make sure that Amazon web hosting services are right for you. You must understand the following.
Read More
In this tutorial we will Install Server PHP MySql Amazon Web Hosting via SSH.
Read More
You will have to Edit Files in SSH Terminal, Amazon EC2 Hosting. This tutorial will demonstrate how to edit files in the SSH terminal of Amazon EC2 hosting.
Read More
This tutorial will show you how to install WordPress and database on Amazon web hosting services. This can be challenging but I have a present for you. A terminal cheat sheet.
Read More
This is a tutorial on how to enable pretty permalinks in Amazon Web Hosting services. In order to do this you have to enable mod_rewrite in your Apache server. Otherwise you will get a page not found error.
Read More
We use ubuntu servers because they are are awesome to work with. There are however some technical things that you may run into when installing a WordPress CMS on an Ubuntu server.
Read More
If you are like me you like to use the terminal commands to update your linux Ubuntu System. Its fast and easy if you know the command. I am putting the command lines in this article so you can copy and paste them. First login as root then navigate to you
Read More
This is a beginner lesson about terminal commands in a Mac. To get familiar please watch the video below. You too can practice the terminal commands on this page with your own Mac. Remember if you are having trouble you can always schedule a one on one wi
Read More
What Your Will Learn Here How to get a list of scripts that are emailing on your server. Get the IP address of the spammer Block the IP address
Read More
This tutorial will show you how to use a form to upload a file with PHP. As discussed in a previous tutorial about HTML5 forms you need to have a form tag that starts and stop everything within your form.
Read More
If you are getting the message. "Your Theme Does Not Declare WooCommerce Support" please follow the instructions below.
Read More
In this how to tutorial I will show you how to move a large WordPress website from one server to another. In this tutorial I assume that you already know how to SSH into your server. You must already know these following things, if you do not, click the l
Read More
Would it not be nice to manage Gmail on Ubuntu? Let's be honest, we all want to manage our email quickly. In Evolution, there is a multiple email account solution because emails should be easy, right? The Evolution email program will sync with all of your
Read More
Install GIMP 2.10 update with these simple instructions. This is for Ubuntu Operating System but you can use this Graphic Manipulation software on Mac and Windows as well.
Read More
This article will help you install WordPress with Shell access ( ssh ) using the wget command in a Linux/Ubuntu terminal.
Read More
Repeat process to download more videos from your YouTube account Saving a backup is important especially if you need to delete a video from YouTube and don't want to lose your content. If you need to learn how to delete a video from YouTube CLICK HERE to
Read More
In this day and age there is always some threat to your server environment. There is always some wise guy coming up with a hack or virus to ruin your server. In this article I am going to show you some commands that you can use to safeguard your server fr
Read More
Most effective and easiest way of backing up your website is in terminal. The process that I am about to show you is very easy. It may look like it is past your capabilities but it is not.
Read More
Use this command to release a single email message from on hold: postsuper -H 070788B31
Read More
Postfix is a popular open-source mail transfer agent that we use for routing and delivering email messages. It is a powerful tool that allows you to configure and manage email servers on Linux and Unix systems. However, working with Postfix requires famil
Read More