Reset MySQL Database root Password by Editing Configuration Files

Sometimes, there is a need or emergency circumstance involved an action to reset MySQL Database Server’s root account. One of those days are accidentally forgot the password of root account so that the account cannot be used normally to connect, to login or to access MySQL Database Server. And there are also many things can trigger the cause for a quick decision to reset MySQL Database Server’s password for the root account.

One way or another, this article doesn’t have any malicious intent or any bad purposes presenting method or way to reset someone else’ root account of his or her MySQL Database Server. The intention is to help fellow database administrator whom trapped in a situation explained previously. This is the detailed steps :

1. Either locally or remotely located, first of all access the server where  the MySQL Database Server is located.

Continue reading “Reset MySQL Database root Password by Editing Configuration Files”

Check MySQL Service Status

Another article for explaining on several alternatives as methods on checking MySQL service state in a host, server or workstation.

Before anything can be done for connecting or performing several operations on the database exists in MySQL Database Server, it is needed to check the status of MySQL Database Server itself.

Knowing that MySQL service is running or not, it will be an advantage to be used for so that time for troubleshooting in order to connect to the PostgreSQL Database server can be evaded.

Continue reading “Check MySQL Service Status”

Check PostgreSQL Service Status

This article will show some alternative or the way to check whether the PostgreSQL service in a host, server or workstation is actually active or not.

It is an important thing to do before any other things can be done especially connecting to PostgreSQL Database Server on the machine either locally or remotely.

By detecting whether the status of the service is actually active or not, it doesn’t take any longer just to spend and wasting time whether the connection to the PostgreSQL Database server can be initiated or not.

Continue reading “Check PostgreSQL Service Status”

PostgreSQL Database Access from Command Line in Linux

This is another article which is shown how to connect to PostgreSQL Database Server access. It can be done from an operating system runs in GUI (Graphical User Interface) easily to connect to PostgreSQL Database Server with the help of several tools such as PgAdmin among the others.

Unfortunately, the condition is not always the same especially if it is needed to connect to PostgreSQL Database Server in an operating system based on CLI (Command Line Interface). So, in order to do that it is necessary to know several steps which needed to be exercised for the purpose of connecting to PostgreSQL Database Server really can happened. These are the steps  :

1. Every request has a specific service which is activated to listen to it. So, first step is to make sure that PostgreSQL Database Server’s service is active. Check whether it is listed and what number of port which is used to listen the request by executing the following command :

cat /etc/service | grep 5432

Description : 
cat : It is a command executes to display content of a file in text and print it on standard output device such as screen, monitor. 
/etc/service : It is a configuration file used normally in major Linux operating system distribution named service located in to  map service name to the correlated port number
| : It is a sign which is a pipe sign used to redirect the output which is generated from the command before the '|' sign
5432 : It is the default port for PostgreSQL Database Server

Continue reading “PostgreSQL Database Access from Command Line in Linux”

Using wget to download a file with resume option

This article is about download file with utility or tool which can give an additional option to reconnect back or resume the file downloading process without having to redo it from the beginning.

Usually when the internet connection is not stable or even frequently disconnected, we have to redownload the file which is going to be downloaded from the very beginning. But using the right tool and the correct command parameter, it can be resumed without having to download the file from the start.

The tool which is used to do it is ‘wget’. It is a utility available as part of GNU Project. It is stands for World Wide Web and get. Below is the pattern of the download process using ‘wget’ :

wget url_of_file_which_is_going_to_be_downloaded

Description : 
wget : It is a command which is actually used to call tool to download 
url_of_file_which_is_going_to_be_dwnloaded : It is a parameter of 'wget' command which is actually in form or URL, for an example http://www.mydomain.com/data.zip

Continue reading “Using wget to download a file with resume option”

Rename MySQL table via Command Line

This is actually a simple explanation in order to rename a single table in MySQL database. There are a simple command which can be used in order to rename a single table in MySQL database. Below are several steps which is needed to be executed in order to achieve that goal. These are the steps which is needed to be followed :

1. Log in to MySQL command console.

By logging in to MySQL command console, we can further execute the command which is going to rename a single table in MySQL database. Accessing MySQL Database Server can be read in the following article. Below is the display’s execution :

Continue reading “Rename MySQL table via Command Line”

MySQL Database Access from Command Line in Linux

In this article, there are descriptions on how to connect to MySQL Database Server access. As we can see, the connection process to MySQL Database Server is actually can be done in an operating system based on GUI (Graphical User Interface) easily by using several MySQL Database Editor like MySQL Workbench, MySQL Enterprise Manager, SQLYog, Navicat or any other types of similar software, applications.

But when it comes to an operating system based on CLI (Command Line Interface), it is necessary to know several steps which is involved to be included so that the connection process to MySQL Database Server is can be achieved. Below are those process :

1. Make sure the MySQL Database Server’s service is alive. It can be done by checking the service whether it exists or not. Below is the command to achieve it :

cat /etc/service | grep 3306

Description : 
cat : It is a command which is execute to print the content of a file in text form and print it on the standard output such as monitor screen. 
/etc/service : It is a file named service which is located in /etc which is used as a configuration file for mapping service name to its corresponding port number
| : It is a sign which is a pipe sign used to redirect the output which is generated from the command before the '|' sign
3306 : It is the default number for MySQL Database Server port.

Continue reading “MySQL Database Access from Command Line in Linux”