In this article, we will see how to change MySQL root password in Linux. We can change the password with multiple methods, below are the few of them.
1. Update root user password using SET method:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD("admin@123"); flush privileges;
In this article, we will see how to Install pgAdmin4 on Ubuntu.
What is pgAdmin?
pgAdmin is the leading Open Source management tool for Postgres, the world’s most advanced Open Source database.
Steps to Install pgAdmin4 on Ubuntu:
1. Run the command
sudo apt-get install pgadmin4 pgadmin4-apache2
This article covers how to start, stop and restart PostgreSQL on Ubuntu. This is PostgreSQL DBA routine task.
We are going to cover stop, start and restart using service and systemctl commands. But, not covering to kill the PostgreSQL process from Linux shell.
Stop Start and Restart PostgreSQL using service:
sudo service postgresql stop sudo service postgresql start sudo service postgresql restart
Examples for How to start stop PostgreSQL on Ubuntu:
Continue reading How to start stop PostgreSQL on Ubuntu
In this article, we are going to install PostgreSQL 11 on Ubuntu 19.04 Linux server.
Step1: Add PostgreSQL Repository:
So you need to add PostgreSQL apt repository to your system suggested on official PostgreSQL website using following commands.
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
I have faced the issue when connecting to CentOS Server or Ubuntu Server using putty thrown error “PuTTY Fatal Error:Network error: Connection timed out” on Ubuntu and CentOS which are virtual machines installed on VMWare.
Solution PuTTY Fatal Error Network error: Connection timed out on Ubuntu:
Continue reading PuTTY Fatal Error Network error: Connection timed out
In this article, we have explained how to install MySQL on Ubuntu Server. This article contains 4 steps.
Install MySQL on Ubuntu:
Prerequisites:
1. Must have internet conneciton.
2. Make sure you are logged in as a user with sudo privileges
1. Update Index Package:
sudo apt-get update