Tag: Linux

How to check MySQL Server startup time and uptime

In this article, we will see how to check MySQL Server startup time and uptime.

Uptime is the time between current and MySQL start time.
Startup time is time exact time(date with seconds) of MySQL server started.

1. Check the MySQL Server Startup time:
We can get it from MySQL shell, Linux shell and MySQL workbench
Continue reading How to check MySQL Server startup time and uptime

How to install MySQL 8 on Kali Linux

In this article, we will see how to install MySQL 8 on Kali Linux.

We’ll use the available MySQL APT repository to install MySQL 8.0 on Kali Linux. Ensure this repository is added to our system by running the commands below.

sudo apt update
sudo apt install -y wget
wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb

Continue reading How to install MySQL 8 on Kali Linux

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

In this article, we will see the solution for below error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

ERROR 2002 HY000 Cant connect to local MySQL server through socket varrunmysqldysqld.sock 2

Reasons:

1. MySQL is not started.
2. MySQL not installed on your machine.

Solution:

1. Lets verify the status of mysql server whether it is started or not.
Continue reading ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

How to Install MySQL 8 on CentOS

In this article, we will see How to Install MySQL 8 on CentOS 7.

MySQL 8 Installation on CentOS step by step:

Following are the commands used to install MySQL on CentOS:

1. wget https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

2. yum install mysql80-community-release-el7-3.noarch.rpm

3. yum repolist enabled | grep “mysql.*-community.*”
Continue reading How to Install MySQL 8 on CentOS